
Pinal Dave
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.
Pinal Dave's Training Days
SQL Server Performance Tuning Real-World ScenariosSQLBits 2020
In this SQL Server Performance Tuning Pre-Con, we will go through various real-world performance tuning challenges I have experienced during my last 10 years of Consulting Engagements and how I overcome each of them.
21 Essential Scripts: Performance Tuning for EVERYONESQLBits 2019
This session solves many of the classic mysteries people have with related to performance tuning. In this session I will give them accurate, ready to get started script which will solve DBA's day to day problems.
36 Scripts: Performance Tricks Jedi Master Wants You to KnowSQLBits 2018
This demo-oriented a day-long session (story telling styled) will answer the questions which DBA and Developers often wonder about Performance Tuning and Query Optimization.
Pinal Dave's Sessions
SQL Server Performance Tuning Real-World ScenariosSQLBits 2020
In this SQL Server Performance Tuning Pre-Con, we will go through various real-world performance tuning challenges I have experienced during my last 10 years of Consulting Engagements and how I overcome each of them.
Kick Start! SQL Server 2019 Performance Tips and TricksSQLBits 2020
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 OptimizerSQLBits 2020
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 TrickSQLBits 2019
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.
21 Essential Scripts: Performance Tuning for EVERYONESQLBits 2019
This session solves many of the classic mysteries people have with related to performance tuning. In this session I will give them accurate, ready to get started script which will solve DBA's day to day problems.
Secrets of SQL Server-Database Worst PracticesSQLBits 2019
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.
36 Scripts: Performance Tricks Jedi Master Wants You to KnowSQLBits 2018
This demo-oriented a day-long session (story telling styled) will answer the questions which DBA and Developers often wonder about Performance Tuning and Query Optimization.
Kick Start! SQL Server 2016/2017 Performance Tips and TricksSQLBits 2018
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 DBAsSQLBits 2018
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.