0 to Speaker

Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I...

Why not NOLOCK?

Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at...

Who’s using that database?

A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else...

There are #temp tables and then there are ##temp tables.

Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly...

Using Solutions in SSMS

There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions,...

I want to blog but …

I don’t know how to get started.
Pretty simple. There are a number of free blogging sites out there. Personally I...

Tales of a DBA fed up with NOLOCK. Part 2

Feb 16, 2015

Dear Diary,

A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were...

SQL Judo’s Monthly Challenge – March 2014 – Powershell something

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...

Tales of a DBA fed up with NOLOCK. Part 1

Nov 12, 2014

Dear Diary,

They asked for help again. Every now and again everything slows down and they see a lot...

Using sp_DBPermissions and sp_SrvPermissions v6.0

It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting....