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.
Mastering Index Tuning
Description
You need to speed up a SQL Server app, but you only want to make index changes. You don’t want to buy hardware, change SQL Server, or change the code. I'll teach you the most important advanced lessons in one day.
You'll learn:
- My D.E.A.T.H. Method to quickly redesign indexes in an existing database
- How to use sp_BlitzIndex to Deduplicate & Eliminate indexes that need to get out
- How to use sp_BlitzCache to Add & Tune indexes based on your query workloads
- When to resort to Hand-crafted indexes like filtered indexes, indexed views, and indexed computed columns
The day will be 25% slides, 75% demos, and 100% useful for both cloud and on-premises installations. I'll be using the Stack Overflow 2013 database, and you're welcome to follow along: just bring a laptop with SQL Server 2016 or newer, or have an Azure SQL DB instance with the Stack Overflow 2013 database already installed.
Learning Objectives
Previous Experience
Tech Covered
On-prem, Cloud, performance, tuning, SQL 2019, Azure SQL Database, Managed Instance, DMV, indexing, T-SQL, Database engine, Optimising