Extended Events for Anything But Query Tuning: Unique Constraint Violations

Most of the time when I talk about or demo Extended Events, I spend more time talking about query tuning (I have a problem). However, there are tons of...

Daily Coping 5 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

New Database Job – Understand What You Have

In my previous post, I expounded on my first 30 days I had at four jobs in the last four years. and how to setup your jobs box. I...

Daily Coping 4 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

SQLServerCarpenter Tools

Over the past couple of years, I’ve developed several tools that I’ve been using during my Performance Tuning and other related assignments. I thought to share it with the...

usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

This procedure will get all the stored procedures and triggers missing the use of SET NOCOUNT ON. It may be helpful in performance tuning assignments.

A New MVP Led Training Initiative – Cloud Formations

Hello Readers – I wanted to make sure those who follow my blog have heard about the new MVP led training initiative started by Paul Andrew (@mrpaulandrew). It’s called...

Scary Scalar Functions - Part Two: Performance

Scary Scalar Functions series overview

Part One: Parallelism
Part Two: Performance

Foreword
In the second part of this series, we’ll look at how Scalar functions (or UDFs) affect performance.
If you want to follow...

Goal Progress for June 2022

I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Ugh, June was no bueno for life goals. In May,...

Using Sessionize for Your User Group – Part 2

Now that your CFS has been setup it’s time to get the word out first. There are many ways to this. I start with using the Cfs secret page...