In this article, we'll learn about Azure SQL Database and how to create a single serverless database in Azure. This tutorial will come handy while working with Azure Data Studio and learning the tutorial in the Azure Data Studio Series and many more to follow.
Serverless
Serverless is basically a method of computing where the demanded resources are made available as they are needed by the processes. The engineers can code and deploy their systems without having to worry about the infrastructure that lies underneath. Since the client only pays based on the computation used, the old methods of having to pay a fixed amount for specific bandwidth and number of servers have now become obsolete and they play on a rolling basis as the use of the service which supports auto-scaling.
Azure SQL Database
Azure SQL Database is a service provided by Azure enabling the power of cloud technology to provide database service from the cloud. Azure SQL Database runs on Azure capable of numerous benefits of cloud computing thus making it highly scalable, resilient, highly available along with security to ensure complex needs of businesses are taken well care. From Business Continuity to Disaster Recovery discussed in the previous article, Business Continuity And Disaster Recovery In Azure For SQL Database, Azure SQL Database has numerous pros to traditional on-prem databases.
Now, let us learn to Create a Single Serverless Database. There is a key difference with the Serverless Database compared to Provisional one. With the single serverless database we now create learning from this tutorial, we can benefit from numerous Azure Serverless features.
How to Create a Single Serverless Database in Azure?
Step 1
First of all, Sign in to Azure Portal. You’ll be welcomed to the Home Page that looks like the following.
Step 2
Click on Create Resource and Search for SQL deployment.
Step 3
Now, you’ll be provided with options for different services.
Under SQL Databases, Single Database click on Create.
Step 4
Fill in the details for the project and Database details.
Note: If in the Database Server is not already created, Click on Create new and create one with adding in the server admin login and password as follows.
Step 5
Now, to create the Serverless database, Click on the Configure database.
Here, you’ll be provided with the options for the Servier and Compute Tier. In order to use the database based on serverless, Switch the selection to Serverless and Apply.
Step 6
Now, you can Click on Create to proceed the deployment.
Step 7
The updates of the deployment progress can be seen along with the pop up in notification.
Step 8
Once, the deployment is complete, we can now click on the Go to resource to check out the database created.
Step 9
Here, we can see ojashdatabase in the ojash SQL Server.
We can use the database in Azure Data Studio and many more platforms. All you need to do is access the database with the server name.
Conclusion
Thus, in this article, we learned about Azure SQL Database and learned through the step-by-step tutorial to create a single serverless SQL Database in Azure. Numerous other tasks and applications can now benefit from the serverless database you’ve now created.