Advanced Data Security

Advanced data security is a set of advanced SQL security features that provides vulnerability assessment, threat detection, and data discovery and classification.

It's a paid service, is priced independently of Azure SQL Database, and is free for the first 30 days.

Advanced data security for a database can be enabled when the database is created or at a later time.

Note

Threat detection was available earlier, along with the auditing feature. However, it's now available as part of advanced data security as advanced threat detection.

The following screenshot is from an older version of the Azure portal, showing the threat detection and auditing features:

Figure 5.36: Advanced data security features

The three security features under Advanced Data Security are as follows:

• Vulnerability assessment: A vulnerability assessment, as the name suggests, checks an SQL database for any possible security vulnerabilities, database misconfigurations, extra...