Pinal Dave

blog.sqlauthority.com

SQL Server Performance Tuning Expert Pinal Dave is a seasoned SQL Server Performance Tuning Expert and independent consultant. With over 22 years of hands-on experience, he has authored 14 books on SQL Server, created 92 Pluralsight courses, and published more than 5,800 articles on database technology on his blog, SQLAuthority. He also holds a Master of Science degree and multiple database certifications.

Proposed Sessions for 2026

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

Learn how to use SQL Server Wait Statistics to find performance bottlenecks and fix slow queries. This session covers session level waits, CPU and disk I/O delays, and practical tuning techniques you can apply immediately to make your queries run faster and more efficiently.

Database Worst Practices by Gen AI

Come for the jokes, stay for the tuning skills. This fun one hour session shows how Gen AI can get SQL Server performance wrong and turns bad advice into clear lessons on indexing, queries, waits, blocking, and parallelism using real world examples.

SQL Server Performance Survival Kit for the AI Era

SQL Server performance tuning becomes clear when you see it live. This hands on workshop uses real problems and zero slides. You will tune slow queries, fix bottlenecks, read wait stats, and build skills that stay valuable even as AI becomes common.

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.