Create Azure Database

Hi Guys, 

This is very interesting post. I will create an account on Azure and then create an Azure Database and finally I will access Azure Database from my Local computer, and if you want I can give access to you as well, you can access my Azure Database from your laptop/system...

What is Azure ? 
Azure is cloud computing service, we do not need to download any program to use it. Everything is offloaded to internet like Databases, Power BI, Storage, and there are thousands of services available on the azure cloud like..... Azure DevOps, Virtual Machines, Azure SQL Database, Azure Active Directory, Azure Backup, Data Factory, etc etc..

There are some steps before creating an Azure Database, like Resource, Servers, Network, etc..

And there were many more options as well, its a new WORLD.

Lets create Azure Database and explore Azure CLOUD options.
-------------------------------------------------------------

NOTE: Be careful; while creating services on Azure account, you have to provide your mobile no, address and credit card details, you will be charged as per service usage then DO NOT blame me :)   

--------------------------------
First, Create Azure account.

Login with your email 

Provide your details..... Mobile No and Credit card details..

Welcome to Azure Account..

Lets create our first service... Azure SQL Database.
Click in the top, in search engine and search SQL Database

Select SQL Database and click on Add button to create SQL DB.

Now, First we need to create a Resource Group, it is a container that holds related resources for an Azure Solution.

Then you need to create a server and write database name.

For server,,, please write down server name, username and password for future use.

Select NO for elastic pool, check below image

Backup Storage redundancy... select locally-redundant backup storage

Then in Networking ..click on Add your IP button.. and next window..
select Sample in Data source.. AdventureWorksLT will be created with sample data.

click next, ignore tags and on next page...

Review and create.. and we can see estimated cost is 20.60 AUD.

Create and we can see deployment is in progress.

My resource is created now...

On the left hand side, we have got various different options, I am going to use Query Editor to query the database.

Login to Query Editor

Now, this is my Azure SQL DB and I can query the data, check below image.

-----

Now, I will try to connect this Azure Database from my locally installed SSMS. 

After connecting SSMS with Azure DB, let's query the database.

Great... we are now connected to AZURE SQL Database. WOW :)

Thanks for visiting my post.