SESSION Details

The Professional Performance Tuning Blueprint

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

Starts: 09:00 9th Mar 2022
Ends: 17:00 9th Mar 2022

Q&As

Short Description
- Getting The Best Performance From Your Worst Queries
Should delegates bring a laptop with them?
- Only if they plan to follow along. Not necessary.
What software and licences do they need?
- SSMS, SQL Server 2017+, a copy of the Stack Overflow database (I provide).
What is the structure of the day?
- Just about 100% demos, with some intro/setup slides and plenty of time for Q&A.
What internet requirements do the delegates have?
- None
What will the delegates get out of the day?
- A full day of modern performance tuning and monitoring techniques, along with recorded access to the videos, and a really cool t-shirt.

Speakers

Erik Darling

Tags

On PremisesDataOpsFuture DBAOperational DatabasesDevelopingMonitoringOptimisingDatabase EngineDMVQuery StoreSQL 2019SQL 2022AdvancedHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.