Path icon Learning Paths
Skills

Effective Performance Tuning in SQL Server

  • Number of Courses4 courses
  • Duration2 hours
  • Skill IQ available Skill IQ

This learning path equips learners with essential skills for optimizing SQL Server performance. It covers the basics of the Query Tuning Assistant, strategies for analyzing and improving query efficiency, and advanced optimization techniques. By the end, participants will be adept at diagnosing and solving performance issues, ensuring SQL Server operates at its best. This concise path is perfect for those aiming to enhance database performance with practical, real-world applications.

Courses in this path

Effective Performance Tuning in SQL Server

Watch the following courses to get started.

Getting Started with SQL Server Query Tuning Assistant

  • by Matt Stenzel
  • 31m Duration

Effective Query Analysis with SQL Server Tools

  • by Thomas LeBlanc
  • 44m Duration

Advanced Query Optimization Techniques in SQL Server

  • by Pinal Dave
  • 30m Duration
  •  (12)

Real-world Scenarios: SQL Server Query Tuning in Action

  • by Pinal Dave
  • 29m Duration

Learn with the best

Matt Stenzel
Matt Stenzel
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.
Thomas LeBlanc
Thomas LeBlanc
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.
Pinal Dave
Pinal Dave
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 61 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog at https://blog.sqlauthority.com.

Join our learners and upskill
in leading technologies