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.
Faster Queries Without NOLOCK!
Description
SQL Server offers two methods for applications to provide multi-user concurrency and 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.
- Why is concurrency management a crucial part of database tuning?
- How does SQL Server implement pessimistic concurrency with locking?
- How do we get true optimistic concurrency?
Pre-requisites
Basic knowledge of TSQL Querying
Laptop Required: Optional
- Software: Delegates can follow along with some of the demos if they have a laptop with SQL Server 16 or later installed, with the latest Management Studio,.
- Subscriptions: They can connect to an Azure SQL Server or SQL DB if they do not have a local one, but it is not required.
Learning Objectives
Things I will need
Tech Covered
Azure, troubleshooting, tuning, Database, SQL, Tools, SQL Server