Exploring Optimized Locking

Our March meeting will be led by our great partner and sponsor TEKsystems.

Note: TEKsystems will be in-person for this event. The meeting will NOT be streamed.

Session Abstract:

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.

Sponsor: TEKsystems

TEKsystems has been a long-time valued supporter of the Louisville Data Technology User Group and as we attempt to come back to in-person they are helping to provide the venue, along with food and drinks. We thank them so much for their continued support.

Furthermore, TEKsystems has continued to push the boundaries of possible while providing exceptional service to their customers and consultants. Your future isn't waiting for an invitation so if you are looking for what's next, make sure to contact one of their fantastic recruiters.