Introduction to Azure Defender for SQL

Azure Defender for SQL includes two Azure Defender plans that extend Azure Security Center's data security package to secure your databases and their data wherever they're located.

Availability

Aspect Details
Release state: Azure Defender for Azure SQL database servers - Generally available (GA)
Azure Defender for SQL servers on machines - Preview
The Azure Preview Supplemental Terms include additional legal terms that apply to Azure features that are in beta, preview, or otherwise not yet released into general availability.
Pricing: The two plans that form Azure Defender for SQL are billed as shown on the pricing page
Protected SQL versions: SQL on Azure virtual machines - Windows and Linux
Arc enabled SQL servers (includes on-premises SQL servers)
Azure SQL single databases and elastic pools
Azure SQL Managed Instance
Azure Synapse Analytics (formerly SQL DW) dedicated SQL pool
Clouds: Yes Commercial clouds
Yes US Gov
No China Gov, Other Gov

What does Azure Defender for SQL protect?

Azure Defender for SQL comprises two separate Azure Defender plans:

  • Azure Defender for Azure SQL database servers protects:

  • Azure Defender for SQL servers on machines (Preview) extends the protections for your Azure-native SQL Servers to fully support hybrid environments and protect SQL servers (all supported version) hosted in Azure, other cloud environments, and even on-premises machines

What are the benefits of Azure Defender for SQL?

These two plans include functionality for identifying and mitigating potential database vulnerabilities and detecting anomalous activities that could indicate threats to your databases:

  • Vulnerability assessment - The scanning service to discover, track, and help you remediate potential database vulnerabilities. Assessment scans provide an overview of your SQL machines' security state, and details of any security findings.

  • Advanced threat protection - The detection service that continuously monitors your SQL servers for threats such as SQL injection, brute-force attacks, and privilege abuse. This service provides action-oriented security alerts in Azure Security Center with details of the suspicious activity, guidance on how to mitigate to the threats, and options for continuing your investigations with Azure Sentinel.

What kind of alerts does Azure Defender for SQL provide?

Security alerts are triggered when there's:

  • Potential SQL injection attacks - including vulnerabilities detected when applications generate a faulty SQL statement in the database
  • Anomalous database access and query patterns - for example, an abnormally high number of failed sign-in attempts with different credentials (a brute force attempt)
  • Suspicious database activity - for example, a change in the export storage destination for a SQL import and export operation

Alerts include details of the incident that triggered them, as well as recommendations on how to investigate and remediate threats.

Next steps

In this article, you learned about Azure Defender for SQL.

For related material, see the following articles: