Database upgrades are usually a complex and dreaded process that can result in query performance headaches. In this course, Getting Started with SQL Server Query Tuning Assistant, you’ll gain the ability to do basic query tuning and to utilize SQL Server Query Tuning Assistant to ensure smooth database version migrations. First, you’ll explore basic query tuning concepts. Next, you’ll discover what the SQL Server Query Tuning Assistant is and how to use it. Finally, you’ll learn how to apply basic query tuning concepts and the SQL Server Query Tuning Assistant to help with your database migrations. When you’re finished with this course, you’ll have the skills and knowledge needed to utilize SQL Server Query Tuning Assistant to ensure a smooth migration every time.
Author Name: Matt Stenzel
Author Description:
Matt Stenzel is a Data and AI Cloud Solution Architect at Microsoft. He has 15+ years of experience in the data and analytics industry working in various roles including a software developer, data engineer, DW developer, DBA and integration architect. He has spent the last 8 years working at Microsoft helping companies across the US successfully implement Azure solutions that provide business value.

Table of Contents

• Course Overview
  2mins
• Foundations of Query Tuning
  18mins
• Interpret and Apply Query Optimizations
  10mins