Benefits and Features of SQL Azure

Benefits of SQL Azure:

  • High availability
  • High Fault tolerance
  • ability to create and deply of multiple number of databases
  • Similar to TSQL Used for SQL SERVER, hence makes its use easy
  • PAY AS YOU GO Option for pricing helps users pay for what they use
  • Integration to SQL Server and Visual Studio
  • Scale up and down the databases as per requirement
  • No need to take care of Physical administration of the server

Features of SQL Azure:

  • Cloud based model
  • Similar to SQL Server
  • Similar TSQL Usage
  • Ability to use tables, indexes, views,triggers, stored procedures, functions, roles etc
  • Execution of Joins on multiple tables
  • Transactions are allowed
  • Creation of Temporary tables is allowed
  • System functions like string,datetime are allowed
  • SQL Azure Data Sync

Leave a Reply

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