Open In App

Microsoft Azure – Create Azure SQL Database Using all Configuration Options

Improve
Improve
Like Article
Like
Save
Share
Report

Here, we will learn to create a SQL Azure Database in the cloud providing all the available options. In this article, we are going to look through all of the settings available for creating a SQL Database in the Azure portal.

Implementation:

Follow the below steps to create an Azure SQL database using all configuration options:

Step 1: So, you can get started from the Azure portal, click create a resource and go to SQL Database.

Like the other resources that you can create in the Azure portal, Azure has their inputs and settings organized into tabs. Azure has the basics tab that has the minimum set of requirements you need to enter to create the database. And for SQL Database, Azure has one additional settings tab with all the extra useful settings that you may want to configure depending on your needs.

 

Step 2: So to get started, you are going to select the right subscription for you in your resource group. If you want to quickly get started, you would just need to enter the name of the database and you could immediately go click create. 

 

 

Step 3: Now, we are going to look through other settings. You can go to pick the right server for you and search for the server name and the region that you want.

As you are going to create a new server for your needs. So, you are going to give it a name, enter your credentials, and may or may not change the region. You can select allow Azure Services to access this server so that you can use features like query editor or later connect your web app to this server. If your server is validated and the server name is unique, you can continue. 

 

Step 4: And then you can look at additional things like if you want to put this database in an elastic pool, You could use that if you have a large number of databases and you want to manage them and monitor their performance of them together. And then you could go and select the pools that you want, this database and other databases, to be managed within. So,  go to configure the compute and storage resources for this database.

 

 In here, you have the vCore based service tiers and you have the DTU based service tiers. In the vCore based service tiers, you have configurable compute and storage settings. You can configure exactly based on your workload needs.

Whereas in the DTU tier, you would have preconfigured bundles that you can select from. The DTU model would be ideal if you just want something simple and easy, something preconfigured.

 

In the vCore model, it would be ideal if you really care about transparency and flexibility and have very specific workload needs. So, the tiers available in the vCore based model, Azure have general-purpose, which is best for most business workloads. Azure has business-critical, which is great for business workloads with high IO requirements. And it offers high resiliency to failures because it has multiple isolated replicas. And then Azure has their newest hyper-scale tier, which offers highly scalable storage, up to 100 terabytes, and you pay for the storage you use as opposed to preconfiguring it.

 

Step 5: Then going back to general-purpose, similar to hyper-scale with pay for usage storage, Azure has the serverless compute tier, which is paid for the usage of computing. So, instead of preconfiguring and paying a fixed amount, you would pay for the compute that you are using.

 

 So, as you go through and configure all the settings that you care about, you can look at the cost summary and review based on the selections that you have made on this page, you can view how much is the estimated monthly cost or the usage-based costs that you would expect to pay and get an estimate of your monthly cost so that you can predict and plan for that.

 

Step 6: You may go ahead and continue. And at this point, you have configured everything and basics you could go ahead and create at this point. You can also move to the additional settings tab to look at what extra you have. 

So in here, the first thing you have is the data source. By default, you will get a blank database, but you can select, you can populate data into this database from a backup or from a sample. Say, you have a database that you were using that became inaccessible, you could restore it to a new database from a backup, which is why you would want to use this. If you are just testing things out in SQL Database, you may want to just put sample data in there, so you can get started quickly.

 

 And you have other settings that potentially you care about depending on your language database collation.

 

Step 7: And if you care a lot about security, Azure has an advanced data security feature that gives you a bundle of security features that will check for vulnerabilities and threats and give you recommendations and give an assessment based on what is potentially wrong. And this applies to the entire servers, not just this database. So, for every database on the same server as this database, you would get these security features and this assessment running. And you can start with a free trial.

 

 Step 8: And then the last thing available for all resources that you are creating in Azure are tags. This could help you categorize your resources. Maybe later you want to configure Azure policies or you want to identify and organize your resources, say your environment is dev. Your customer is Contoso. You can organize and categorize that way.

 

 Step 9: So,  go ahead and go to review and create right before you create the resource and take one last look at your estimated cost. View maybe the cost summary if you want to look one more time and see the settings that you have configured for this database. 

 

Step 10: It runs one last validation to make sure there aren’t any issues. And then you can go ahead and create. Once you hit create, it takes you to the deployment status page. For every resource in Azure, it gives you status, how long is the deployment taking? What are the different things being done? You are creating a database and a server, so you will see the status of each as they succeed or fail.

 

Hence, this is how you can create an Azure SQL database using all configuration options on the Azure portal.


Last Updated : 30 Mar, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads