Change Log for This Class
Here's what's changed recently:
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.