That's great, Elliot. Extra keys. Hadn't thought about that. Do you use procs then for encryption/decryption? If so, doesn't that defeat the purpose of the extra keys?

I think this will work fine, just be sure that you have all the log backups with the copy only backup. The one thing I'd be worried about is the...

Don't think so. The first error is an I/O subsystem error, surfaced when the I/O system doesn't respond correctly.

The backup error would surface differently as a failure to read from...

Or enable detailed logging.

You can't change a default instance to a named instance. You can install another instance and transfer your databases, logins, linked servers, etc. to the new instance.

Why does the table have to be created on the fly? You know the output of the proc already, so create the temp table using that basis.

If you say you...

You can encrypt the column data a few ways, but they usually require some application changes. There is column level encryption using symmetric and asymmetric keys in SQL Server. Typically...

I found this: http://shaunjstuart.com/archive/2010/06/failure-when-upgrading-cluster-to-sql-2008-sp1-cu7/

Similar issue?

Stefan Krzywicki (7/2/2012)

---

A friend of mine was unable to check in his code for days because his company kept it in "the cloud" and when Amazon services went down because...

Jeff Moden (7/2/2012)

---

To continue the analogy, this is why I don't like to be a passenger in a car. There's no control over what's happening. You have to...

Chad Crawford (7/2/2012)

---

I guess I don't see how the cloud facilitates automation. I would think that whatever you automate in the cloud could have been automated non-cloud as...

I'm...

cdonlan 18448 (7/2/2012)

---

Convincing the powers-that-be to spend the necessary money can be a real challenge, but if you want something even more challenging try to convince them that with...

Obscurity definitely helps. After all, security isn't a set process. People don't do A, then B, then C. Some do A and B, some B and C, some A and...

Brandie Tarvin (7/2/2012)

---

Chad Crawford (7/2/2012)

---

Help me out - I recognize that security is a concern when hardware is remote,...