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

DIFFERENCES BETWEEN SQL AZURE AND SQL SERVER

SQL Azure is in very very similar to SQL Server in terms of TSQL and other common features in SQL Server. But there are few limitations of SQL Azure with respect to SQL Server.

SQL Azure does not support the following:

  • MASTER DATA SERVICES (Introduced in SQL Server 2008 r2)
  • SQL Server Utility
  • Common Language Runtime (CLR)
  • Service Broker
  • Database Mirroring
  • XML Indexing
  • Database Mirroring
  • Backup and Restore
  • Backup and Restore (SP’s from DLL’s)
  • SQL Server Agent
  • Replication
  • Table Partitioning
  • SQL Server Replication
  • Resource Governor
  • PolicyBased Management
  • Large User Defined Data Types
  • Full-Text Search
  • Data Compression
  • Extension methods USING CLR
  • Extension spatial types USING CLR
  • External Key Management
  • Sparse Columns
  • Transparent Data Encryption
  • Data Auditing
  • UDAs – User Defined Aggregates
  • Data Collector
  • FILESTREAM
  • Extended Events

WHAT IS SQL AZURE

WHAT IS SQL AZURE?

SQL AZURE is basically SQL Server Hosted in a cloud envirorment. This means it has the power of SQL Server and The power of Cloud Computing both held together.

SQL AZURE helps users Focus on their application and not the infrastructure required for running the application.

All the necessary Hardware, Software required for creation of SQL Server is taken care by the Cloud Service Provider.

By opting to SQL Azure the Hardware requirements and burden of hardware maintainence are moved away from the user and the user can concentrate on development of SQL Databases and hence enhances the ability of companies in creating SQL Code.
SQL Azure takes care of enviromental conditions like server setup, harddisk setup, processors etc and provides high availability, good levels of security.

SQL Azure Will for sure be the future of SQL Server databases as we see companies migrating from their self hosted servers to SQL Azure.

Users have high levels of options to opt SQL Azure in the Country Region where they wish to set up.

Users have to pay as they use and they would have options to reduce or increase their Disk spaces hence enhancing the Budget Capabilities of SQL Azure Users.

There are certain differences between SQL Azure and SQL Server hosted on local boxes. These differences are eloborated in the below link.
DIFFERENCE BETWEEN SQL AZURE AND SQL SERVER

SQL Azure was formally called as SQL Server Data Services and later it was called as SQL Services. SQL AZURE cloud based services are provided by Microsoft.