Creating SQL Database in Azure

In this article, you learn how to use the Azure portal to create Azure SQL PAAS Database

Select SQL Database Service in Azure Portal

Select Add to add a New database. Give the Database Name, Subscription. For New Database Select Source as Blank database. Server selection is the Logical Server. That is unlike in normal SQL Instance, in Azure the Paas Databases are created on Logical instance(or Logical server as we call). We can create a New Database on already existing logical Server or we shall create New Logical Server. Many databases shall be created in a Logical Server.

While Creating a logical Server we need to Create a admin Login to the Logical Server.

ONce the Logical Server has been selected, we need to Select the Pricing tier and Purchasing model to create a Database. Click links to understand more on Purchasing Model and Service Tiers

The Purchasing Model shall be between DTu based purchase model or vCore based Model.

Service Tiers shall be anything between Basic, standard, Premium if its DTU based purchase Model or General Purpose, Business critical, Hyperscale if its vCore based purchase model.