Introduction
In the realm of cloud computing, Microsoft Azure stands out with its handy services, and the Azure SQL Database is a keystone for managing relational data. This article focuses on the swift creation of a serverless Azure SQL Database via the Azure Portal. The serverless tier offers flexibility and cost-efficiency, catering to varying workloads. Follow along to understand the streamlined process of setting up a serverless Azure SQL Database, unlocking the advantages of Microsoft's dynamic cloud platform.
Create a Microsoft Azure SQL Database
Step 1
Sign into Microsoft Azure Portal via https://portal.azure.com.
Step 2
Click on + Create a resource icon on the home page.
Step 3
Search for SQL Database in the search bar, find the SQL database option, click on Create, and then again select SQL database to access the Create SQL Database page.
Step 4
Under Project Details, select the relevant subscription and the resource group.
Step 5
Under Database details, provide a Database name, select your SQL server, and select ‘Yes’ if you need to use the SQL elastic pool, and for this example I will be choosing Workload environment as ‘Development’.
Step 6
In Compute + storage, select Configure database. As this example uses a serverless database, set the Service tier to ‘General Purpose (Most budget-friendly)’ and set the Compute tier to ‘Serverless’. Then click on the Apply button.
Step 7
Under Backup storage redundancy, choose a redundancy option for the storage account where your backups will be saved.
Step 8
In the Networking tab, Set Add Current client IP address to ‘Yes’. Leave the rest as it is.
Step 9
In the Additional settings tab, under Data source, select Use existing data as ‘Sample’. Then click on the Review + create button.
Step 10
Click on the Create button to create the SQL database. You will be able to see your database has successfully been deployed.
Summary
In this article we learned ‘How to create a Microsoft Azure SQL Database in serverless compute tier from the Azure Portal’, please use the comments section if you have any clarification.