How to create a Microsoft Azure SQL Database in serverless compute tier from the Azure Portal

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.

Create a resource

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.

SQL Database

Step 4

Under Project Details, select the relevant subscription and the resource group.

create a Microsoft Azure SQL Database

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’.

create a Microsoft Azure SQL Database

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.

create a Microsoft Azure SQL Database

Step 7

Under Backup storage redundancy, choose a redundancy option for the storage account where your backups will be saved.

create a Microsoft Azure SQL Database

Step 8

In the Networking tab, Set Add Current client IP address to ‘Yes’. Leave the rest as it is.

create a Microsoft Azure SQL Database

Step 9

In the Additional settings tab, under Data source, select Use existing data as ‘Sample’. Then click on the Review + create button.

create a Microsoft Azure SQL Database

Step 10

Click on the Create button to create the SQL database. You will be able to see your database has successfully been deployed.

create a Microsoft Azure SQL Database

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.