Simple play icon Course
Skills

Getting Started with SQL Server Query Tuning Assistant

by Matt Stenzel

Maintaining query performance during database upgrades is a requirement for all businesses. This course will teach you base skills for query tuning and how to utilize SQL Server Query Tuning Assistant to ensure a smooth migration every time.

What you'll learn

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.

About the author

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.

Ready to upskill? Get started