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.
Total Server Performance Tuning
Description
You`ve been working with SQL Server for a few years, and you`re sick and tired of not being able to understand how it all works.
Every day, you stare at monitoring tool charts and graphs, wait stats, and widgets, and none of it seems to add up.
In this fast paced full day of demos, I`m going to show you how queries interact with your server, and each other.
You`ll discover that concurrency isn`t just about locking and blocking; concurrency is also about hardware.
I`m going to teach you how to diagnose your worst server issues and practical ways to solve them.
Pre-requisites
Beginner to intermediate experience performance tuning SQL Server. Looking at wait stats, and elements of query plans.
Laptop Required:Yes
- Software: SSMS and a local SQL Server instance are only required if they want to follow along with demos.
- Subscriptions: No
Learning Objectives
Previous Experience
Tech Covered
performance, tuning, SQL, SQL Server, Monitoring