SQL Homework – July 2022 – Update your resume.

Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to ... Continue reading

A Blogging Break

Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming for 3 posts a week, and mostly keeping there, but it’s created a little stress...

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...