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

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: https://windows.azure.com/

  • Purchased subscription
  • Created Server
  • Created Database
  • Connect using Database

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

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.

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.

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

You can connect using either Azure Portal or SSMS.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

7 thoughts on “SQL SERVER – Introduction to SQL Azure – Creating Database and Connecting Database

  1. 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

  2. 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

  3. Pingback: SQLAuthority News – An Year Worth Remembering and Looking Forward to Better Next Year « SQL Server Journey with SQLAuthority

  4. Pingback: SQL SERVER – DACPAC and SQL Azure – Quiz – Puzzle – 12 of 31 « SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s