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 on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.

Pinal Dave has submitted 4 sessions for SQLBits 2020, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

SQL Server Indexes are not always as much as helpful as we like to think. Often they work against our overall server performance. In this session, we will see some troublemaking scenarios and their workarounds.
Sometimes there is not enough time to save the SQL Server World via troubleshooting it comprehensively. At times we take the shortcut to stabilize the system and restore equilibrium. Inspired by true stories.
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
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.

Sessions

Previous Sessions

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.
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.
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.
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.