My Humble SQL Tips

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

I was reading a blog post from Brent Ozar ( SQL Server Query Store ), which detailed Microsoft's announced future feature in SQL Server ...

As a DBA, performance tuning is a regular ongoing task. In my experience it is both a reactive and proactive task. The goal, though, is for ...

First, a confession. I've been doing it wrong for a long time. Only recently have I learned that TempDB should be included in regular CH...