What is SQL Server parameter sniffing and data skew?

How do I fix this? If you found this page you most likely either found yourself in the middle of a SQL Server parameter sniffing and/or data skew issue and have no idea how to get yourself out of this hole. In the eight-minute video below…

Why is my SQL Server query slower than normal?

Have you ever had a query that runs frequently start to randomly go slower? We all have and without the proper tools and knowledge, this can be hard to figure out because there can be so many different reasons. In this blog post, our goal is…
Make Your Queries Go Faster

Automatic Tuning: Scalar Functions in SQL Server 2019

With SQL Server 2017 Microsoft improved the journey towards making your code go faster without any code changes required by your developers. SQL Server 2019 gives you more of this super cool black magic. Today, we are going to show…
Procure SQL - SQL Saturday Denver 2018

SQL Saturday Denver 2018 Resources

I had a blast speaking at SQL Saturday Denver.  To help everyone moving to SQL Server 2017  I have included my slides and demo code below.  If you end up having any questions with the code or need help feel free to contact me. SQL…
Procure SQL Automatic Tuning

Automatic Tuning in the Real-World

In SQL Server 2016 we saw Query Store.  Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run faster.  Microsoft’s marketing team even jumped on…

GroupBy Conference Resources: demos and source codes.

I hope everyone enjoyed my session on Making Your Queries Go Faster as much as I did planning and delivering it. If you would like to replay the demos on your time you can grab the slide and code . When you go through the demos, if you have…
Procure SQL SQL Saturday Chicago

SQL Saturday Chicago

,
Last weekend I had a blast speaking at the SQL Saturday in Chicago. It was awesome to share my knowledge and also catch up with some good friends.  My talk was on Automating the Pain Away with Query Store and Automated Tuning.  I hope this…

Finding Top Offenders with Extended Events

,
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other 3rd party tools like ClearTrace, ReadTrace would be used to aggregate the data to get…

Resources for Performance Tuning Article

,
The following are some resources that are included in John Sterrett's Introduction to Performance Tuning with Azure SQL Databases Idera Geek Sync. Performance Root Cause Analysis Toolkit Calculate DTU on Your Own  Benchmark Azure SQL Database…

Introduction to Performance Tuning in Azure SQL Database

,
Are you interested in performance tuning in Azure SQL Database?  You are in luck!  Procure SQL’s very own founder, John Sterrett [t,b] is giving an Introduction to Performance Tuning Azure SQL Databases in Idera’s April 26th GeekSync! …