22-25 April 2026
SQLBits 2015

Inside the Query Optimizer

In this session discuss the query optimizer, the individual phases of optimization, and how understanding these items can impact our queries in a positive way
The Query Optimizer is a black box.  It can be intimidating until you understand it.  Understanding the Optimizer beings with knowing the Rules.  The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.  This is the first step in learning how to use the Optimizer's rules to make your queries faster!

Speakers

Bradley Ball

sqlballs.com

Bradley Ball's previous sessions

Indexing Internals for Developers & DBAs
This is a dive into how indexes work within SQL Server. The goal of this session is for attendees to gain a greater understanding of how Indexes work and how to use them to gain performance.
 
What we’ve learned running a YouTube channel (so far)
This session is suitable for anyone who is interested in starting or growing their own YouTube channel, or who wants to learn more about the YouTube ecosystem.
 
Soft Skills eat Technical Skills for Breakfast
Over the years I’ve faced some very difficult situations. Talking down angry customers, de-escalating tense situations, and focusing on the right outcomes. There are a few key books that cover these concepts. In 20 minutes I will tell you what they are, why they are important, and how they saved me more than a few times.
 
The Most Powerful Azure Service You’ve Never Heard Of
Join Patrick Leblanc from the Power BI CAT team, Josh Luedeman, and Bradley Ball from the Azure FastTrack PG as we talk about the most powerful Azure Service you’ve never heard of. If only you knew the name of the service. Come to this session, and you’ll never forget it!
 
Migration to Azure Customer Experiences & Best Practices
How to create a roadmap to migrate to Azure, best practices, and using Azure Migrate to start, & customer stories
 
Inside the Query Optimizer
In this session discuss the query optimizer, the individual phases of optimization, and how understanding these items can impact our queries in a positive way
 
BI DBA Performance Tuning
Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well