Demystifying Azure SQL Database Service: Quick Start Comprehensive Guide

Introduction

Business is migrating to the Hyperscaler platform. Are you still running the SQL Server Database locally? Now it’s the right time to shift from the local SQL Server Database to the Azure SQL Database service. In this article, I will explain the quick start step-by-step procedure of how to create and deploy Azure SQL Database service.

Azure SQL Database Service

Azure SQL Database is a fully managed relational database service provided by Microsoft Azure. This service allows users to create and deploy relational databases on Microsoft Azure. It supports different relational databases like MYSQL and PostgreSQL databases.

Steps to Create Azure SQL Database Service

In the search bar, type Azure SQL Database service.

First, provide an Azure subscription and create a new Resource group as testRG.

Create a Database name named retaildb and a server named retailserver1005.

Provide the Server name as retailserver1005 and the location as US East US.

Choose the Authentication method as SQL Authentication.

Provide server admin login credentials.

In the Networking tab, choose the Public endpoint in the connectivity method.

Click Yes to allow Azure services and resources to access this server.

In the Security tab, choose Not Now for Enable Microsoft Microsoft Defender for SQL.

In the Additional Settings tab, choose Sample in the existing data.

In the Review + Create tab click Create button.

Deployment started initialized in a minute or two this became successful.

Click the Goto resource button.

In the Query Editor window, provide admin credentials to log in.

Allow the IP address for this server. And update the Firewall rules.

In the Tables section, you can see the list of tables available and type a query in the query section.

Summary

In this article, we learned how to successfully create and deploy the Azure SQL Database service. Azure SQL Database is a powerful and scalable managed database service that can help organizations to manage their relational databases in the Hyperscaler platform.

Hope you have enjoyed reading this article!!!