Create A SQL Database in Azure

Kailash Chandra Behera | Tuesday, July 21, 2020

Introduction

Here in this blog, we will discuss how to create a SQL Database on azure Azure portal , the azure database sql server later can be accessed anytime and anywhere like in azure cloud service or window azure development.

Getting Started

Azure SQL Database in the cloud is the intelligent, scalable, relational database service built for the Azure cloud. It is evergreen and always up to date, with AI-powered and automated features that optimize performance and durability for you.

Serverless compute and Hyperscale storage options automatically scale resources on-demand, so you can focus on building new applications without worrying about storage size or resource management. To know more about the azure sql pricing visit the official web site of Azure portal

Above are the introduction to Azure SQL DB in azuren, now follow these below steps in the demonstration to create a SQL Database in the Microsoft Azure portal.

Demonstration

  1. Open the Azure portal in your browser and log in with your user account. You can click here on the link to open the Azure portal in the browser.

  2. When login success you will be redirected to the home page.

  3. On the home page you may find SQL databases icon, otherwise, click on the ‘Create a resource’.

  4. Then create on SQL Database, you will be redirected to the ‘Create Databases’ page.

  5. Enter your database name in the corresponding field that you want to create, then select the server database server where you want to create a database.

  6. If you want to create a new azure sql database server, then follow these steps.

    1. Click on ‘Create new’, you will be redirected to the New server.

    2. In the Server name box, enter the name that you want to give to your new server.

    3. Enter an administrator Login Name and Password. This will require when you will access it later.

    4. Choose the same location that you chose for the cloud service.

    5. Check Allow azure services to access the server.

    6. Click on Select, now you are done with new server creation.

  7. Then select yes or no from the radio button, whether you want to use SQL elastic pool or not.

  8. Click on the button ‘Review+Create’ if you want to create SQL database immediately after review or you can set it for next networking by clicking on the ‘Next: Networking.

Summary

In this blog, we discussed how to create a SQL database in azure for azure development or azure cloud service. I hope you have enjoyed it a lot.

Thanks

By at