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.

Speaker

Allen is a Data Platform Consultant. Allen has spent over 40 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been a Data Platform MVP Award for twelve years.

Allen White's Sessions

Find and Fix those Troublesome Queries

Get Near Realtime ETL with Service Broker

Maintain SQL Server System and Performance with PowerShell

Gather SQL Server Performance Data with PowerShell

Let Service Broker Help You Scale Your Application