A curious case of case when and Null values

For some reason I have always written my Case statements using the following logic:

SELECT
CASE
WHEN @Priority = 1 THEN 'Very High'
WHEN @Priority...

High CPU and Query Store, A Story of Spinlock Heartache

This is going to be a quick look at an issue that we recently encountered, I’m not going to go...

T-SQL Tuesday – Non-SQL Server Technologies

So, this month’s T-SQL Tuesday topic is to think about a non-SQL Server technology that we want to learn.
For me,...

Signing Stored Procedures That Access Multiple Databases

A while back I wrote a post, Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Recently Manish...

Identifying delays between SQL calls using SQL profiler

One of the common goto methods for query specific slowness which can be replicated via an application can be to...

A Play Around With Table Variable Deferred Compilation in SQL 2019

Table variables, they’re nasty, dirty little things that perform about as well as a Robin Reliant in a crosswind, right? ...

The SQL Agents’ view of SQL Server

I recently came across a really odd issue with the SQL Agent, there were two agent jobs attached to one...

Inspector V1.2 now available

It has been long overdue but finally V1.2 is now available on GitHub.
V1.2 brings a lot of changes, We put...

Inspector V1.2 revised installation guide

Pre-requisites:
SQL 2012 or higher

SQL Server Agent

A database to store the the data collected by the agent jobs (this can be...

sp_translate, A Universal Translator in SQL Server. Just One Example Of How Powerful the Python/SQL Partnership Can Be.

In my recent post, Installing External Modules into SQL Server’s Python I had a look at just how simple it is to...