SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database

Unlock the Power of Automated SQL Server Performance Tuning

Discover how to leverage the latest automated features in SQL Server 2017 and Azure SQL Database to significantly improve database performance and reclaim valuable time. Microsoft's advancements in data-driven automation are designed to empower data professionals like you, freeing you from tedious manual tasks and allowing you to focus on more strategic, creative work.

This course, SQL Server: Automatic Tuning, delves into three key automated features:

• Enhanced Query Store: Learn how the upgraded Query Store now collects wait statistics, providing deeper insights into query performance bottlenecks. Identify and resolve performance issues at the query level with greater precision.
• Automatic Plan Forcing: Explore Automatic Plan Forcing, a powerful feature that automatically identifies queries experiencing performance regression and reverts to more efficient, previously successful query plans.
• Automatic Index Management: Master Automatic Index Management, which enables SQL Server to intelligently create missing indexes and remove unused or duplicate indexes, optimizing database performance with minimal intervention.

By the end of this course, you'll gain the skills and knowledge necessary to effectively enable these automated tuning features within your SQL Server environment. Start optimizing your database performance and freeing up your time for more impactful projects! Embrace the future of SQL Server management and experience the benefits of data-driven automation.