SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Locking, Blocking, Row Versions: Concurrency for Performance
Description
SQL Server offers two methods for applications to provide
data consistency: Pessimistic and Optimistic Concurrency Control. In this
seminar we’ll discuss what consistency might mean to your applications, and
describe the details of how each concurrency model works internally. We’ll
examine the costs and trade-offs between the two models. Finally, we’ll examine
the metadata and tools available for analyzing and troubleshooting problems.
Goals:
- Understand why concurrency management is a crucial part of database and application tuning
- Explore the details of how SQL Server implements pessimistic concurrency with locking, and when optimistic concurrency can be a useful alternative
- Look at how in-memory OLTP changes the whole concurrency story!
Learning Objectives
Previous Experience
Tech Covered
performance, memory