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

    1. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Training in Chennai. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.

  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. Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
    Android Training in Chennai
    Ios Training in Chennai

  13. Really an amazing post..! By reading your blog post i gained more information.
    Embedded Project Center in Chennai | Embedded Project Center in Velachery

  14. Thanks a lot very much for the high quality and results-oriented help. I won’t think twice to endorse your blog post to anybody who wants and needs support about this area.

    data science training in chennai

  15. Thanks for making me this article. You have done a great job by sharing this content in here. Keep writing article like this. Graphic Design Training in Chennai | Multimedia Training Institute in Chennai | Adobe Photoshop Training in Chennai

  16. You made some good points there. I did a search on the topic and found most people will agree with your blog.
    ME/M.Tech Project Center in Chennai | ME/M.Tech Project Center in Velachery

  17. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.

    selenium Training in Bangalore

  18. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly. 
 MCSE Training in Chennai | Hardware and Networking Training in Chennai


  19. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    Selenium Training in Jayanagar