New Class Week: Performance Tuning in 21 Demos

We first unveiled this class for the PASS Summit, but due to high demand, we’re doing an online version, too.

You’re a developer or DBA who wants to tune indexes and queries to make your application go faster. You don’t like learning by watching slides or reading white papers – you want to jump right into the code and see what happens. You’re the kind of person who loves watching YouTube videos that start with, “Hold my beer and watch this.”

Performance Tuning in 21 Demos

Performance Tuning in 21 Demos

In one demo-filled day with Brent Ozar and Erik Darling, you’ll see SQL Server, Azure SQL DB, and Azure Managed Instances make questionable lifestyle choices. They’ll wildly underestimate the work required with a query, pick the wrong indexes, and jump off the roof into the pool while holding the TV – all in an effort to deliver the right query results. Brent and Erik will show you how to coach the database engine into better performance and less problems.


  • You should be comfortable writing queries, but not at all comfortable with making them go faster.
  • If you want to follow along on your own computer, get the free Stack Overflow 2013 database
  • Some of the demos will only work on specific SQL Server versions, like 2019 or 2017 – we’ll note that where applicable

Check it out, and if you’re a member of our Live Class Season Pass, you can register to join now. I wouldn’t buy it with your hard-earned cash, though, because on Thursday, November 1st, we’ll launch our Black Friday sale. Time to start asking the boss about this year’s training budget….

Previous Post
What’s New in SQL Server 2019 System Tables
Next Post
New Class Week: Fundamentals of Azure Data Factory

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.