Kalen Delaney, SQL Superstar presents:

SQL Server 2005/2008 Internals and Query Tuning

This is an advanced 5-day course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2008 and cover features specific to that version, but most of the information is relevant to SQL Server 2005 as well.

This 5-day intensive seminar was developed by one of the world's leading experts in SQL Server internals. Topics to be covered include the following:

• SQL Server Architecture and Metadata
• Physical Storage Structures
• Index Design and Tuning
• Query Processing and Query Plans
• Optimization and Recompilation
• Concurrency Control: Locking, Blocking and Row Level Versioning
• Query Tips and Techniques
• Troubleshooting Tools

The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques. A reference CD including all of the demonstration scripts as well as dozens of whitepapers and useful tools will be distributed at the end of the week.