SQL 2005 Self-Paced Lab from PSS

If you still using SQL 2005, or want to learn the below topic, go to download PSS Service Center Lab 2005

Blocking and Deadlocking
In these labs you will use SQLDiag, SQL Profiler, and various DMVs to solve blocking and deadlocking problems.

Performance
In these labs you will use SQLDiag, SQL Profiler, showplan, and ReadTrace to solve various query performance problems.

Debugging
In these labs you will learn more about debugging tools used by the PSS team such as SQLDumper and Windows Debugging Tools to solve problems like a crash of SQL Server.

Server and Data Recovery
In these labs you will learn to how to solve various server and database offline problems.