I entirely agree.  In fact, I've just returned from a T-SQL course with Learning Tree and so am very pro T-SQL at the moment.  I think in the interim it'll...

So I hope for all those folks that did answer C (as I too am a little confused to see how changing the 2test database has any bearing on the...

I'm quite excited about the prospect of CLR integration.  Although I work as a DBA and would like my career to progress down that route, I am currently studing for...

Also worth remembering to use 4 part names if your databases are on 2 different servers (i.e. [server name].[db name].[owner].

Just don't forget to register the remote server as a...

I'm not putting this forward as a definitive solution, but have you thought about using Global Variables to name each of your connections, then when you loop around you increment...

As someone who's inherited the DBA role, I'm having to trawl through our databases and look at our backup plans.  Articles like this serve to highlight some of the glaring...