Fabcon Europe 26
Conference Sessions
Databases in Fabric
SQL Server & Azure SQL
Exploring Optimized Locking in SQL Server 2025
Database Admin (DBA)
/ Developer
/ IT Pro
/ Software Architect
/ Software Developer
Level 300
SPEAKERS
John Morehouse
MVP
Denny Cherry & Associates
Monica Morehouse
MVP
Denny Cherry & Associates Consulting
ABOUT THE SESSION
Updating data in SQL Server can lead to lock escalation, blocking, deadlocks, and poor performance when not handled correctly. The optimized locking feature, introduced in Azure SQL Database and now available in SQL Server 2025, helps reduce contention and improve concurrency.
In this session, we’ll explore the architecture, implementation, and limitations of optimized locking. You’ll leave with a solid understanding of how it reduces blocking and improves performance in real-world workloads.
MEET THE SPEAKERS
John Morehouse
MVP
Denny Cherry & Associates
Monica Morehouse
MVP
Denny Cherry & Associates Consulting
