Archive › Microsoft SQL

Changing Job and Database Owners to SA

One of the services we’re trying to flesh out a bit more over at Hive Mind is our standard health check and resolution script.  Every DBA has his or her own set of scripts they carry around, either in a file, or a link to where to find it online.  Merging the best of all [...]

 

Comments ( 0 )

Why should we migrate our ETL from DTS to SSIS?

  I know I just threw a bunch of technical acronyms at you at once, but this is a topic that comes up more and more as people finally move off of SQL 2000 and onto a currently supported version.  Companies making this move will have a lot of old Data Transformation Service (DTS) packages [...]

 

Comments ( 0 )

HELP! My Log Drive is Full!

A few weeks back I received a call from a client who isn’t running one of our monitoring solutions.  “Help!  ServerX is not responding!  I can’t even connect to it via RDP.”  This machine happens to be a virtual machine, so I ask if he can log in to the host machine, and check for [...]

Comments ( 1 )