You need to speed up a SQL Server app, and you’re allowed to change the queries and indexes – but not the server hardware or settings. Good news – I’ll teach you how in 3 days of learning and fun. Join me, Brent Ozar, as I explain how to make your SQL Server apps go faster.

Labs & lectures include:

  • How SQL Server builds query plans
  • How to find the queries you need to focus on first so end users will notice an improvement
  • How to choose between CTEs, temp tables, and APPLY
  • How to tune for SELECT * and lots of rows
  • How to write dynamic SQL that scales
  • How to avoid pitfalls like deadlocks and bad batching
  • How SQL Server 2017 & 2019’s new robots help (and hurt)

Your Progress So Far in This Class

This is driven by the mark-as-complete buttons in each module of the class. (Let’s be honest: you’re probably just going to mark them as complete because you’re that kind of student. I feel you.)

Introductions

Click on the modules on the right side of the page to keep moving through the class.

Menu