SQLBits 2019

Kick Start! SQL Server 2017/2019 Performance Tips and Trick

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 2017 / 2019 has introduced many new features.

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 2017 / 2019 has introduced many new features. In this 60 minute session we will be learning quite a few of the new features of SQL Server 2017 / 2019. Here is the glimpse of the features we will cover in this session. • Adaptive Query Plans • Batch Mode Adaptive Join • New cardinality estimate for optimal performance • Adaptive Query Processing • Indexing Improvements • Introduction to Automatic Tuning / Intelligent query processing This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2017 / 2019 and its new features.

Pinal Dave's other proposed sessions for 2026

"Run Query Run" - A Fresh Look at SQL Wait Stats - 2026

Database Worst Practices by Gen AI - 2026

Pinal Dave's previous sessions

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

Elementary! The Curious Case of Deceptive Query Optimizer

We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will together with carefully investigate inside the query optimizer understand the reason.

Kick Start! SQL Server 2017/2019 Performance Tips and Trick

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 2017 / 2019 has introduced many new features.

Secrets of SQL Server-Database Worst Practices

This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days.

Kick Start! SQL Server 2016/2017 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. In this session we will discuss newly introduced SQL Server 2016 / 2017 features for performance.

Efficiency Tips and Tricks for Multi-Platform Data Client DBAs

Real-world scenarios and stories of a DBA who has to deal with different database platforms and their constant battle with efficiency. This session will offer neat solutions, demos, and tools to make your job more pleasant.