T-SQL & Development

Mastering Class Updates on Resource_Semaphore, The Ascending Key Problem, and The Cloud

Mastering Query TuningI’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 I wanted to record it right away in my home studio while it was fresh in my memory.

Folks who own the Recorded Class Season Pass: Mastering will also notice new modules in their Mastering Server Tuning class. At the bottom of that class, there are new modules appearing for Faster, Cheaper Cloud Databases. It’s the training day workshop I gave at Data Saturday Croatia & SQLBits over the last couple of weeks. I’ve tweaked the content to cover more of the attendees’ questions, and I’ll be giving it as a thank-you to folks with current Mastering memberships. You’ll see the modules get added gradually over the next few days as I record ’em. Enjoy!

Free, 3× a week

Get my new posts by email

Three posts a week, plus a Monday roundup of the best database news from around the web.

2 comments

  1. Thanks for the new stuff. The lifetime pass to recorded sessions has been one of the best training investments I have made. I just need to make more time to watch them.

Leave a comment

Your email address will not be published. Required fields are marked *

Email me about new comments: