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

Different Flavor of Azure SQL Database

We have three different Kind of Databaase deployment in Azure SQL database:

•          Singleton:
•          Elastic Pool:
•          Managed Instance

Singleton : With a single database, each database is isolated from each other and portable, each with its own service tier within the DTU-based purchasing model. The single database deployment option creates a database in Azure SQL Database with its own set of resources and is managed via a SQL Database server.

Elastic Pool: SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price.

Managed Instance: A managed instance in Azure SQL Database is a fully managed SQL Server Database Engine Instance hosted in Azure cloud. This is the best PaaS option for migrating your SQL Server database to the cloud.

Note: For Azure SQL Database single databases and elastic pools, only master Database and tempdb Database apply. For Azure SQL Database Managed Instance, all system databases apply. For more information on Managed Instances in Azure SQL Database

Post Reference: Vikram Aristocratic Elfin Share