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 of Data in SQL05
joeydj
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
mhams
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
Syed O. Raihan
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
dbradley