SQLBits 2018
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.
If you are a DBA who is dealing with multiple platforms like SQL Server, MySQL, MariaDB, PostgreSQL, RedShift etc, this session is for you. The number one issue multi-platform DBA often face is that they have to learn multiple Integrated Development Environment (IDE)s when they have to deal with different databases. The initial curiosity of learning something new often gets old very fast when dealing with multiple platforms for different databases. There are often scenarios when we want simple efficiency enhancement in our daily routine like powerful search, cloud storage and collaboration, which we often see often missing in our run of the mill clients.
This session is not your usual tips and tricks session. It is rather a very different take on the life of multi-platform DBAs's life. We will share some real-world scenarios and life stories of DBA who have to deal with different database platform every day and their constant battle with efficiency. We will see some neat solutions, demos, and tools which can make our daily job pleasant. Remember that everybody who will attend the session will get free scripts which they can use to improve their SQL Server's performance.
This session is not your usual tips and tricks session. It is rather a very different take on the life of multi-platform DBAs's life. We will share some real-world scenarios and life stories of DBA who have to deal with different database platform every day and their constant battle with efficiency. We will see some neat solutions, demos, and tools which can make our daily job pleasant. Remember that everybody who will attend the session will get free scripts which they can use to improve their SQL Server's performance.
Speakers
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
SQL Server Performance Survival Kit for the AI Era - 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.