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:

  • 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)

Previous Post
SQLAuthority News – Pluralsight On-Demand FREE for SQL Server Course
Next Post
SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

Related Posts

No results found.

5 Comments. Leave new

  • 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
  • Thanks for sharing this information, azure looks pretty cool. I am going to check this one.

    Reply
  • 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
  • Excellent program! Very easy to use.

    Reply
  • not getting the pics

    Reply

Leave a Reply

Menu