Here's what's changed recently:

2026-09-12:

• New separate modules for filtered indexes, indexed views, computed columns, automatic indexing through time, choosing between partitioned tables & views, how to get seeks on the second column of an index, and tuning indexes for specific queries.
• Labs 3, 4, and 5 are all-new.
• Reordered all of the modules for the new 5-day class format.

2026-05-17:

• DEATH Method, A Steps - rewrote this module from scratch based on how I approach it in SQL Server 2019 & newer. I also re-recorded the lab setup & lab solution videos based on how I do it these days, and showed how AI doesn't quite cut it yet.
• Reordered some sessions for a better learning progression.

2025-11-21:

• Using an Index's Second Column with Skip Scans - added this new module.

2025-11-15:

• Starting with the D.E. - re-recorded with updated guidance about my new 10 & 5 guideline, and more thoughts about when it's okay to have more indexes per table.
• Blocking - added a new video to demo SQL Server 2025's new Optimized Locking.

2025-11-11:

• Indexing for JSON Queries - added this new module explaining SQL Server 2025's new JSON indexes. sp_BlitzIndex only has preliminary support for these indexes right now, and I'll re-record this module once I've got full support coded in there.