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 Brent Ozar and Erik Darling, you’ll see SQL Server, Azure SQL DB, and Azure Managed Instances 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. Brent and Erik 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
This is an online class – we host it in GoToWebinar, live with us 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 with Brent and Erik, 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.)
The demos include:
- 01 – Missing Index Column Order (16m)
- 02 – Execution Plans are Lying Liars (12m)
- 03 – Estimates vs Actuals (17m)
- 04 – Trivial Plans
- 05 – Statistics
- 06 – Parameter Sniffing
- 07 – The Problem with Multi-Parameter Stored Procedures (15m)
- 08 – Dynamic SQL Pro Tips (15m)
- 09 – Memory Usage by Different Operators
- 10 – Sorts
- 11 – Resource Waits
- 12 – Locking and Blocking (23m)
- 13 – Deadlocks (11m)
- 14 – Simplification
- 15 – Parallelism Part 1
- 16 – Filtered Indexes, Indexed Views, and Computed Columns
- 17 – Parallelism Part 2
- Lunchtime Part 1: Write and Tune a Query
- Lunchtime Part 2: Write and Tune a Query (Answer)
- Palate Cleanser 1 – Managed Instance DTUs (4m)
- Palate Cleanser 2 – Numbers Tables (6m)
- Palate Cleanser 3 – Index Usage DMVs are Lying Liars (20m)
- Palate Cleanser 4 – Table Variables vs Temp Tables: The 2019 Rematch (8m)
Class dates & times:
- Feb 7, 2019 online 9:00-5:00 Eastern (click to see in your own time zone)
Reviews
There are no reviews yet.