SQL Application Column Encryption Sample (Codeplex) available

To achieve many compliance guidelines on Azure SQL Database, the application needs to encrypt the data. The intent of this article is provide some guidelines and an example library for encrypting data at rest for relational databases.

We just published the source code for a library at “SQL Application Column Encryption Sample” in Codeplex (https://sqlcolumnencryption.codeplex.com/) that can help developers to encrypt data (columns) at rest in SQL Azure database. This library is intended to work as sample code and published as open source with the goal to allow the community to improve it while we make a better solution available for Azure SQL Server.

We will appreciate your comments & feedback on this library as it will help us make it better as well to make sure we can make future solutions better.

Please use the Discussion section on the Codeplex library or leave a comment in this forum for feedback & comments.

Comments

• Anonymous
  October 21, 2014
  Raul, can we use a third-party data masking and encryption tool like <a href="www.iri.com/.../fieldshield"> IRI FieldShield</a> on Azure (since it’s working on SQL Server already via ODBC)?
• Anonymous
  October 22, 2014
  Yes, it would be a valid approach to use a third party library to handle encryption & data masking as well as for handling your keys. Although, for obvious reasons, I cannot recommend any specific third party library in particular.