John Morehouse: Exploring Optimized Locking

IN PERSON MEETING!!!!! TOPIC and SPEAKER CHANGE

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 session, we'll embark on a journey into this new capability, designed to revolutionize concurrency control and improve transaction throughput. We'll examine the underlying mechanism while providing insights into its architecture, implementation, and best practices for maximizing performance.
You will -

• Learn how optimized locking works
• Discover what it requires to function
• Some Gotchas to be aware of

Whether you're a seasoned database professional or a curious developer, this session offers a more profound understanding of the new Azure SQL Database's optimized locking feature.