Working on Azure SQL Database
Azure SQL Database is Microsoft's relational database cloud offering, which falls under the platform as a service model, often referred to as Database as a Service (DBaaS). It's highly available and provides a high-performance data storage layer. Because of everything mentioned above, it's often the first choice when it comes to selecting a database in the cloud.
There is a whole section of security-related features in Azure SQL Database's settings. There are four different options:
- MICROSOFT DEFENDER FOR SQL
- AUDITING
- DYNAMIC DATA MASKING
- TRANSPARENT DATA ENCRYPTION
If we enable ADVANCED DATA SECURITY, we get a few advantages:
- VULNERABILITY ASSESSMENT SETTINGS
- ADVANCED THREAT PROTECTION SETTINGS
- DATA DISCOVERY & CLASSIFICATION
The options to enable ADVANCED DATA SECURITY are shown in the following screenshot:
Figure 6.8 – Microsoft Defender for SQL...
