Description
You’re a developer or DBA who wants to tune indexes and queries to make your application go faster. You don’t like learning by watching slides or reading white papers – you want to jump right into the code and see what happens. You’re the kind of person who loves watching YouTube videos that start with, “Hold my beer and watch this.”
Prerequisites: In one demo-filled day with me, Brent Ozar, you’ll see SQL Server 2017 and 2019 make questionable lifestyle choices. They’ll wildly underestimate the work required with a query, pick the wrong indexes, and jump off the roof into the pool while holding the TV – all in an effort to deliver the right query results. I will show you how to coach the database engine into better performance and less problems.
- You should be comfortable writing queries, but not at all comfortable with making them go faster.
- If you want to follow along on your own computer, get the free Stack Overflow 2013 database
- Some of the demos will only work on specific SQL Server versions, like 2019 or 2017 – we’ll note that where applicable
Some of these dates are in-person, some are online:
- In-person classes are one-day pre-cons before SQLSaturday events. They’re not broadcast online – I’m in the room, speaking, and you gotta be there in person too.
- Online classes are held in GoToWebinar with me live on webcam, taking questions as we go through the material together. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way. For more information, check out the Training Logistics PDF for our online classes.
You can watch again later with Instant Replay – for one year from the date of your course, you can watch a recorded version via online streaming. Brush up on stuff you missed or revisit your favorite topics. It’s the best of both worlds: live training me, plus reminders. (Or, you can just buy the Instant Replay access – save money, and start watching your recordings immediately, streaming them in your browser for a year.)
To see the list of demos, check out the list of modules in the Instant Replay recordings.
Class dates & times:
- Sept 13, 2019 in Boston, MA 9:00-5:00 Eastern – in-person attendees get their choice of a Recorded Class Season Pass, SQL ConstantCare, or the Consultant Toolkit. Class is at the Microsoft Boston MTC, 5 Wayside Road, Burlington, MA 01803. Lunch is included, and there is free on-site parking. Attendees must bring a government ID to make it past security.
- December 5, 2019 online 9:00-5:00 Eastern (14:00-22:00 UTC) (click to see in your own time zone)
- May 1, 2020 in Jacksonville, FL 8:30-4:30 Eastern – in-person attendees get their choice of a Recorded Class Season Pass, SQL ConstantCare, or the Consultant Toolkit. Class is at the University of Florida, 1 UNF Drive, Jacksonville, FL 32224.
Kevin McDonnell (verified owner) –
Another fantastic class from Brent!
As the name suggests, Brent breaks down the key aspects of performance tuning in a way that is easy to understand and Very easy to follow along.
There isn’t enough time to cover all 21 demos in 8 hours, but Brent lets everybody vote on the topics we would like to cover.
Each demo starts out with some basics and then a quick but deep dive under the hood of SQL Server, discussing the pros and cons of how it handles Indexes, Tables, Views, the Query Optimizer, Cardinality Estimator, and more across the various versions of SQL.
As such, a wealth of information is covered in a short period of time! Fortunately we’re able to re-watch the videos and retain access to the t-SQL scripts long after the 1-day class is over.
The best part is while each demo breaks down what’s really going on, you get some great humor thrown in. I will be using these lessons to go back and re-examine how my company is doing some things right, and some things not-so-right!
I will definitely be attending more classes!
Thanks!
-Kevin M