Archives: June 2011
I recently was given the task to create a stored procedure to find people who are under other people from our users database.
The requester requested that they would put in the user's ID and it would return everyone under them...and everyone under those people...and so… Read more
I recently had to battle through THE DOUBLE HOP OF DOOOOOMMM!! It was a very rewarding experience and I think every DBA should battle this beast at one time or another in their career.
So what is a double hop?
Let's take a step back, what's a single hop?
Good ol Maintenance plans. With 2005 and beyond we received the glorious SSIS backed Maintenance plans. I love SSIS so natually I love using these plans. Last week I was working on setting up a new server.
We had to make sure we had full, differential, and transactional log backups.… Read more