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.

Query Tuning Training in Early 2017: Boston and Cleveland!

A couple of days ago in Washington DC I presented the final 2016 delivery of my Tuning Your Biggest Queries seminar. The class went really well (at least from my perspective!) and it was a great end to a busy 2016 training schedule.

The seminar has been an absolute joy to teach and I think it is some of the best work I've ever put together. Advanced query tuning is my favorite topic, by far, and there are so many interesting routes through the material that it never seems to get old or boring. At every class attendees have been asking unique and challenging questions that really make things feel dynamic. Plus, thanks to Microsoft's increased release cadence and focus on performance, there are a lot of new and cool things on the horizon that I plan to add to the content in the coming months. Exciting times to be a query tuner!

So all that said, now that this year is closing down, I'm happy to report that I'm already working on more dates for next year! Here are the first two:


Boston area, January 27, 2017 - Information Here

This will be a standalone delivery, which I'm working on in conjunction with (and in support of) the local New England SQL Server users group.


Cleveland, OH, February 3, 2017 - Information Here

Just a week after the Boston class I'll do it again, this time as a pre-con for SQL Saturday 595. And hopefully I can squeeze in a visit to the Rock and Roll Hall of Fame!


Even more dates forthcoming - stay tuned, and I hope to see you in 2017! 

Published Tuesday, December 6, 2016 12:55 PM by Adam Machanic



Nathan said:

Please plan one in Florida.

December 6, 2016 4:56 PM

Adam Machanic said:

@Nathan happy to! What SQL Saturday is nearest to you?

December 6, 2016 5:43 PM

George Walkey said:

Really enjoyed the Class Adam, will study these techniques and put them to good use!

Did you see this yet?

USE HINT query options no longer needing sysadmin

December 7, 2016 7:11 PM

Adam Machanic said:


Glad you enjoyed it! I did see that but I haven't had a chance to really dig into them yet. The really interesting ones, I think, are the row goal one, and the optimized nested loop one. I'm still hoping they'll give us a supported version of 8649, some day...


December 7, 2016 9:12 PM
New Comments to this post are disabled

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