Sep 04 2023 28 mins 23
SQL Server has a new feature that’s currently only available in Azure SQL Database: Optimized Locking. Jeremiah Peschka joins the podcast to talk through the docs and nerd out on locks, blocks, and how to pronounce the acronym “LAQ”.
Learn more about this feature online:
- Optimized locking article from Microsoft Learn
- Transaction locking and row versioning guide <– A much longer read on Microsoft Learn
- Kendra's Sketchnote diagram of Optimized Locking
