Introduction to Optimized Locking in Azure SQL Database | Data Exposed: MVP Edition

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.

When updating data in SQL Server, operators run the gambit of incurring issues if not done correctly. Sometimes, they manifested as lock escalation, the dreaded blocking, disastrous deadlocks, or poor performance. With the release of Optimized Locking in Azure SQL Database, issues are mitigated while helping to enhance performance and transactional concurrency. In this quick 10-minute episode of Data Exposed, we’ll showcase how this new feature helps prevent those manifestations!


Watch on Data Exposed



Optimized locking


View/share our latest episodes on Microsoft Learn and YouTube!

Leave a Reply

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


This site uses Akismet to reduce spam. Learn how your comment data is processed.