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.
Advanced Techniques For Super Scaling SQL Server
Description
You are a DBA or developer working on applications with mission critical performance requirements so exacting that a level 400~500 understanding of the database engine is required in order to extract every last ounce of performance from the database engine. This session aims to deliver on this by providing a 360 degree via of what what the database engine is doing and how to crack 'Hard' problems involving undocumented waits and spinlock activity that the standard out of the box SQL Server tools provide little or no insight into. Techniques will be covered for performing deep analysis of CPU saturation scenarios, wait analysis at thread level, the trouble shooting bad device drivers, networking and IO down to the full IO path from the database engine right through to device driver level, all via windows performance toolkit.
Learning Objectives
Previous Experience
Tech Covered
performance, DBA