THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

[New England] Kalen Delaney Internals and Query Tuning - in the Boston area October 12-16

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.

Published Thursday, July 23, 2009 11:16 AM by Adam Machanic

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



نمنلننلنننلننبلننلننلننلننلبننلنلننلنلنلنلننلنانلنلنبننلنبنننابننبلنلنمبلنلنلمنلنبلنمبنلنبلنمنلبنلنمبنلمبنلنبلنمبنلنبملنبنلنمبنلمنبلنلمبلننلنبنلنلمبنلنبلنبنلبلنبنلنل said:











October 12, 2009 2:18 AM

Leave a Comment


About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement