SQL Server 2025 Optimized Locking w/ John Morehouse and Monica Morehouse

Meeting IN-PERSON
Monday, February 9, 2025
Networking begins at 6:15PM
Speaker will begin 6:30
Location:
Improving Atlanta Offices
11675 Rainwater Dr #100
Alpharetta, GA 30009

# Deep Dive into SQL Server 2025 Optimized Locking w/ John Morehouse and Monica Morehouse

Originally introduced in Azure SQL Database, Optimized Locking arrives in SQL Server 2025 to tackle long-standing locking challenges while significantly improving performance and transactional concurrency. This feature is a true game changer for concurrency control, increasing transaction throughput and dramatically reducing unintended blocking—yes, even those infamous “oops” table locks.
In this session, we’ll dive into how Optimized Locking works under the covers, explore its architecture and implementation, and discuss best practices for getting the most out of it. Along the way, we’ll also cover real-world gotchas we’ve already uncovered, so you can confidently adopt this feature and avoid common pitfalls.
Whether you’re battling blocking today or planning ahead for SQL Server 2025, this session will help you unlock the full potential of Optimized Locking.

### Monica Morehouse (Rathbun)

Monica is a Microsoft MVP for Data Platform, resides in Virginia and brings two decades of experience across various database platforms, with a particular focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences, where she shares her expertise on performance tuning and configuration management for both on-premises and cloud environments. Monica leads the Hampton Roads SQL Server User Group and is passionate about SQL Server and its community, she is dedicated to giving back in any way she can. You can often find her online (@sqlespresso) offering helpful tips or blogging at sqlespresso.com.

### John Morehouse

John is a Principal Consultant living in Chesapeake, Virginia. Honored to be a Microsoft Data Platform MVP & former VMWare vExpert, having over 2 decades of technical experience, John now focuses on solving crucial business problems with Microsoft SQL Server oriented solutions. John has a passion around speaking, teaching technical topics and giving back to his community whenever possible. He is a blogger, avid tweeter, and a frequent speaker at conferences and user groups whenever possible. If you want to find John, you can find him on Twitter (@sqlrus) or on his blog, http://sqlrus.com.

Target audience
Database developers and DBAs who want to learn more about migration of SQL Server workloads to the cloud.