About Me

My photo
Mumbai, Maharastra, India
He has more than 7.6 years of experience in the software development. He has spent most of the times in web/desktop application development. He has sound knowledge in various database concepts. You can reach him at viki.keshari@gmail.com https://www.linkedin.com/in/vikrammahapatra/ https://twitter.com/VikramMahapatra http://www.facebook.com/viki.keshari

Search This Blog

Sunday, August 25, 2019

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

No comments:

Post a Comment