SQL in Cloud

Recent Posts

  • Inconsistent database ids in SQL Azure V12
  • Taking database offline SQL DB
  • Minimize login time in SQL DB V12
  • Full-text search in SQL Azure
  • Alter database – SQL Azure V12

Recent Comments

    Archives

    • May 2016
    • December 2015
    • July 2015
    • May 2015
    • April 2015

    Categories

    • SQL Azure
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Why SQL Azure



    Microsoft Azure SQL Database is a cloud-based service from Microsoft offering Relational Database Service as a part of the Azure Services Platform. Unlike similar cloud-based databases, SQL Database allows users to make relational queries against stored data, which can either be structured or semi-structured, or even unstructured documents.[1] SQL Database features querying data, search, data analysis and data synchronization.

    I just don’t want to write yet another article on why to consider this but provide quick bullet points on what is unique and the limitations compared to on premise DBs.

    Advantages

    • Built in high availability
    • No Hardware OR software maintenance
    • Always on latest and greatest bits
    • Scale up and scale down with no down time
    • Resource Reservation
    • Relational database
    • Built in Disaster Recovery with Geo Restore feature
    • Handles OOPS scenarios with Point in time restore functionality

     

    Limitations:

    • Not all SQL Server features are available, for example cross database transactions, service broker, file stream etc
    • Not all important SQL server settings are configurable, for example Max DOP
    • Not easy to migrate from on premise to Azure with no down time
    • Database size limitation
    • Premium SKUs are a little expensive compared to SQL Azure VM
    • Frequent disconnects because of upgrades and no control over it

    Leave a comment Cancel reply

    Your email address will not be published. Required fields are marked *

    Pages

    • Alter database in SQL V12
    • Changing MAX_DOP setting in SQL Azure DB V12
    • Connection Pooling and Isolation level reset
    • Contained users in SQL Azure DB V12
    • Full-text search in SQL Azure
    • Large Index Rebuild in SQL Azure V12
    • Row versioning in SQL Database version (V12)
    • Sql Azure db – database offline

    Archives

    • May 2016
    • December 2015
    • July 2015
    • May 2015
    • April 2015

    Categories

    • SQL Azure (8)
    • Uncategorized (3)

    WordPress

    • Log in
    • WordPress

    Subscribe

    • Entries (RSS)
    • Comments (RSS)
    • Alter database in SQL V12
    • Changing MAX_DOP setting in SQL Azure DB V12
    • Connection Pooling and Isolation level reset
    • Contained users in SQL Azure DB V12
    • Full-text search in SQL Azure
    • Large Index Rebuild in SQL Azure V12
    • Row versioning in SQL Database version (V12)
    • Sql Azure db – database offline