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.
Analysis of your SQL Server like a PRO
Description
SQL Server is a mission critical database platform but is sensitive to
misconfigurations, bad practices, sub-optimal indexing strategies and poor
coding mistakes. Even the fastest hardware can end up performing like a ZX-81
if you get things wrong.
If you are a Database Administrator or Consultant who is responsible for
expert performance analysis, problem detection and tuning of the SQL engine
then it is important you are able to analyze and tune SQL Server like a BOSS.
In this full training day, I will explain how to identify and resolve
serious real world performance problems using concrete examples,
demonstrations, possible effects and answers. This workshop will provide over
40 scripts which can be used directly in the workshop on your own machines
during the day and we shall simulate performance problems and look to resolve
them using a top-down approach.
A selection of things you can look forward to learning and experiencing
during the day are:
misconfigurations, bad practices, sub-optimal indexing strategies and poor
coding mistakes. Even the fastest hardware can end up performing like a ZX-81
if you get things wrong.
If you are a Database Administrator or Consultant who is responsible for
expert performance analysis, problem detection and tuning of the SQL engine
then it is important you are able to analyze and tune SQL Server like a BOSS.
In this full training day, I will explain how to identify and resolve
serious real world performance problems using concrete examples,
demonstrations, possible effects and answers. This workshop will provide over
40 scripts which can be used directly in the workshop on your own machines
during the day and we shall simulate performance problems and look to resolve
them using a top-down approach.
A selection of things you can look forward to learning and experiencing
during the day are:
- Waits and Queues methodology
- Instance and database level configuration
- TempDB importance and optimization
- Index Analysis and tuning
- Humour (yes Germans can be funny too!)
Learning Objectives
Previous Experience
Tech Covered
performance