How to Create SQL Database in Azure [5 Steps]

In this article, We are going to cover How to Create SQL Database in Azure/How to create SQL DB in Azure.

How to Create SQL Database in Azure

Below are steps to create Create SQL Database in Azure.

Login to Azure Portal with your username and password. Go to All Services in Azure Portal, Click on SQL databases.

login to portal and click on SQL database 1

then click on Create SQL database

click on create SQL database 2

Step #1: Basics– Select Subscription, Resource group, Database name, server VM instance type and compute+storage .

select subscription resource group db name server type 3

click on Networking.

enter database name server click on networking 4

Step #2: Networking – select network connectivity method

select networking 5

Step #3: Additional Settings – select Data source, Database collation, Azure defender for SQL and click on Tags.

select additionla settings 6

Step #4: Tags – Input tags and click on Review + create.

input tags 6

Step #5: Review + create – Review the Azure SQL db before creating

review azure sql db 7

if all configuration is ok then click on Create.

create azure sql db 9

wait till deployment azure sql DB.

Query the Azure SQL Database:

once azure sql db created, you can use Query editor preview to connect azure sql db and query to SQL database.

Conclusion

We have covered How to create sql database in azure/How to create SQL DB in Azure.

Related Articles:

How to Create a Virtual Machine Azure [8 Steps]

How to Install Azure CLI on Ubuntu 20.04/18.04 LTS

Reference:

Azure SQL Database official page

About Amit Khamkar

I am Amit Khamkar working as DevOps Engineer, Likes to explore new DevOps Tools and Believe in sharing knowledge.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Share via
Copy link