My Humble SQL Tips

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

/***UPDATE***/ I passed the 70-457! Now studying for 70-458... I passed the 70-458! Now studying for 70-459, booked for Jan 29, 2016... /...

I've run into an interesting dilemma: as a new staff member in a security conscious organisation, I can't really get any work done. ...

Not everyone has access to off-the-shelf monitoring tools. One of my clients is a very small shop with only a few databases and 2 database s...