22-25 April 2026 
Pinal Dave
blog.sqlauthority.com
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 over 5000 articles at SQLauthority.com
SQLBits 2020
Kick Start! SQL Server 2019 Performance Tips and Tricks
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2019 has introduced many new features. Here is a glimpse of the features we wil
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2019 has introduced many new features. Here is a glimpse of the features we will cover in this session.
- 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 session will the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2019 and its new features.