Gain exclusive control of a database

Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many connections that kept popping up, even after restarts, that they were not able to change the setting.

10-minute SQL: Filtered Delete: join vs. sub-select vs. exist

I was doing some simple tuning of procedures for a client when I came across some delete statements that I wanted to look into some more. They were filtering based on values in a temp table. In a majority of cases I have come across at clients a row is deleted from a single table based on some static and …

Embrace your inner Hedgehog!

As I was sorting out my office and getting new furniture setup I came across some scratch notes from when I listened to the audio of Jim Collin’s Good to Great book last year. The notes were about the hedgehog concept in particular and it is a pretty interesting concept. I strongly believe it was one of the motivating factors …

Exceptional DBA 2012 Finalist – What exactly got me there?

As you may know from my pestering, this year I am one of five finalists in the Exceptional DBA awards. Each year I make the effort to enter into the Exceptional DBA competition. I do not do this to win, but to reflect on my accomplishments from the previous year. This past year has seen a lot of changes for …

A Day in the life of: Me – A DBA Team lead

After reading through Erin Stellato’s (blog | twitter) TSQL2SDAY topic & reponses I was inspired to log one of my days. I decided that July 30, 2012 would be that day. Here’s how that day evolved:

A day in the life of: (preamble)

I just started following #tsql2sday on twitter when I saw a post by Erin Stellato (blog | twitter) with the topic of July. The topic selected was to describe a day in your life as a DBA. I’m a little late to the party, but I  took some notes today and will work on them as time as this week permits. …