A file based system with a file for each proc is easy enough to do too. To get developers to adhere to it, we only stage from CVS. If it ain't...

Creating a DTS package and saving it locally is correct, but so is creating a user database.

I don't need to do a backup of the master for that (Assuming I...

There's good stuff on this in BOL, but automating it is kind of messy.

I have a log backup routine that formats the file <dbName><yyyymmddhhmi>.trn and saves to disk on the...

Encrypt isn't a hash. A hash is one way. SQL will de-crypt the encrypted data for you if you are SA, but data readers and writers will not be able...