As I've mentioned here, for the first time in many years I have decided to offer a public class through a new training partner: Boston SQL Server Training. The class, being organized by Adam Machanic, is scheduled for the week of October 12. I have been very pleased with the interest, and the course was full enough to be guaranteed to run several months ago. There are still a few seats left however but we do expect this class to fill up.
Due to my drastic reduction in travel, this may be the last (or only?) time that I'll be teaching in Boston. Or at least, it will the the last class for quite a while. Here's a summary of the course:
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.
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.
You can see the full course description here:
SQL Server 2008 Internals and Tuning
Looks like fun, doesn't it?
~Kalen