Hello everyone, in this article, we will explore about creating an Azure SQL Database in the Azure platform. We will take an overview of the Azure SQL database. The Azure SQL Database is a general-purpose relational database. With the help of this relational database, we can create a highly available and high-performance data layer storage in Azure. The highlight is that we can use advanced query processing features such as intelligent query processing. As said of the database as a service, the database will take care of backup, high availability of data and the recovery process. The main advantage is that we can scale-up and scale-down the database based on our requirement without any interface.
The pricing of using the SQL database in Azure is calculated on the basis of usage and the selection of service tier which we have selected. Now we can get into hands-on creating a new SQL database in the Azure portal.
Set up
An Active Azure Subscription
Step 1
First, we need to login to an Azure portal, you can log in into the portal by using the following
link.
Step 2
Select=> Database and then select=> Azure SQL database.
Step 3
After selecting the SQL database, a new window will appear and now we need to provide the basic requirements.
Provide a name for the database and then create a new server by providing the input as shown.
- Provide a server name.
- Provide a server admin role.
- Provide a password and confirm password for the server admin role.
- Select the location of the database and click=>ok.
Then configure the database configuration with the general-purpose pricing tier and then click=>Apply.
Step 4
Now select=>create for creation of the database and the deployment process will take place and after that, we can see that the deployment process is successful and click=> Go to the resource.
Step 5
Finally, click the "Create" option for the configuration setting and then here, we can see the Server name of the SQL database that we have created, and we can see that the database is online and running.
Step 6
After clicking the URL from the server name, it will navigate and will show the full information of created Azure SQL database, like SQL database name, status, location, price and etc and we can see that the database is online so that we can use for the further process and all.
Summary
In this article, we have created a SQL database in the Azure portal and I hope this article will be useful for you. Thanks for reading.