The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
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