Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Sandwiches

Sqlsandwiches is a tool for me to communicate what I have been learning to the SQL community.

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, 349 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?


mmmmmm…

Read more

3 comments, 2,086 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, 943 reads

Posted in SQL Sandwiches on 12 June 2011