The other challenge is understanding what you use. I've always hated the $$/MB charges for phones for a couple reasons. One is that I have no idea how much MB...

There is asymmetric and symmetric encryption in SQL Server. You can create keys there (even temp ones) and do the encryption.

What PGP does, and most encryption algorithms is take a...

You can shrink the specific file for that data, but make sure you leave some free space for maintenance operations (Reindexing) and data growth.

Completely agree with Gilamonster. Differentials save time in recovery, and save space on your disk with smaller backups than fills.

However you need the full backup, and if you implement differentials,...

I'd concur with Adam, both on the analysis and advice. Tempdb can benefit, if you use it a lot, but you have to test.

USE master

GO

EXEC xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft

SQL Server\80\Registration','CD_KEY'

Woo-hoo!!!

You are welcome, and glad things are working for you.

Steve

Lynn Pettis (7/3/2012)

---

Steve, I apologize for my latest rant to Mr Celko. I have tried to restrain myself since you asked me to, but I just had to respond...

Job history isn't detailed logging. You can enable logging inside the package to a text file.

Except that if you are space bound, you can move new data to the new file this way. And if space is your issue, not performance, this can work.

Depending on...

One benefit of the clustering on a VM is hardware abstraction. This can be handy for DR, and also for not worrying about HCL parts on the list. If you...

Elliott Whitlow (7/3/2012)

---

Yes, I use sprocs, but you pass in a value that is then hashed and then the hashed value is used to select the right key. So...

I don't think it's possible. Usually a sproc has a known result set, even for a report, so you would have the values being returned.

You cannot have two default instances. You cannot have two different versions alternating as the same instance.

Your post doesn't explain which is a default instance and which is a named...