A Microsoft white paper on using the Resource Governor in SQL Server 2008 to monitor and control CPU and memory use, with scenarios and best practices.
SQL SERVER – Disk Partition Alignment Best Practices
Disk partition alignment is an often overlooked way to improve SQL Server I/O performance. A pointer to Microsoft’s paper on aligned and nonaligned storage.
SQLAuthority News – Using SQL Server 2008 Extended Events – White paper By Jonathan Kehayias
A really good white paper by Jonathan Kehayias on using SQL Server 2008 extended events, from the basics to architecture and system objects.
SQLAuthority News – Troubleshooting Performance Problems in SQL Server 2008
Troubleshooting Performance Problems in SQL Server 2008, a Microsoft technical article on finding why a database slows down and how to fix it.
SQLAuthority News – Security White Papers
Two Microsoft Dynamics AX 2009 security white papers: configuring Kerberos authentication with Role Centers, and Enterprise Portal with SQL Reporting.
SQLAuthority News – SQL Server White Paper: SQL Server 2008 Compliance Guide
The SQL Server 2008 Compliance Guide white paper shows how to use SQL Server 2008 features to meet regulatory needs, alongside the compliance SDK.
SQLAuthority News – SQL Server Security Whitepapers
Three SQL Server security whitepapers from Microsoft worth reading, including separation of duties for developers and database encryption in SQL Server 2008.