Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

SQL Server 2019 Performance Improvements

Course Summary

The SQL Server 2019 Performance Improvements training course is designed to demonstrate the knowledge and skills they need to improve the performance of SQL Server 2019 instances.

The course begins with SQL Server 2019 setup and configuration. Next it explores abilities to improve SQL Server 2019 performance via tempdb improvements, Query Store improvements, Accelerated Database Recovery, Sequential Key Insert Optimization and more. The course concludes with a look at monitoring and automatic improvement.

Learn about performance related features and improvements specific to SQL Server 2019 and the latest version of Azure SQL Database.
Developers, data analysts, and database administrators who work with an earlier version of SQL Server and plan to migrate their databases to these platforms. Current users of the SQL Server 2019 platform who want to better utilize its capabilities.
Data Engineer - DevOps Engineer - Software Developer - System Administrator
3 Days
Related Technologies
Back-End Development Training | SQL | Cloud Computing Training | Azure


Productivity Objectives
  • Evaluate and use the new database platform with new performance related features to improve application and database performance
  • Improve database administration efficiency
  • Troubleshoot and optimize the database environment more efficiently

What You'll Learn:

In the SQL Server 2019 Performance Improvements training course, you'll learn:
  • Setup and configuration improvements
  • Tempdb improvements
  • Query Store improvements
  • Accelerated Database Recovery
  • Sequential Key Insert Optimization
  • Approximate query processing
  • Intelligent Query Processing features
    • including Scalar UDF Inlining
  • Monitoring improvements
  • Automatic Tuning
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”


Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.