May 22, 2008 at 5:32 am
I just started reading about encryption and I have few questions.
1. How does inserts and updates from application gets encrypted and saved in the database. I tried it from the query analyzer it works fine. But how does it work from the application. Do we need to use keys in application code?
2. I read lot about key management and finally what I understand is we got to back the keys using BACKUP command and save them some where. Is that what is called key management or Is there anything I am missing?
May 26, 2008 at 5:01 pm
I dont have answer to your first question. Please find attached doc describing encryption a bit. Yep, u r right that is known as key management and it has been extended in SQL 2008 a little bit further(as far as I know). In 2008 key management can be done by using third party products too.
Manu.
May 27, 2008 at 9:37 am
Thanks for the reply. But my first question is still a question. Also the other question is what is the performance impact of using the encrytion during Selects, Inserts and Updates?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply