Encryption of Data in SQL05

My current experience is with access and sql2000. In my current application, I compress/encrypt my data prior to storing in my database. Does the new verion of sql support compression/encryption and if so can you please point me to any links which discuss.

thanks,

Fred Herring

Encryption is supported in SQL Server 2005, see for example:

http://msdn2.microsoft.com/en-us/library/ms345262(en-US,SQL.90).aspx

I also have a number of postings with examples on my blog:

http://blogs.msdn.com/lcris/archive/category/10357.aspx

If you want to evaluate the encryption features of SQL Server 2005, they're also available in the Express edition, which you can get from here:

http://msdn.microsoft.com/sql/express/

If you need more specific information, this is the right place to post questions.

Thanks
Laurentiu

|||

I have read that encryption is available for SQL 05. I have also attempted encryption on a column.

What are some good examples and practices when using encryption in SQL 05? How and where is the key stored?

How does the key work per column, or one per database?

How do you manage encryption keys?

Where are encryption keys stored and where is a safe place to store them? I don't have a full understanding of how encryption works in SQL 05, so any help would be great- I've read syntax and how to create and use them- but only in an example- I have not used them in practice- I don't understand how to use them in a real world example, or at least for our business.

Any help?

|||

You can find detailed answers to these questions by following these links:

Encryption Hierarchy article in Books Online:
http://msdn2.microsoft.com/en-us/library/ms189586.aspx

My blog with various examples and discussions of encryption functionality:
http://blogs.msdn.com/lcris/archive/category/10357.aspx

If after reading those articles, you still have questions that are unanswered, let us know.

Thanks
Laurentiu

|||Great! Thanks for the blog and the links! I look forward to diving into these!