My Humble SQL Tips

My company is revamping its domain structure and tightening up network security. I am one of the guinea pigs and therefore have been put int...

Cleaning up after someone leaves. We all do it right? Our companies all have water tight policies and procedures to handle that, or maybe th...

SQL Server has offered data compression since SQL 2008. It is a very good feature but, as with almost everything SQL Server, it needs to be ...

I've been deploying a SQL Server auditing solution for our new SQL 2014 estate. I know, we're a few years behind. But if you saw som...

We use Redgate's SQL Monitor to keep an eye on our mission critical servers. I like the product. It is reasonably user-friendly, reliabl...

I've written the script below to easily identify databases that have not had backups taken within a certain amount of time. This could b...

I recently inherited a large estate of SQL Servers. Over the years, before I started, it grew organically and was managed by an insufficient...

A quick post for today since I haven't added anything in quite a while. Recently, I was investigating a deadlock that was occurring, l...

This post aims to aggregate a lot of the best practice or otherwise recommended configuration for SQL Server performance. It is meant as a s...

I was investigating a new server I'd been assigned, looking for gaps in configuration using the trusty sp_Blitz tool. The organisation t...