Monthly Mentor Webcast: Kick Start! SQL Server 2019 Performance Tips and Tricks

Event Details

On Demand
  • Recorded Date:Apr. 08, 2020

Every new release of SQL Server brings a load of new features you can add to your database management arsenal to increase efficiency. SQL Server 2019 has introduced many new features and Pinal Dave of SQL Authority will show you how to maximize them in this special session. 


Here’s a glimpse of the SQL Server features Pinal will cover:

  • Adaptive query plans 
  • Batch mode adaptive join
  • New cardinality estimates for optimal performance 
  • Adaptive query processing 
  • Indexing improvements 
  • Introduction to automatic tuning 
  • Batch mode for rowstore storage 
  • Accelerated database recovery 

This on demand session will provide invaluable guidance to help any DBA or developer who wants to get a jump start on SQL Server 2019 and its new features.

Speakers

Pinal Dave is a SQL Server performance tuning expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written more than 5,000 articles on database technology on his blog at https://blog.sqlauthority.com.

Along with 16+ years of hands-on experience, he holds a Master of Science degree and a number of database certifications.

Event Details

On Demand
  • Recorded Date:Apr. 08, 2020

Watch Your Free Webcast

By downloading, you are registering to receive marketing email from us. To opt-out, follow steps described in our Privacy Policy.

reCAPTCHA protects this site. See Google's Privacy Policy and Terms of Use.

Share