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.
Performance Tuning When You Can't Fix the Queries
Description
Your users are frustrated because the app is too slow, but you can’t change the queries. Maybe it’s a third party app, or maybe you’re using generated code, or maybe you’re just not allowed to change it. Take heart – there’s still hope. Brent Ozar does this every week, and he’ll share his proven methodologies to performance tune with indexes, SQL Server configuration switches, and hardware. In this one-day workshop, you’ll learn:
- Simplified internals – how SQL Server turns your query into an execution plan
- Wait stats solutions – a list of fixes for most common bottlenecks
- Plan cache analysis – how to discover the most resource-intensive queries so you know if indexes and hardware will work
- Monitoring metrics – what DMVs and Perfmon counters to monitor, and what thresholds to alert on
- Hardware warning signs – how to prove your server is undersized for your workloads
- Tools and scripts – the best free and paid tools to make your tuning job easier
Learning Objectives
Previous Experience
Tech Covered
performance