SQLAuthority News – Whitepaper – SQL Azure vs. SQL Server

SQL Server and SQL Azure are two Microsoft Products which goes almost together. There are plenty of misconceptions about SQL Azure. I have seen enough developers not planning for SQL Azure because they are not sure what exactly they are getting into. Some are confused thinking Azure is not powerful enough. I disagree and strongly urge all of you to read following white paper written and published by Microsoft.

SQL Azure vs. SQL Server by Dinakar Nethi, Niraj Nagrani

SQL Azure Database is a cloud-based relational database service from Microsoft. SQL Azure provides relational database functionality as a utility service. Cloud-based database solutions such as SQL Azure can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead. This paper compares SQL Azure Database with SQL Server in terms of logical administration vs. physical administration, provisioning, Transact-SQL support, data storage, SSIS, along with other features and capabilities.

The content of this white paper is as following:

  • Similarities and Differences
    • Logical Administration vs. Physical Administration
    • Provisioning
    • Transact-SQL Support
    • Features and Types
  • Key Benefits of the Service
    • Self-Managing
    • High Availability
    • Scalability
    • Familiar Development Model
    • Relational Data Model

The above summary text is taken from white paper itself.

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

SQL Azure, SQL White Papers
Previous Post
SQLAuthority News – Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010
Next Post
SQLAuthority News – Win MS Office License – Last 2 days

Related Posts

3 Comments. Leave new

  • I had the same misconceptions about sql azure, will sure check it out.
    Thank you

  • Fabricio Lima
    May 27, 2010 2:04 am

    Thanks for this paper…

  • Is Microsoft using Windows Azure for Microsoft datacentres only, or it is commericialized for other vendors , so that they could make their indepenet cloud computing in their datacentres itself using Azure.


Leave a Reply