When I’m not broadcasting live, you can check out my free stream archives at Twitch and YouTube.
This week’s class is Mastering Query Tuning. Mon-Weds, Europe-friendly times: Add to Calendar. Weds-Fri, Americas-friendly times: Add to Calendar.
Watch Brent Ozar Streaming Live
This channel is scrambled.
Don't you hate that feeling when you stumble onto a good show, but it's on one of those pay channels? That's what's happening here.
Today's class isn't on public television: it's one of my paid classes. If you have a Live Class Season Pass, log in. If you bought after February 2021, your Live Class Season Pass is over here, or your Level 3 is over here.
Live Classes for Live Class Season Pass Holders
Spring/Summer 2022 Rotation:
- June 13-15: Mastering Parameter Sniffing – Add to Calendar (Europe-friendly times) – Prerequisites
- June 15-17: Mastering Parameter Sniffing – Add to Calendar – Prerequisites
- July 11-13: Mastering Server Tuning – Add to Calendar (Europe-friendly times) – Prerequisites
- July 13-15: Mastering Server Tuning – Add to Calendar – Prerequisites
Summer/Fall 2022 Rotation:
All of the fundamentals classes share these prerequisites except where noted.
- June 27-July 1: Fundamentals Week, US-friendly times
Monday: How I Use the First Responder Kit – Add to Calendar – Prerequisites
Tuesday: Fundamentals of Index Tuning – Add to Calendar
Wednesday: Fundamentals of Query Tuning – Add to Calendar
Thursday: Fundamentals of Parameter Sniffing – Add to Calendar
Friday: Fundamentals of Columnstore – Add to Calendar - July 4-8: Fundamentals Week, Europe-friendly times
Monday: How I Use the First Responder Kit – Add to Calendar – Prerequisites
Tuesday: Fundamentals of Index Tuning – Add to Calendar
Wednesday: Fundamentals of Query Tuning – Add to Calendar
Thursday: Fundamentals of Parameter Sniffing – Add to Calendar
Friday: Fundamentals of Columnstore – Add to Calendar - Aug 1-3: Mastering Index Tuning – Add to Calendar (Europe-friendly times) – Prerequisites
- Aug 3-5: Mastering Index Tuning – Add to Calendar – Prerequisites
- Aug 29-31: Mastering Query Tuning – Add to Calendar (Europe-friendly times) – Prerequisites
- Aug 31-Sept 2: Mastering Query Tuning – Add to Calendar – Prerequisites
- Sept 26-28: Mastering Parameter Sniffing – Add to Calendar (Europe-friendly times) – Prerequisites
- Sept 28-30: Mastering Parameter Sniffing – Add to Calendar – Prerequisites
- Oct 24-26: Mastering Server Tuning – Add to Calendar (Europe-friendly times) – Prerequisites
- Oct 26-28: Mastering Server Tuning – Add to Calendar – Prerequisites
Each class has hands-on labs for you to follow along. Read each course’s prerequisites at least a few days before class because setting up your VM will take quite a bit of time the first time you attend a Mastering class.
Logistics
For the highest resolution, click on the config icon in the player and you can change it up to 1080p. If you’re on a slow connection (unreliable wifi, DSL, etc) you can also change it down to a lower quality there, too. If you have problems with the video stuttering or not keeping up, first try refreshing your browser, then try closing other apps that are using the Internet (like syncing large files), or try connecting over wired Ethernet. And stop trying to steal wifi from your neighbor three houses over, ha ha ho ho.
For chat and questions, join the #BrentOzarUnlimited Slack channel, or read the instructions on how to get in. I only do Q&A over Slack – if you can’t get in there, you won’t be able to ask questions or turn in your homework.
If you don’t see a broadcast streaming window above, check with your sysadmins to have them unblock Mux.com (private classes) and Twitch.tv or YouTube.com (free public classes) for you. If you’re using a company VPN, you may also want to try disconnecting that VPN to see if that helps. If your video pauses, you’ve got an unstable Internet connection. Hit refresh on the page to restart your streaming. I can’t help troubleshoot your Internet connection during class, unfortunately.