Creating A SQL Database And SQL Server On The Azure Portal

In this article, I am going to demonstrate how to create an SQL database and set up SQL Server on the Azure portal. Also, we will see the process for configuring the database with Threat Protection. Microsoft Azure SQL Database is a cloud-based service from Microsoft, that offers data-storage capabilities. It includes various features, like query data, search, data analytics, and synchronization of the data.

Prerequisites

• An Azure Subscription.

The outcome of reading this article is,

•  Creating an SQL Server
• Creating an SQL Database
• Configuring our database with Threat Protection.

Follow the steps to create the SQL database

Step 1

Sign in to your Azure account using Microsoft Azure credentials.

Step 2

In the portal, click on "+New" >> Databases >> SQL Database. 

 

Step 3

Enter the SQL Database name, choose the subscription, and create a new Resource Group for the database, named as mssql. Then, select the Data Source as Blank Database.

 

Step 4

It's time to create the Server for our Database. Press "Server" to configure one. Click on "Create a new server" and enter the name of our server, server admin login, password, and location. Press "Select" to configure the server and to create it.

 

Step 5

Choose the desired pricing tier in the "Choose your Pricing Tier" blade. I choose standard one for our database. Then, click "Apply".

 

Step 6

Finally, the configuration of the SQL Database is shown in the "SQL Database" blade. Just press "Create".

 

Step-7

After some time, our SQL database on the portal gets into action. The Azure SQL database gets started. Let's now see the usage of SQL database in the application with the use of connection strings. 



In the Overview blade, select connection strings to show your connection strings for various applications.

 

Follow the below steps to configure the Threat Detection to SQL Database

Threat detection is used to detect and notify the unauthorized and abnormal database activities in order to indicate the potential security threats to the database and offering a new layer of protection. This enables the clients to detect and respond to the potential security alerts in the SQL Database.

Step 8

In the SQL Database, on the left side ribbon, choose the "Auditing & Threat Detection" tab to add the threat protection to your database. In that blaze, turn-on the "Auditing & Threat Detection" option.

 

Step 9

In Storage details, choose it to configure the Storage account to create a new one and enter the name, choose the replication method, then press OK.

 

Step 10

Change the Retention as per your need and press OK to configure the Storage details.

 

 

Step 11

Enter the mail-id to send the alert notifications and then choose Save to save the Threat protection to the SQL Database.



Conclusion

I hope you understood how to create the SQL Database and SQL Server on Azure portal and how to enable Threat Protection to our SQL Database.