Azure SQL Database also offers various features for data security. It offers security for data in transit, data in rest, and data in use. To accomplish this, it is using the following features:
- HTTPS: This offers security for data in transit. Data is transferred using a secure connection over HTTPS.
- Transparent Data Encryption: This offers security for data at rest. It performs real-time encryption and decryption of the database, backup files, and logs. This is used for Azure Data Warehouse as well. It is using a database encryption key that is stored by Azure by default, but can be stored in Azure Key Vault as well. Newly created databases are encrypted by default. You can disable and enable the encryption inside the settings in the Azure Portal, PowerShell, and the REST API:
Transparent Data Encryption in the Azure Portal
- Always Encrypted: This...
