If you want to attend my live online classes, it’s really easy: just buy a Live Class Season Pass and you can drop in on any class that works for your schedule.
I recommend attending ’em in this order:
- Fundamentals, required, in this order: Index Tuning, Query Tuning, Parameter Sniffing
- Fundamentals, optional: Columnstore, TempDB (can be taken in any order)
- Mastering, required, in this order: Index Tuning, Query Tuning, Parameter Sniffing, Server Tuning
So I schedule ’em in that order, too. Here are the rotations for the rest of this year and all of next year for your scheduling pleasure:
Summer/Fall 2021 Rotation:
I’m in the midst of an EU-friendly time schedule rotation:
- June 15-17: Mastering Query Tuning – Add to Calendar (Europe-friendly times)
- July 14-16: Mastering Server Tuning – Add to Calendar (Europe-friendly times)
And here’s the next US-friendly time schedule rotation:
- July 19-21: Mastering Index Tuning – Add to Calendar
- August 17-19: Mastering Query Tuning – Add to Calendar
- August 31-Sept 2: Mastering Parameter Sniffing – Add to Calendar
- Sept 21-23: Mastering Server Tuning – Add to Calendar
Fall Fundamentals:
All of the Fundamentals classes share these prerequisites except where noted.
- Oct 12: How to Think Like the Engine – Add to Calendar (Europe-friendly times)
- Oct 13: How to Think Like the Engine – Add to Calendar
- Oct 19: How I Use the First Responder Kit – Add to Calendar (Europe-friendly times) – Prerequisites
- Oct 20: How I Use the First Responder Kit – Add to Calendar – Prerequisites
- Oct 26: Fundamentals of Index Tuning – Add to Calendar (Europe-friendly times)
- Oct 27: Fundamentals of Index Tuning – Add to Calendar
- Nov 2: Fundamentals of Query Tuning – Add to Calendar (Europe-friendly times)
- Nov 3: Fundamentals of Query Tuning – Add to Calendar
- Nov 16: Fundamentals of Columnstore – Add to Calendar (Europe-friendly times)
- Nov 17: Fundamentals of Columnstore – Add to Calendar
- Nov 23: Fundamentals of TempDB – Add to Calendar (Europe-friendly times)
- Nov 24: Fundamentals of TempDB – Add to Calendar
Winter 2022 Mastering Rotation:
The Mastering classes require this VM setup.
- Dec 6-8: Mastering Index Tuning – Add to Calendar (Europe-friendly times)
- Dec 8-10: Mastering Index Tuning – Add to Calendar
- Jan 10-12, 2022: Mastering Query Tuning – Add to Calendar (Europe-friendly times)
- Jan 12-14, 2022: Mastering Query Tuning – Add to Calendar
- Feb 7-9: Mastering Parameter Sniffing – Add to Calendar (Europe-friendly times)
- Feb 9-11: Mastering Parameter Sniffing – Add to Calendar
- Mar 7-9: Mastering Server Tuning – Add to Calendar (Europe-friendly times)
- Mar 9-11: Mastering Server Tuning – Add to Calendar
Spring/Summer 2022 Rotation:
All of the Fundamentals classes share these prerequisites except where noted, and the Mastering classes require this VM setup.
- March 14-18: Fundamentals Week, US-friendly times
Monday: How I Use the First Responder Kit – Add to Calendar – Prerequisites
Tuesday: Fundamentals of Index Tuning – Add to Calendar
Wednesday: Fundamentals of Query Tuning – Add to Calendar
Thursday: Fundamentals of Parameter Sniffing – Add to Calendar
Friday: Fundamentals of Columnstore – Add to Calendar - March 21-25: Fundamentals Week, Europe-friendly times
Monday: How I Use the First Responder Kit – Add to Calendar – Prerequisites
Tuesday: Fundamentals of Index Tuning – Add to Calendar
Wednesday: Fundamentals of Query Tuning – Add to Calendar
Thursday: Fundamentals of Parameter Sniffing – Add to Calendar
Friday: Fundamentals of Columnstore – Add to Calendar - April 4-6: Mastering Index Tuning – Add to Calendar (Europe-friendly times)
- April 6-8: Mastering Index Tuning – Add to Calendar
- May 2-4: Mastering Query Tuning – Add to Calendar (Europe-friendly times)
- May 4-6: Mastering Query Tuning – Add to Calendar
- June 13-15: Mastering Parameter Sniffing – Add to Calendar (Europe-friendly times)
- June 15-17: Mastering Parameter Sniffing – Add to Calendar
- July 11-13: Mastering Server Tuning – Add to Calendar (Europe-friendly times)
- July 13-15: Mastering Server Tuning – Add to Calendar
Summer/Fall 2022 Rotation:
All of the Fundamentals classes share these prerequisites except where noted, and the Mastering classes require this VM setup.
- June 27-July 1: Fundamentals Week, US-friendly times
Monday: How I Use the First Responder Kit – Add to Calendar – Prerequisites
Tuesday: Fundamentals of Index Tuning – Add to Calendar
Wednesday: Fundamentals of Query Tuning – Add to Calendar
Thursday: Fundamentals of Parameter Sniffing – Add to Calendar
Friday: Fundamentals of Columnstore – Add to Calendar - July 4-8: Fundamentals Week, Europe-friendly times
Monday: How I Use the First Responder Kit – Add to Calendar – Prerequisites
Tuesday: Fundamentals of Index Tuning – Add to Calendar
Wednesday: Fundamentals of Query Tuning – Add to Calendar
Thursday: Fundamentals of Parameter Sniffing – Add to Calendar
Friday: Fundamentals of Columnstore – Add to Calendar - Aug 1-3: Mastering Index Tuning – Add to Calendar (Europe-friendly times)
- Aug 3-5: Mastering Index Tuning – Add to Calendar
- Aug 29-31: Mastering Query Tuning – Add to Calendar (Europe-friendly times)
- Aug 31-Sept 2: Mastering Query Tuning – Add to Calendar
- Sept 26-28: Mastering Parameter Sniffing – Add to Calendar (Europe-friendly times)
- Sept 28-30: Mastering Parameter Sniffing – Add to Calendar
- Oct 24-26: Mastering Server Tuning – Add to Calendar (Europe-friendly times)
- Oct 26-28: Mastering Server Tuning – Add to Calendar
Can’t attend live? Check out the recordings.
You can buy a Recorded Class Season Pass of the Fundamentals classes, or of the Mastering classes. That gives you the ability to stream the most recent recordings of each class anytime you want on your desktop, laptop, tablet, phone, or Internet-connected fridge.
Whew! That’s about enough scheduling for a while. I do have plans to bring out two more training classes in 2022, but I’m not quite ready to announce those yet. And as always, your Season Passes include access to any new classes that I bring out during your subscription. (I don’t plan to do any in-person classes during 2021 or 2022.)
See you in class!
