For the best web experience, please use IE11+, Chrome, Firefox, or Safari

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

On Demand
  • Recorded Date:Apr. 8, 2020
  • Event:On Demand

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.


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

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