How To Create A Single Database In Azure SQL Database

Introduction

In this article, we will learn how to create a single database in Azure SQL Database using either the Azure portal or an Azure CLI script. Then we will query the database using the Query editor in the Azure portal and also in our system installed SSMS.

What is Single database?

The single database resource type creates a database in Azure SQL Database with its own set of resources and is managed via a server. With a single database, each database is isolated and portable. Each has its own service tier within the DTU-based purchasing model or vCore-based purchasing model and a guaranteed compute size.

How to create a single database

Step 1

Login to portal.azure.com. Here you will see this homepage as shown below,

How To Create A Single Database In Azure SQL Database

Step 2

Click on the three lines on the left side and click on the dashboard.

How To Create A Single Database In Azure SQL Database

Step 3 - Create a resource

Now we need to create a resource from here for doing that click on the “create a resource”.

How To Create A Single Database In Azure SQL Database

Step 4

In resources you can check in the below image there is an option category where you can click on the database and you will see the result on the right side.

How To Create A Single Database In Azure SQL Database

Step 5

Here you can see we have the option “SQL database”. Click on the “SQL database”.

How To Create A Single Database In Azure SQL Database

Step 6 - Create SQL database

Here you can see we moved to that window from where we can create our SQL database. In this first screen, we need to select our subscription. Because I am working with a free subscription so I selected that then you need to select a resource group. If you do not have any resource group then you can create that easily by clicking on the create a new button in a resource group.

How To Create A Single Database In Azure SQL Database

Step 7 - Create a new server

Here you can see that in the database details area we need to enter a database name and also select a server. We do not have any servers so I click on create new and you can see on the right side a new window will come up for a new server in that window you need to enter some details like server name, server admin login, and password. After entering all the required information we need to click on the ok button to save it. Here you can see a new option is there which is saying want to use SQL elastic pool which we will leave no as default. We will discuss SQL elastic pool in our upcoming articles in detail. For now, you can understand that by using SQL elastic pool we can save a lot of money. Now we click on the next button.

How To Create A Single Database In Azure SQL Database

Step 7 – Networking

In this option, we do not make any changes and leave everything as it is.

How To Create A Single Database In Azure SQL Database

Step 8 – Security

In this screen, we do not select anything only for this demo project. But when you will work on other projects you need to check it for security purposes.

How To Create A Single Database In Azure SQL Database

Step  9 – Additional Setting

In this screen, as you can see below in the data source we have an option to select existing data, for now, we will click on the sample to load a sample database if you have any database backup you can select that as well.

How To Create A Single Database In Azure SQL Database

Step 10 -Tags

On this screen, we do not change anything. But tags are really good for our projects. It can be used in the pricing and another manner where you can use your project you can use tags to differentiate that.

How To Create A Single Database In Azure SQL Database

Step 11

In this screen, we can check everything that needs to be reviewed for us to check before creating our project. If we find something that we need to update we can go back and do that and if everything is alright then we click on the review and Create button.

How To Create A Single Database In Azure SQL Database

Step 12

On this screen you need to wait for a while. You can see that deployment is in progress.

How To Create A Single Database In Azure SQL Database

Step 13

Finally, our project has been successfully deployed.

How To Create A Single Database In Azure SQL Database

Step 14 - Go to the resource

Now we will click on the “Got to resource” button.

How To Create A Single Database In Azure SQL Database

Step 15

Here you can see our server has been created. And on the right side, you can see the complete information of our server like server name etc.

How To Create A Single Database In Azure SQL Database

Query the database

Step 16 - Query editor preview

On the left side, you can check that you have an option Query editor preview so we will click on there and you will redirect to the screen as shown below,

How To Create A Single Database In Azure SQL Database

Step 17 - Error for firewall

Here you can see that when we enter the login details as we created earlier and try to login we got this error. We will resolve this error and login again to our server.

How To Create A Single Database In Azure SQL Database

Step 18 - Add client IP

To resolve this error we need to add client Ip in our Azure firewall. For doing that we will click on the “firewall and virtual network” option from the left side and we got this screen after clicking on that. Here you can see we have a button to add client IP. So we need to click on that button.

How To Create A Single Database In Azure SQL Database

Step 19 - Updated firewall rules

Here you can see that we added our client IP to Azure. We got a message here that firewall rules have been updated.

How To Create A Single Database In Azure SQL Database

Step 20-Table preview

So now we will try to login again into our server and you can see in the below image we successfully entered into our server.

How To Create A Single Database In Azure SQL Database

Step 21

Here we will try to run a query in our database. And as you can see we successfully able to run our query in the query editor preview.

How To Create A Single Database In Azure SQL Database

Query in SSMS

Step 22

Now we will open SSMS in our system. Here we will select database engine in the server type and we paste our server name here and then select SQL server authentication and login with our credentials which we created earlier in Azure.

How To Create A Single Database In Azure SQL Database

Here you can see that we successfully logged into our server.

How To Create A Single Database In Azure SQL Database

You can see in the image we can check our table preview in SSMS.

How To Create A Single Database In Azure SQL Database

SO now we will try to run a query in the SSMS. And you can see that we get this result as shown below,

How To Create A Single Database In Azure SQL Database

Summary

In this article, you learned how we can create an SQL database in Azure and connect that to our on-premised SSMS. We also resolved an error which we got for the firewall.

If you want to know more please read from here,

Happy clouding.