Taking over SQL Server – The BLITZ way…

Yet another gem from @BrentO !

Presentation is here.

Actual script is here. Learn, Leverage, and Enjoy!

The Lynchpin !

This page lists down all the important links related to SQL server (internal and external sites).

Performance Tuning

1. Troubleshooting Performance in SQL Server 2005 (MSDN)
2. How to troubleshooting SQL Server Performance Problems (MS Support)
3. Performance Tuning for TempDB (this blog)
4. SQL DBA Tasks for for good database performance (this blog)
5. Recommended SQL Server Configurations for good Performance (this blog)

High Availability and Recovery

1. Proven High Availability and Disaster Recovery Solutions (SQL Customer Advisory)
2. SQL Server Single Page Recovery (this blog)

Design and Operations Management

1. Moving SQL Server to new Array (this blog)
2. SQL Server 2008 Default File Locations (this blog)

Tools and Other Best Practices

1. SQL Server Performance Tools (this blog)
2. Free SQL Server Tools that might make your life Easy (MS SQL Team)
3. SQL Server 2008 Licensing (this blog)