I received an email over the weekend asking about my pre-con at the PASS Summit, my general session at the Summit, and my Query Store course on Pluralsight. The individual wanted to know the requirements for the pre-con, and what overlap exists between these three. Great question.
First, feel free to review the abstracts for all:
PASS Summit Pre-Con, October 30, 2017 (Seattle, WA)
Solving Common Performance Problems Using Query Store
PASS Summit General Session, Date TBA (Seattle, WA)
Query Store and Automatic Tuning in SQL Server
SQL Server: Introduction to Query Store
None of these courses require pre-existing knowledge of Query Store.
The Pluralsight course starts at the beginning and walks you through configuring and using Query Store in SQL Server 2016 in find performance issues both retroactively and proactively (3 hours total).
The general session at the Summit discusses Query Store at a high level (what it is and how to use it), and talks about the new Automatic Tuning feature in SQL Server 2017 (Automatic Plan Correction) as well as Automatic Index Management in Azure SQL Database (75 minutes).
My full day pre-con covers everything from Pluralsight and the general session, and a whole lot more. If you want:
- all the gory details on what Query Store is, how to configure it, and what data exists
- best practices
- a slew of demos about how you can use it to find performance issues (out-of-the-box Query Store methods and custom options not documented elsewhere)
- tons of scripts that you can take home and use immediately
- details about the wait statistics data added to Query Store in SQL Server 2017
- additional uses for Query Store (beyond what’s documented)
- how to use Automatic Plan Correction in SQL Server 2017 (automatic and manual) and what Automatic Index Management looks like in Azure SQL Database
- an overview of how to visualize Query Store data
then the pre-con is going to give you all that and whatever else I can find time to fit in. It is a packed day and I am in the thick of pulling all the slides and demos together (so if there’s something you want to see/know that you don’t see mentioned here, feel free to email me!).
I hope this answers any questions you have about my pre-con at Summit and other Query Store sessions available, but if not, just contact me!
Have a great week, and to my friends in the south – the Stellato family is keeping you in our thoughts.