You’ve finished my free How to Think Like the Engine class, and now you wanna take it up a notch.
You’re confident writing queries to get the data you want, and you’ve been doing it for a couple of years. You took an intro course when you first got started, and sure, you learned select/from/where/group-by – but how do you make your queries go faster?
In this one-day course, you’ll learn:
- How sp_BlitzCache shows you which queries to focus on, and what parameters to use with sp_BlitzCache to guarantee the best bang for the buck on your own SQL Server
- How to read an execution plan to find the problems in a query
- What parts of estimated, cached, and actual plans are lying to you
- How to identify common anti-patterns in queries and plans, and fix ’em fast
Live Class Logistics
Read & watch the prerequisites module before the class. I can’t emphasize enough how important that is: if you don’t fully comprehend the stuff in there, you will be terribly behind during class. During this class, you’ll frequently hear me say, “To get this part, you need to think back to ___ from How to Think Like the Engine.”
To ask questions and talk to the other attendees, get an instant invite to Slack here, then join the #BrentOzarUnlimited channel. This way attendees can help each other with their questions during the live labs. (I don’t use the Facebook/YouTube/Twitch comments because I want to be able to show everyone’s questions up onscreen at the same time, and Slack does a better job of code formatting.)
To follow along with the demos and do your homework, download a Stack Overflow database. I’ll be using the medium-sized 50GB StackOverflow2013 database, but if you’ve got a different one handy (either the smaller 10GB or larger 300+GB one), that’s fine too – the same concepts will still apply. If you’re on a slow desktop/laptop, feel free to use the small 10GB StackOverflow2010 database.
To watch the instant replay recordings, students with a paid membership can click on the links at right.