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