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.
Understanding Execution Plans
Description
For troubleshooting long running queries, looking at the execution plan is often a good starting point. Once you know how the query is executed, you know why it's slow and what you can do to speed it up.
But what if the execution plan is just beyond your understanding? What if it uses operators you have seen before, but do not really understand? What if you look at the execution plan, but just don't see the problem?
In this full-day seminar, you will learn everything you need to be able to read and understand any execution plan. We'll start with an overview of execution plans as a whole, and then dive in and look at all the components, and how they fit together. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.
Whether you have read your share of execution plans or whether you wouldn't know where to find them, this seminar will teach you everything you need to know about execution plans. Attend this seminar if you want to hone your tuning skills!
Throughout the day, we will have exercises to help you get an even better understanding of the theory. In order to get the most out of the day, attendees are encouraged to bring their own laptop, with SQL Server (any version), Management Studio, and the AdventureWorks sample database installed.
Note: I have preeviously presented this pre-con in Exeter; all attendees gave me 5 out of 5 possible points on the evaluation forms. I have also presented this pre-con in Copenhagen and Zagreb (no evaluations received) and I will present it on Oct 31 in Portland, OR
But what if the execution plan is just beyond your understanding? What if it uses operators you have seen before, but do not really understand? What if you look at the execution plan, but just don't see the problem?
In this full-day seminar, you will learn everything you need to be able to read and understand any execution plan. We'll start with an overview of execution plans as a whole, and then dive in and look at all the components, and how they fit together. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.
Whether you have read your share of execution plans or whether you wouldn't know where to find them, this seminar will teach you everything you need to know about execution plans. Attend this seminar if you want to hone your tuning skills!
Throughout the day, we will have exercises to help you get an even better understanding of the theory. In order to get the most out of the day, attendees are encouraged to bring their own laptop, with SQL Server (any version), Management Studio, and the AdventureWorks sample database installed.
Note: I have preeviously presented this pre-con in Exeter; all attendees gave me 5 out of 5 possible points on the evaluation forms. I have also presented this pre-con in Copenhagen and Zagreb (no evaluations received) and I will present it on Oct 31 in Portland, OR
Learning Objectives
Previous Experience
Tech Covered
performance