SQL Server 2005 encryption

• san43

  Hall of Fame

  Points: 3196

  More actions

  May 22, 2008 at 5:32 am

  #121656

  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?

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  May 26, 2008 at 5:01 pm

  #820290

  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.

• san43

  Hall of Fame

  Points: 3196

  More actions

  May 27, 2008 at 9:37 am

  #820625

  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?