Here's what's changed recently:
2026-10-02: Tons of new stuff!
- New modules on My Favorite Query Hints, Option Recompile, How NOLOCK Makes Queries Faster, Finding and Fixing Blocking, How Feedback and Adaptation Try to Help, and AI: The Elephant in the Room
- Reorganized the content for my new 5-half-day class format
2025-11-16:
- The Architect and the Builder - updated and expanded all of these modules using SQL Server 2025.
- Dynamic SQL - updated, expanded, and broke into two modules to elaborate on more stuff with SQL Server 2025.
- Avoiding Deadlocks by Modifying T-SQL - added a new video to demo SQL Server 2025's new Optimized Locking.
- Lab setup intro videos - re-recorded with logistical updates, but no need for you to re-watch those if you've already done the labs, and the labs themselves didn't change.
2025-11-12:
- Tuning for Select Star and Lots of Rows - re-recorded with SQL Server 2025 just to show & explain that 2025's PSPO and OPPO don't fix the problem we're addressing.