Monday, 12 January 2015

Understanding SQL Server on Windows Azure VS Azure SQL database

Often people get confused with the two different types of SQL Server service available on Azure or Microsoft cloud services,

1.       SQL Server on Windows Azure
2.       Azure  SQL Server Databases

SQL Server on Windows Azure:-

SQL Server on Windows Azure is nothing but a regular instance of SQL Server installed on a Virtual Windows machine hosted on Cloud (Windows Azure), a virtual server hosted in Microsoft data centre instead of On-Premises Data Centre. You can use the Windows and SQL Server similar to your on-premises system. The Windows and SQL will still Admin to manage the environment. Microsoft calls the category of SQL Server in Azure Virtual Machine (VM) as Infrastructure as a Service (IaaS) 

Microsoft has come up with many pre-defined SQL Server configured images so when you provision your virtual Machine in Azure you can straight away request for a SQL Server Image which will have your SQL server installed when the system is delivered.
There are various purchase option for cloud based SQL Services available, without going much into various option broadly you can either subscribe a licence for SQL Server Image which holds both windows or SQL Server Licence or you can just subscribe a Windows Azure image and install the SQL Server yourself and use if have any existing licence.

Azure SQL Server Databases:-

Azure SQL Database is a relational database-as-a-service, where Microsoft offers Database as a service. These databases are hosted in servers maintained by Microsoft and the server layer is not visible to the users or admins. In this configuration database maintenance requirements are very minimal as we do not control any physical features of the database and you do not have to maintain the server infrastructure.Microsoft calls the category of Azure SQL Databases as Platform as a Service (PaaS)

Since Azure SQL databases works on a slight different architecture to standard SQL databases there also some limitation with this type of databases. All the server features are in accessible as only database is offered as service and almost all system objects are not visible making it difficult to manage the database.

Find more details on features not supported by Azure SQL databases.

Below is an image of a SQL Instance hosted of Windows Azure and Azure SQL database just to have look and feel difference when accessed through SSMS. The First Image is the Windows Portal for Azure which has two sections highlighted Virtual Machine section is where we create Windows Azure and SQL Databases is the section we can create Azure SQL databases. The second Image shows how SQL database on Windows Azure and Azure SQL databases looks like in SSMS.

In my next post we will discuss how to create  SQL Server on Windows Azure and Azure SQL databases in detail with some screen shots.


  1. Nice information. I was searching for the same. It helped me alot and saved my time. Thanks alot. , windows azure training in hyderabad

  2. I didn't spend much time to visit many websites. But today I found this accidentally and I got more information from your site.
    Windows Azure course in Chennai | Azure Training center in Chennai | Microsoft windows azure Training

  3. I have been reading out a lot of your articles and that i ought to say pretty nice stuff.
    I will certainly bookmark your Blog.neha
    Hybris Online Training
    Devops Online Training

  4. Excellent post! Thank you for Sharing. We are the best erp software providers in chennai. For more details call +91 9677025199 or email us on
    erp in chennai

  5. The best thing is that your blog really informative thanks for your great information!
    erp providers in chennai

  6. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

  7. Really an amazing post..! By reading your blog post i gained more information.
    Bulk SMS Chennai
    Internet Marketing Company Chennai

  8. Awesome blog, The concept of azure SQL was really fantastic and easy to understand manner. Thanks for sharing. Best Dot Net Training in Chennai | Best Java Training in Chennai | Best Web Design Training in Chennai

  9. Nice and good article.. it is very useful for me to learn and understand easily.. thanks for sharing your valuable information and time.. please keep updating.
    No.1 IOS Training Institute in Chennai | Best Android Training Institute in Chennai | Java Training Institute in Chennai

  10. Thanks for sharing your valuable and informative article..keep updating your amazing blog here.
    Final Year Project Center in Chennai | IEEE Project Center in Chennai | Diploma Project Center in Chennai

  11. Thanks For Your valuable posting, it was very informative
    Webdesign Lüdenscheid

  12. Those guidelines additionally worked to become a good way to recognize that other people online have the identical fervor like mine to grasp great deal more around this condition.
    big data training in Chennai

  13. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    VMware Exam Centers in Chennai | VMware Exam Centers in Velachery

  14. It was a precious experience which led my teaching abilities to a much better level.

    Big data training in chennai| Hadoop training in chennai

  15. Awesome post. Really you are shared very informative concept... Thank you for sharing. Keep on updating...


    Guest posting sites

  16. The blog you had post is verymuch useful for us to know about the Web designing. thanks for your information sharing ith us.
    Web Designing Institute in Coimbatore
    Web Designing Course
    Web Design Classes
    Website Design Course
    Learning Web Design

  17. Awwsome informative blog ,Very good information thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.
    Airport Ground Staff Training Courses in Chennai | Airport Ground Staff Training in Chennai | Ground Staff Training in Chennai

  18. Awwsome informative blog ,Very good information thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.
    Airport Ground Staff Training Courses in Chennai | Airport Ground Staff Training in Chennai | Ground Staff Training in Chennai

  19. I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.
    RPA Training in Chennai
    RPA course
    Robotic Process Automation Certification
    RPA Training
    RPA Training Institute in Chennai
    Robotic Process Automation Courses

  20. This is a good post. This post give truly quality information. I’m definitely going to look into it. Really very useful tips are provided here. thank you so much. Keep up the good works.
    German Classes in Chennai
    German Training in Chennai
    German classes chennai
    German teaching institutes in chennai
    German Training Institutes in Chennai
    German Training Chennai

  21. More informative,thanks for sharing with us.
    this blog makes the readers more enjoyable.keep add more info on your page.
    Core Java Training in Bangalore
    Java Courses in Chennai Ambattur
    Java Training in Saidapet
    Java Training in Navalur

  22. Hi,
    I must appreciate you for providing such a valuable content for us. This is one amazing piece of article. Helped a lot in increasing my knowledge.
    Java Training in Chennai
    PHP Training in Chennai
    Java Classes in Chennai
    Core Java Training in Chennai
    PHP Training Center in Chennai
    PHP Institutes in Chennai

  23. Very impressive blog! i liked it and was very helpful for me.Thanks for sharing. Do share more ideas regularly.

    Oracle DBA Training in Chennai

  24. All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.
    Selenium Training in Chennai
    Selenium Training
    iOS Training in Chennai
    Future of testing professional
    Digital Marketing Training in Chennai
    core java training in chennai
    Loadrunner Training in Chennai
    Loadrunner Training