A curious case of a missing configuration group.

G’day,
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things...

Clean Code is Easier to Read – SQL Prompt

I saw a post recently that had query that looked like this:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b

where permission_name...

Locking While Dropping or Altering an Index

Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...

Notes from SQLRally Orlando

Tuesday afternoon started with me being an unexpected behind schedule, and then another interruption or two, but by 4:30 pm...

Please vote for my SQLPASS precon and sessions

A few days ago, SQLPASS opened the voting for the precon’s and sessions for the annual
SQLPASS community summit. I’ve also...

SQL Rally Day 1 PreCon

Yesterday was the first day of the SQL Rally conference in Orlando, FL.It was a great first day because I...

You Are Responsible for You

Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...

DBA VC Presentation May 11

Come one, come all!!  Oh wait, it’s too late now.  I just finished giving my presentation to the DBA VC (virtual chapter).  There was good attendance and there were...

DBA VC Presentation May 11

Come one, come all!!  Oh wait, it’s too late now.  I just finished giving my presentation to the DBA VC...

Dealing with Frustration in the Workplace

Inevitably, even if we work for ourselves, we get frustrated with our workplace. This is true of all aspects of...