I’ve posted a couple of updated videos to my Mastering courses.
In Mastering Server Tuning, I updated and expanded the RESOURCE_SEMAPHORE module to cover more details about query workspace grants, plus cover SQL Server 2022’s updates to Adaptive Memory Grants.
In Mastering Query Tuning, I added a new module on the Ascending Key Problem. It’s a session I first gave this weekend at the SQLBits conference in London, and I’m tickled pink with how it went. Bits records all their sessions and publishes ’em free on their site eventually, so at some point that’ll be free to the public, but