SQL Server 2005 Data Encryption

re: SQL Server 2005 Data Encryption

Deepankar Bandopadhya — Mon, 28 Nov 2005 10:15:20 GMT

Excellent Article.
Step by Step guidance provided.

Just a small note from the BOL to indicate why the Master Key is not required to be opened just like the Symmetric Key
==================================
From [BOL]
The database Master Key is always encrypted (using TRIPLE_DES) with a user-supplied password and stored in the sys.symmetric_keys table in the database. At the same time, a copy of the database Master Key is encrypted using the Service Master Key and stored in the sys.databases table of the master database. This facilitates the automatic opening of the database Master Key.

re: SQL Server 2005 Data Encryption

Keith Combs — Tue, 29 Nov 2005 01:44:18 GMT

Thanks for the comment on the master key. I figured someone would wonder why I didn't go into it. Instead of going into storage and permissions models, I decided to link the CREATE MASTER KEY call to the books online at http://msdn2.microsoft.com/en-us/library/ms174382.aspx in the blog post.

There are a number of spin off posts I could do but I may switch gears into Windows Server R2 or Exchange E12 topics.

More SQL or what?

re: SQL Server 2005 Data Encryption

Deepankar_Bandopadhya — Tue, 29 Nov 2005 09:33:52 GMT

Actually I had submitted a similar article on http://www.sswug.org. Hence the quick observartion.
I agree when you say that "There are a number of spin off posts I could do but I may switch gears into Windows Server R2 or Exchange E12 topics."

re: SQL Server 2005 Data Encryption

Keith Combs — Tue, 29 Nov 2005 10:33:35 GMT

Deepankar, come back here and post a reference when it gets published. Thanks!

Security in SQL Server 2005: Webcast 2-20-2006

Matt Hester's WebLog — Thu, 23 Feb 2006 04:27:53 GMT

Thank you for attending the web cast on SQL Server 2005 Security, as promised here is the scrubbed Q/A...

re: SQL Server 2005 Data Encryption

Serdar — Fri, 21 Apr 2006 16:14:04 GMT

I wonder how long would it take for hackers to crack this crypt ? Would it be a wise idea to use this technique in a commercial software product to guarantee data privacy ? Any advice ?

re: SQL Server 2005 Data Encryption

piyush parekh — Fri, 07 Jul 2006 13:28:59 GMT

hi,
It was a good learning experience.... no doubt that hackers would have to crack their heads to do all this....
But i have a doubt...whether it affects the performance.. also what we have seen is for a single user..
but if we need it for general how should i go about it..

re: SQL Server 2005 Data Encryption

Steve — Sun, 23 Jul 2006 18:20:51 GMT

thanks Keith