Session room

The Agenda

Agenda Home

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.
DataOps

The Professional Performance Tuning Blueprint

Description

Searching the internet for every problem isn't cutting it. You need to be more proactive and efficient when it comes to finding and solving database performance fires.

I work with consulting customers around the world to put out SQL Server performance fires. In this day of learning, I will teach you how to find and fix your worst SQL Server problems using the same modern tools and techniques which I use every week.

You'll learn tons of new and effective approaches to common performance problems, how to figure out what's going on in your query plans, and how indexes really work to make your queries faster. Together, we'll tackle query rewrites, batch mode, how to design indexes, and how to gather all the information you need to analyze performance.

This day of learning will teach you cutting edge techniques which you can't find in training by folks who don't spend time in the real world tuning performance. Performance tuning mysteries can easily leave you stumbling through your work week, unsure if you're focusing on the right things. You'll walk out of this class confident in your abilities to fix performance issues once and for all.

If you want to put out SQL Server performance fires, this is the precon you need to attend. Anyone can have a plan, it takes a professional to have a blueprint.

Feedback link https://sqlb.it/?6197

Learning Objectives

Previous Experience

Tech Covered

SQL 2019, Query Store, DMV, Database engine, DataOps, On Premise, Future DBA, Operational Databases, Developing, Monitoring, Optimising, SQL 2022, On Premises