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

From the creator

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! Chapters: 00:00 - Introduction 02:56 - In today's world 04:54 - Current Locking 05:22 - With Optimized Locking 07:50 - Optimized Locking 09:40 - Gotchas Recommended resources: Optimized locking: https://learn.microsoft.com/en-us/sql/relational-databases/performance/optimized-locking?view=azuresqldb-current About John Morehouse: John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, 2016 Idera Ace, Friend of Red Gate, Sentry One PAC member & Community Ambassador. John has a passion around speaking, teaching technical topics and giving back to the technical community as much as possible. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker a

Published 2024-03-26 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.