Creating first database in Azure SQL Database

Login to your Azure Account, here below you can see there is no resource… Click on SQL Database service on left vertical panel

Here you can see there is no SQL Database listed, click on Add on right top area

Few item which need to be understood before creating any database

Subscription: All resources in azure subscription are billed together. You need to select your subscription here.

Resource group: A container that holds related resources for an Azure solution. The resource group includes those resources that you want to manage as a group. You decide how to allocate resources to resource groups based on what makes the most sense for your organization.

Resource: A manageable item that is available through Azure. Virtual machines, storage accounts, web apps, databases, and virtual networks are examples of resources.

Elastic Pool: SQL Database Elastic Pool is a shared resource model that enables higher resource utilisation efficiency, with all the databases within an elastic pool sharing predefined resources within the same pool.

Any database in Azure need to be created under a logical server, to create a logical server, click create new under server link and enter the server name and login detail.

Now configure storage and DTU (database throughput unit), here I am keeping it default Basic

The final version of configuration

Now click on Resource Group and select the recently created resource to see all resource which we created just above .. i.e. server and database

Now we are ready with our first ever database in Azure, lets connect it with SSMS client, but before that, we need to set the firewall to allow our client SSMS IP address registered in Azure logical SQL Server

For setting the firewall in newly created logical SQL Server, go to resource group à go to sql database created à select set server firewall

Click Add Clien IP à Give the IP address à Press Save

Once that is done, go to the resource group à. Select the newly created resource à select the newly created server à go to the server properties à copy the server name

Now lets open SSMS at client machine, enter the server detail which was copied from above, put the login name and password which was set in above steps

Now we are able to connect to our first Azure database

Enjy coding…SQL Azure J

Post Reference: Vikram Aristocratic Elfin Share