Subscribe to this blog
SQL Sandwiches
Archives: June 2011
find...underlings...
find.....underlings.....
searching......
underlings found......
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
0 comments, 201 reads
Posted in SQL Sandwiches on 22 June 2011
Double Hop of Doom
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?
3 comments, 1,109 reads
Posted in SQL Sandwiches on 20 June 2011
Don't touch that Maintenance Plan Job
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
1 comments, 532 reads
Posted in SQL Sandwiches on 12 June 2011