Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
By Kendra Little on September 4, 2023
SQL Server has a new feature that’s currently only available in Azure SQL Database: Optimized Locking.
Jeremiah Peschka joins Kendra (aka Kendar) to talk through the docs and nerd out on locks, blocks, and how to pronounce the acronym “LAQ”.
Prefer to explore optimized locking with a diagram? I’ve also got a little sketchnote for ya.
Podcast episode
Sketchnote of optimized locking concepts
Here’s a sketchnote style comic I drew up of what I’ve learned about the feature so far.
Right click and open in new tab for larger image
Learn more about optimized locking
Learn more about this feature online:
- Optimized locking article
- Transaction locking and row versioning guide <– A much longer read
Find more from the Dear SQL DBA Podcast and Jeremiah Peschka
This is Episode 78 of the Dear SQL DBA Podcast.
Read more from Jeremiah Peschka at facility9.com.