22-25 April 2026

Performance Unleashed: Practical Tuning for Azure SQL and SQL Server

Proposed session for SQLBits 2026

TL; DR

Learn how to diagnose and optimize slow SQL Server and Azure SQL workloads. Explore real-world query tuning techniques, Intelligent Query Processing internals, and practical strategies to improve performance and reduce costs across cloud and on-premises environments.

Session Details

Are you looking to accelerate Azure SQL workloads while keeping cloud costs under control — or aiming to achieve the best possible performance from SQL Server on-premises?
This session tackles real-world performance challenges by dissecting slow-running queries to uncover inefficiencies and hidden bottlenecks. Through hands-on examples and proven diagnostic techniques, you will learn how to apply intelligent optimization strategies that deliver measurable improvements in speed and resource utilization.
We take a deep dive into the SQL Server query engine to explore how Intelligent Query Processing (IQP) enhances performance — and where its limitations may affect reliability in production workloads.
Whether you are fine-tuning individual queries or managing databases at scale, this session equips you with practical, actionable insights to make your workloads faster, smarter, and more cost-effective — across both cloud and on-premises environments.

3 things you'll get out of this session

* Learn proven techniques to diagnose and fix slow-running queries in SQL Server and Azure SQL * Understand how Intelligent Query Processing works and where its limitations impact real-world workloads * Apply practical optimization strategies to improve performance and control resource and cloud costs