22-25 April 2026 
SQLBits 2019
Find and Fix those Troublesome Queries
SQL Server provides a wealth of tools in the box to help you spot troublesome queries. We'll explore those and examine how they can best be used.
Every expert has their own set of tools they use to find and fix the problem areas of queries, but SQL Server provides the necessary information to both diagnose and troubleshoot where those problems actually are, and help you fix those issues, right in the box. In this session we will examine a variety of tools to analyze and solve query performance problems.
Speakers
Allen White's previous sessions
Find and Fix those Troublesome Queries
SQL Server provides a wealth of tools in the box to help you spot troublesome queries. We'll explore those and examine how they can best be used.
Get Near Realtime ETL with Service Broker
Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.
Maintain SQL Server System and Performance with PowerShell
This session will demonstrate scripts to gather server inventory data and SQL Server and operating system performance data with PowerShell and provide reports to stay on top of your servers.
Gather SQL Server Performance Data with PowerShell
It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.
Let Service Broker Help You Scale Your Application
Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.