Dear SQL DBA artwork

Jer and Kendar Explore Optimized Locking

Dear SQL DBA

English - September 04, 2023 14:56 - 28 minutes - 26.8 MB - ★★★★★ - 26 ratings
Technology Education How To dba databases sqlserver sqlworkbooks Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Previous Episode: Advice for Technical Leaders with Alex Robson
Next Episode: Automated Deployments and the Art of the Database with Database Michael J Swart

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

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