Azure SQL Database In PaaS Model

In this article, we are going to see how to build the Azure SQL Database without Virtual Machines.

In this article, we are going to learn how to build the SQL Database in Azure in a PaaS model.
 
When we say PaaS model, we are actually talking about a fully managed Platform-as-a-Service (PaaS) database engine that handles many of the database management functions (upgrading, patching, backups, and monitoring ) without any user involvement. Let's see the steps to create the single SQL database below one by one.
 
Log into the Azure portal with valid User Id and subscription. 
 
Azure SQL Database In PaaS Model
 
After logging in, please make sure you have created the valid resource group. To start creating the database, select Azure SQL in the left-hand menu and click Add to select the SQL deployment option page.
 
Azure SQL Database In PaaS Model
 
When you click on the Add icon, it will navigate to the page asking you to select the tile with multiple options. In our case, we are going to create the SQL Single Database, select "Create".
 
Azure SQL Database In PaaS Model
 
Clicking on Single Database Resource type create button navigates to the basics tab to enter the subscription and resource group.
 
Choose valid subscription and resource group here.
 
Azure SQL Database In PaaS Model
 
In the Database details, enter the database name and in the server details, click "Create New" and provide valid details in the below sections.
  • Server Name
  • Server admin login
  • Type complex password
  • Location 
Azure SQL Database In PaaS Model
 
After providing the database and server details, you will be having the page something like below.
 
Azure SQL Database In PaaS Model
 
Here, we want to use the SQL elastic pool section. Select the No option.
 
And in Compute + Storage section Select Configure Database.
 
Azure SQL Database In PaaS Model
 
Once you click on configure database, it will navigate to the new page and asking you to select the tier and generation. Select the required details and click Apply.
 
Azure SQL Database In PaaS Model
 
After applying that, select Additional settings tab. Here in the data source section, under existing data, select sample and leave the rest of the value as it is.
 
Azure SQL Database In PaaS Model
Finally, review the final settings and click create. This will initiate the deployment to create the database.
 
Azure SQL Database In PaaS Model
 
Once the deployment is done you will get an alert on the page saying the deployment is complete.
 
Azure SQL Database In PaaS Model
 
That's it!! We have successfully created a single database in the Azure portal. Using the same method, we can import any existing database in Paas. In our next article, we are going to see how to login into the database and execute the query in the same Azure Portal.
 
Thanks for your support!!