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

Shutting down nodes in Azure Kubernetes Service

A while back I wrote a post on Adjusting Pod Eviction Timings in Kubernetes. To test the changes made in that post I had to shut down nodes in...

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

T-SQL Tuesday 151 Round up: Coding Standards

I received a great collection of blog posts in response to my T-SQL Tuesday 151 – asking people to write on T-SQL Coding Standards. Rob Farley (t|b) is of...

usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

/*
Author:Brahmanand Shukla (SQLServerCarpenter.com)
Date:27-May-2022
Purpose:To get all the stored procedures and triggers missing the use of SET NOCOUNT ON.
This procedure may be helpful in performance tuning assignments.

Example:
EXEC usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
*/
CREATE OR...

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

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

Daily Coping 1 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...

Refreshing Tables in Data Masker

Data Masker for SQL Server is a product that helps to change data for compliance purposes. It works well, but it isn’t intuitive in a few ways. We bought...

Setting up MinIO for SQL Server 2022 s3 Object Storage Integration

Introduction In this post, I will walk you through how to set up MinIO, so you can use it to work with SQL Server 2022’s s3 object integrations. Working...