Best practices
This section describes best practices with respect to the use of SQL Database and contains some code snippets and walkthroughs on how to implement these best practices.
Encryption and security
Encryption within Windows Azure SQL Database is the responsibility of the application, as it does not support the data encryption mechanisms for data that resides on the SQL database.
Obviously, it is not a good security approach to store passwords in source code. Store all your secrets encrypted in configuration files.
Encryption demo
To use encryption from your web or worker roles, use Pkcs12 Protected Configuration Provider, since the standard protected configuration providers in the .NET framework, for example, RsaProtectedConfigurationProvider
, is not supported on the Windows Azure platform. If you connect to your instances of Windows Azure SQL Database from applications running on your own datacenter, it is still recommended that you use the configuration providers from the .NET framework...