Question

What Data security options are available in Azure SQL DB?

Answer 1

The data security options available in Azure SQL DB are:

1. Azure SQL Firewall Rules: Azure provides two levels of security. The first is server-level firewall rules that are stored in the SQL Master database and determine the access to the Azure database server. The second is database-level firewall rules that govern access to the individual databases.
2. Azure SQL Always Encrypted: It is designed to protect sensitive data such as credit card numbers stored in the Azure SQL database.
3. Azure SQL Transparent Data Encryption (TDE): The technology used to encrypt stored data in the Azure SQL Database. The encryption/decryption of database and backups/transactions of log files happens in real-time using TDE.