In case you missed Kalen's post, we're excited to announce that she will be joining us here on the East Coast in October to deliver her SQL Server 2005/2008 Internals and Query Tuning seminar. This is, to my knowledge, the most advanced public SQL Server course to be offered in the Boston area in the last 5 years, and this is the first time that Kalen has ever taught in the area. I hope that some of you will be able to take advantage of this rare opportunity to really take your SQL Server skills to the next level.
The course location is the Microsoft Technology Center in Waltham, MA, and the course will run from Monday October 12 through Friday October 16. You can get more information about the course from the Web site, but following is an overview:
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.
If you would like to register, you can do so on the registration page. If you have any questions, feel free to write a message here, contact me via my blog, or via the e-mail address on the Boston SQL Training front page.