Exploring Optimized Locking In SQL Server 2025

This session is primarily about sql server & databases within the Microsoft Fabric and SQL ecosystem. Updating data in SQL Server can lead to lock escalation, blocking, deadlocks, or slow performance if it isn't done correctly. The newly released optimized locking helps reduce these issues while improving concurrency. This session explores how it works—covering its architecture, implementation, and best practices to maximize performance to help reduce those dreaded locking issues!