One-Day Fundamentals

You need to make SQL Server fast and reliable. I do this stuff in real life every week, and I can teach you how to make it happen.

Start with the top left box (How I Use the First Responder Kit) and then only take classes that border classes you’ve already taken. For example, after the FRK class, take Fundamentals of Index Tuning, then either Fundamentals of Query Tuning or Fundamentals of Columnstore.

Recorded Class Season Pass

Want all of my Fundamentals? Get access to lots of self-paced recorded training for one low price.

You’ve downloaded my First Responder Kit with sp_Blitz, sp_BlitzCache, sp_BlitzIndex, and more, but you feel like you’re groping around blindly in the back seat of a car. Learn how I use these tools.

Fundamentals of Index Tuning

The easiest way to make all of your queries go faster is to build the right indexes to support them. Learn how in one day.

Fundamentals of Query Tuning

You want faster queries, but you’re not comfortable reading execution plans, finding problems, and tuning T-SQL. Learn how in one day.

A query just suddenly runs slowly. Your fix is to update stats or rebuild indexes. It seems to work, but you don’t know why, and it keeps coming back. Understand why in one day.

DBA Job Interview Questions and Answers

You don’t go to a lot of job interviews, and you don’t really talk about what you do for a living. So how are you supposed to pass these things? I’ll show you how to ace it.

Fundamentals of Columnstore Indexes

Your report queries are too slow, and regular indexes aren’t enough. You’re on SQL 2016 or newer, and your data’s up over 250GB. Find out if columnstore indexes can help.

You want to learn how to troubleshoot temp table plan reuse, the version store, latch contention, and where to put the files. Learn in one day.

Mastering Performance Tuning

You’ve conquered the fundamentals, and now you’re ready for the toughest challenges.

My Mastering classes are live 3-day classes that push you harder than any other class or conference out there. In the morning, I teach you a concept with lectures & demos, and then you get 2 hours to do lunch and solve a tough lab with live queries. Then, the process starts again in the afternoon.

Most of my Mastering students get my Live Class Season Pass because they’ve already attended a few of my Fundamentals classes, and they trust me to raise their skill levels rapidly in just one year. Plus, they get Instant Replay access, so they can watch the most recent live classes whenever they want, jumping into a specific module when they’re facing a relevant problem at work.

Live Class Season Pass

The Live Class Season Pass gets you into all my live online classes for a year straight, over and over – including both my Fundamentals and Mastering classes, plus any new classes I bring out during your membership.

Want to learn quickly at your own rapid pace? Don’t need to wait for live classes? The Masters Class Recordings let you watch the Instant Replays of my most recent classes and work the labs on your own.

Mastering Index Tuning

You don’t have time to fix queries, and you need quick wins. Learn how to use my D.E.A.T.H. Method to fix indexes on an existing database, fast, in 3 days of live lab challenges.

Mastering Query Tuning

You need to speed up an existing app, and you’re allowed to change both queries & indexes, but you can’t throw hardware at it. Let’s tackle it in 3 days of live labs.

You’ve conquered Fundamentals of Parameter Sniffing, and now you need to master all the different ways to mitigate parameter sniffing problems for good. I’ll show you in 3 days of nonstop demos and labs.

Mastering Server Tuning

You’re the kind of admin who’s constantly facing new performance challenges on different servers. Learn how to solve lots of different problems in 3 days of my toughest lectures & labs.