Splitting ID’s with commas, updating them, and then Slamming them back together

Unfortunately my company still uses
MS Access DBs. That's Access 97 folks! I've battled many challenges over the
last couple months with...

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...

Double Hop of Doom

I recently had to battle through THE DOUBLE HOP OF DOOOOOMMM!! It was a very rewarding experience and I think...

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...

Can Scrum work for the DBA?

Agile! Scrum! Development methodologies! Sprint!

If you have a manager who reads any web page about being a manager, then you...

Recovery Model for Every Database

One thing that is enjoyable about my position is working with people who have no idea what SQL is besides...