Here are some useful links that I've been coming across in my recent travels. These ones are mainly for DBAs.
- Using dynamic management views to monitor and tune performance of SQL Server. New in 2005 and expanded in 2008, these allow you to query aspects of the DBMS
- Data collection the automated way in SQL Server 2008. A blog on one of the new features of SQL Server 2008.