From Zero to Hero- SQL Server Performance Tuning Workshop

Ready to boost your SQL Server skills from scratch with practical tips and tricks to speed up your databases?

Pinal Dave is among the top people on this planet for SQL Server Performance Tuning. He is travelling from India for this very in-person session.

This full day, hands on workshop is built around the story of an organization struggling with real performance challenges. You step in as the new team member who must diagnose issues, understand root causes, and apply practical fixes.

The focus is real world troubleshooting. We work through the kinds of performance problems DBAs and developers face every day. The goal is not just to show features, but to build confidence in handling live systems under pressure.

The core workflow is simple and powerful:

1. Run the right queries to diagnose the problem
2. Run the right queries to fix the problem

Throughout the day, you will build your own performance tuning toolbox. These are scripts and techniques you can immediately apply when someone says, “The server is slow.”

Topics covered include:

🔹 Solving common performance issues in a reactive manner
🔹 Identifying and resolving I O, CPU, and memory bottlenecks
🔹 Handling TempDB contention correctly
🔹 Troubleshooting slow running queries
🔹 Applying quick and effective indexing fixes
🔹 Understanding wait statistics and their impact
🔹 Reading and interpreting execution plans
🔹 Using live execution plans for real time diagnostics
🔹 Moving from reactive tuning to proactive performance management
🔹 Designing effective index strategies
🔹 Following best practices for database file configuration
🔹 Improving performance with In Memory OLTP
🔹 Using Columnstore indexes for large datasets
🔹 Managing and learning from Query Store

This workshop is designed to help you think like a performance tuner. By the end, you will not just know what to run. You will understand why you are running it.

And that is when performance tuning starts to feel less like firefighting and more like controlled engineering.