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.

Purpose
 Learn about performance related features and improvements specific to SQL Server 2019 and the latest version of Azure SQL Database.
Audience
 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.
Role
Data Engineer - DevOps Engineer - Software Developer - System Administrator
Duration
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
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

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.