SQLBits 2024

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 are the secrets to making your queries run faster? Why does SQL Server use an index for some queries and not for others? What makes a good index? How many indexes should I have? Have you ever asked these questions? When you want to understand an application you look at its core architecture. Underneath the covers SQL Server is just a C++ application. Together we will discuss how the application architecture of SQL Server works, and how to apply this logic to building the best indexes for your queries.

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