Open In App

Microsoft Azure – Advanced Threat Protection for Azure SQL Database

Last Updated : 30 Mar, 2023
Like Article

In this article, we will look into how to configure Advanced Threat Protection in Azure SQL Database. Advanced Threat Protection is a feature of Azure SQL Database that detects security threats and anomalies and lets you know about them so that you can act. 

Follow the below steps to configure it:

Step 1: Here we already have an existing Azure SQL Database Server. This contains one or more databases. 

Step 2: Now click on the Advanced-Data Security option.  This feature is enabled on the server level, which means that you enable it for all databases.

Step 3: Now let’s turn the option “ON”. 

Here, we can configure a weekly security assessment and have the results sent to you. The scans will be stored in the storage accounts that you can configure here. We’ll leave this Off for now because we are interested in Advanced Threat Protection. Here, we can also put in an e-mail address to where the security alerts will be sent to. We’ll leave this to send the alerts to admins and owners.

Here, you can see which types of threats will be detected and alerted to. These are the most common vulnerabilities and attacks that can happen to your data.

Step 4: We’ll leave all of them enabled, and click on “OK”.

Step 5: Finally, let’s configure Auditing. This will help us to troubleshoot any anomalies that are detected. Let’s turn it “ON”. 

Step 6: We also need a place to store the logs, like in Azure storage. Here we will select an existing Azure storage account then click on “OK”. Finally, Save it.

And we are done. Azure SQL Database allows you to easily configure Advanced Threat Protection, which detects security anomalies and threats and lets you know about them. 

Previous Article
Next Article

Similar Reads

Microsoft Azure - Data Protection in Azure SQL
In this article, we will learn about the data protection aspects of Azure SQL. Azure SQL provides a Unified package of SQL security intelligent capabilities, which includes: Data ClassificationVulnerability AssessmentAdvanced Threat Protection[caption width="800"] [/caption]SQL Data Discovery & Classification: This service is used to discover,
4 min read
Microsoft Azure - Introduction to Azure SQL Database
Azure SQL Database is a database built for modern Cloud applications. Developers and clients opt for Azure SQL for one or more of the below-mentioned reasons: If they want to build multi-tenanted software as a service type of application, elastic pools are a great option for the same.If they have a database and they don't want to have to choose bet
3 min read
Microsoft Azure - Azure SQL Database Deployment Options
Azure SQL Database is a database built for modern Cloud applications. Now coming back to the eccentric concepts for which consider If you have ever worked with Azure SQL Database, you must have come across terms such as "single database" or "Elastic scaling" and so on. There is an increasing trend of building applications in the cloud today. For an
5 min read
Microsoft Azure - Configure Auditing for Azure SQL Database
In this article, we will look into the process of configuring auditing for the Azure SQL Database. Follow the below steps to configure auditing for Azure SQL Database: Step 1: Here in the portal, we're looking at the Azure SQL Database, and down on the left under Security, we can select the Auditing tab. Step 2: Now, this is where we would go if we
2 min read
Microsoft Azure - Create Azure SQL Database Using all Configuration Options
Here, we will learn to create a SQL Azure Database in the cloud providing all the available options. In this article, we are going to look through all of the settings available for creating a SQL Database in the Azure portal. Implementation: Follow the below steps to create an Azure SQL database using all configuration options: Step 1: So, you can
6 min read
Microsoft Azure - Create Azure SQL Database
In this article, you will learn to create and query an Azure SQL database. SQL database is a high-performance reliable cloud database. If you have a data-driven application or a website that you want to create a database to support, you can use any programming language that you prefer and you don’t have to manage any of the infrastructures. [captio
2 min read
Microsoft Azure - Database Availability and Consistency For Azure SQL
When you or your company decides to move your database from your on-premise servers/computers to a cloud environment, consistency and availability are two important factors to consider. Database consistency is much more intricate. It means that no matter how or where you access your data, the same query would give you the same data output. It also
4 min read
Microsoft Azure - TDE is Enabled in Azure SQL Database
Pre-requisite: Azure VM Transparent Data EncryptionBy encrypting data at rest, transparent data encryption (TDE) protects Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics against the threat of unauthorized offline actions. Without requiring changes to the system, it enables real-time encryption and decryption of the datab
3 min read
Microsoft Azure - Restore to a Point in Time with Azure SQL Database
Pre-requisite: Azure Microsoft Azure SQL Database is a service that provides managed Paas service running the latest SQL Server Database. It comes with a feature of point-in-time backups. So, in this article, we will study how we can create a point-in-time backup using Azure SQL Database and restore it using created backup. We will see two differen
3 min read
Difference Between Azure SQL Database and Azure SQL Managed Instances
Azure is a cloud platform which is used for services like virtual computing, storage networking etc. It provides with solutions that include Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS). Both, Azure SQL Database and Azure SQL Managed Instances supports automatic backup and have built-in license
3 min read