This was originally a free weekly course to help you crack the code when it comes to query performance tuning but is now available here as on-demand video. The fact is, query tuning is a difficult skill to master. Understanding which queries to focus on can be a daunting task. After you find the right query, you need to understand what is wrong with it. Then you have to try solutions, but test them to understand if they’re hurting or helping. All of this involves a lot of skills that take time to master. However, there is help to be had if you better understand the tools that SQL Server provides you that give you knowledge of your systems and the queries running there.

We’ll be covering topics like:
• The Query Store
• Dynamic Management Views
• Extended Events
• Execution Plans
There are several other tools, tricks and tips covered throughout the course. The information in the course mostly covers SQL Server versions from 2012 and up, including Azure SQL Database and Amazon RDS. However, some of the course will be specific to versions of SQL Server 2016 and greater.

The course was taught by Grant Fritchey, a Microsoft MVP and the author of two unique resources, SQL Server 2017 Query Performance Tuning and SQL Server Execution Plans. Grant has worked in and around databases for more than 30 years and has been focused on making them run faster for over 20. Grant has a passion for this knowledge and wants more than anything to make your jobs just a little easier by sharing this information.

Each session is approximately 1-2 hours in length. No registration is required.

Class Prerequisites:
• If you wish to follow along you’ll need an instance of SQL Server installed, or in a container, preferably SQL Server 2019.
• You’ll need a copy of SQL Server Management Studio to start. We will also use Azure Data Studio.
• You should set up a copy of the AdventureWorks database.
• You’ll be able to download course code from GitHub.
• You should already know SQL Server basics and T-SQL as we won’t be covering them in the course.