SQL SERVER – Introduction to SQL Azure – Creating Database and Connecting Database

April 27, 2011

I recently logged into new Azure Portal and I really think the product team has done excellent job to make it user-friendly and self intuitive.

Here are the quick steps I have done after I logged into the portal here:

Purchased subscription
Created Server
Created Database
Connect using Database

Honestly it is that simple. Here is the screen representations of the same.

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure2

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure3

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure4

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure5

Here you can specify your current IP address in start and end range. This way only from your IP you can connect to the server.

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure6

I have noticed that one developer kept the IP Range Start: 0.0.0.0 and IP Range End: 255.255.255.255 so he can connect to the database from any IP in the world. I strongly advise against this as this can be really big security issue for you.

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure7

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure8

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure9

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure10

Now you can directly connect to your Azure using [Writeyourservername].database.windows.net.

SQL SERVER - Introduction to SQL Azure - Creating Database and Connecting Database azure11

You can connect using either Azure Portal or SSMS.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – Pluralsight On-Demand FREE for SQL Server Course

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

No results found.

5 Comments. Leave new

sachin soni
April 27, 2011 3:50 pm
hello pinal sir,
how r u?, its gud for an overview of SQl azure. i wanna know, as a DBA how sql azure is help full or if it has a different path from Data base administration thn shud we prefer to go with this sql azure, hows the carrer wid tht.?
thnx
sachin soni
Reply
Ramdas
April 27, 2011 7:09 pm
Thanks for sharing this information, azure looks pretty cool. I am going to check this one.
Reply
DILIP
July 15, 2011 11:17 am
HI Sachin,
You can connect to SQL azure from your home (if you have internet and if you IP is added in the azure portal ).
You can connect to the SQL DB (Onpremise) if you have your office domain or network.
As of now SQL Azure DB is limited to 50 Gb for the Business and Azure team is going to incresae the space by Nov 2011 in the portal.
If you have SQL azure in place , no need of High availability concepts like Replication,clustering,logshipping and Mirroring in SQL DB.You have Data sync API which will sync the data between your onpremise db and the azure db.
You can change/allocate the space required for your db at any time from the azure portal.
You can connect to the SQL Azure with the SQL authentication only.
Your SQL Azure will not be down until or unless if the region where your azure subscrption is held.So you data will be available always.
We do have few limitataions in SQL Azure like you may not able to do the query in the cross db.
Please let me know if you need any more information.
Regards,
Dilip Reddy
Reply
Phil
August 18, 2011 2:09 pm
Excellent program! Very easy to use.
Reply
kolkata
September 21, 2011 4:51 pm
not getting the pics
Reply