Roger L Reid (4/22/2009)

---

Drew, the thing that confuses me about sites like the one you describe - which I know are perfectly common - is how they manage the licensing...

Thank you for the help, I will try your script.

Much appreciated!

Drew Salem (4/21/2009)

---

That completely passed me. I was asking Steve Jones of SQLServerCentral.com what I should call the artcles and he suggested using the acronym. I hope people haven't thought...

Drew,

Thanks for the article. Looking forward to the upcoming installments.

When I first saw the title of your article, I actually thought it was about using Microsoft System Center Operations Manager...

So I have backed up my certificate (certificate protecting the private key of a symmetric key through which I en(de)crypt data):

use encryption_test;

BACKUP CERTIFICATE ct_data_access

TO FILE = 'C:\_MARIOS\BACKUPS\encryption_test_db_ct_data_access'

WITH PRIVATE KEY

(

FILE =...

Mike Good (4/13/2009)

---

Marios, I like the way you think. This is going to take a little while to digest.

One question I have right away, though: was...

Mike, thanks again for your insightful article, and thanks all for this discussion. I have learned a lot.

Lately, I have been able to research the subject of database encryption extensively...

I found the answer! Instead of converting the decrypted result to NVARCHAR, I should be converting it to VARCHAR; since I enter it as VARCHAR into the table in the...

What do the other 2 letters stand for in C-I-A?

K. Brian Kelley (4/9/2009)

---

Yes and...

K. Brian Kelley (4/9/2009)

---

Marios Philippopoulos (4/9/2009)

---

In http://msdn.microsoft.com/en-us/library/cc837966.aspx it is stated that, in terms of encrypting symmetric keys used for data encryption:

Can...

Thanks all for your input.

If I may add one more point here to what George just mentioned: data encryption and protection of encrypted data.

Who else but the DBAs is better...

I posted the question on http://www.sqlservercentral.com/Forums/Topic691281-361-1.aspx.

Thanks in advance for all the feedback.

Steve Jones - Editor (4/6/2009)

---

Mario,

I'd actually ask you start a new thread for that. It's a great question, and I think it deserves some debate. If you post a URL...

With the advent of third-party enterprise-level backup solutions, such as Symantec or CommVault, how justifiable is it to maintain that DBAs should still be the owners of the database-backup/restore process?...