SQLSaturday Post-Con:Query Tuning on Prem or In Cloud, of Wolf and Human.

William Wolf presents - Seek and Destroy! Unforgiven Tuning! Query Tuning on Prem or In Cloud, of Wolf and Human.

Regardless of whether you are in Azure, AWS, Google, some other cloud, or on premise; tuning is still paramount to your SQL Server architecture.

Behind all of that the data needs to get to the user efficiently. All of the Power Tools and different letters to get your data don't matter too much if you can watch paint dry while waiting for your query to finish.

In this all-day session we will discuss how to pinpoint bottlenecks using performance counters extended events and reading execution plans. We will even take a look at the Azure DTU to find bottlenecks high in the cloud. We will then review common malpractice in designs for query tuning.

At the end of this exciting and dynamic session, you will be able to go to your employer on Monday with tools and confidence to look like a performance tuning Rockstar.

Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQL Saturday veteran speaking at nearly 40 SQL Saturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.