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.

Learn Advanced Query Tuning in Washington DC

Just about every database professional on Earth has the same goal: Make things faster.

There are numerous ways to achieve that goal, but for many people it comes down to a series of hunches, guesses, and trying whatever seemed to work last time.

What if there was a more efficient way to get the job done? What if you could understand what's going on under the covers, know your options, and make the right moves for your actual situation?

That's what my full-day Tuning Your Biggest Queries seminar is all about. In this unique class you'll learn about how the query processor works, how the query optimizer thinks, and how you can leverage an understanding of these internals to make your queries faster. What really sets this content apart is that there is almost no focus on indexing -- only a very brief discussion at the end of the day, and only after you've already learned how to improve query performance by orders of magnitude through rewrites.

The idea is not to make you an index champion. The idea is to set you on the path to advanced query tuning mastery.

I am pleased to announce the final 2016 public delivery of the seminar -- Friday, December 2, in Washington DC. And you can get early bird pricing through the end of this week!

This delivery will act as a pre-conference seminar for SQL Saturday DC, but you are free to attend either or both.

An updated course outline follows. Looking forward to seeing you there!

Tuning Your Biggest Queries - December 2 - Washington DC 

Module 1: Query Plans

  • How Query Plans Really Work
  • Data Acquisition Iterators
  • Join Iterators
  • Aggregation and Analysis Iterators
  • Parallel Processing 

Module 2: Plan Shaping

  • T-SQL Rewrites That Waste Your Time
  • T-SQL Rewrites That Work
  • Query Hints
  • Leveraging Row Goals For Plan Control
  • Understanding Ideal Plan Shape
  • Performance Debugging Complex Plans 

Module 3: Index Optimization 

  • The Levels of Index Understanding 
  • How B*Tree Indexes Really Work
  • How to Design Optimal B*Tree Indexes
  • How to Choose Among Indexing Options
  • Columnstores vs. B*Trees 


Published Tuesday, October 25, 2016 9:40 AM by Adam Machanic



Alvaro Costa said:

Hi Adam, Any possible way you could present this down here in FL?

October 31, 2016 11:23 PM

Adam Machanic said:


Yes, I would be happy to do so. Are there any upcoming SQL Saturday events in your area? Alternatively I can do private delivery for your company. Or a standalone public event, if there is a strong demand. What do you think?


November 1, 2016 9:46 AM
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