SQL Azure Limitations and Supported Features

Even though SQL Azure is based on SQL Server, it includes some limitations because of its Internetavailability and cloud deployment. When you use SQL Server on-premises, the tools and client APIs havefull access to the SQL Server instance, and communications between the client and the database are in ahomogeneous and controlled environment.The first release of SQL Azure has only limited functionality of the SQL Server database. One of themost important limitations in SQL Azure is that fact that the size of the database can’t exceed 10GB. So,as a database administrator or an architect, you must plan the growth and availability of dataaccordingly. The supported and unsupported features of SQL Azure in version 1.0 are described below.

Database Features

SQL Azure supports the following database features:
• CRUD operations on tables, views, and indexes
• TSQL query JOIN statements
• Triggers
• TSQL functions
• Application stored procedures (only TSQL)
• Table constraints
• Session-based temp tables
• Table variables
• Local transactions
• Security roles
SQL Azure does not support the following database features:
• Distributes query
• Distributed transactions
• Any TSQL query and views that change or retrieve physical resource information,
like physical server DDL statements,1 Resource Governor, and file group
• Spatial data types

Application Features

SQL Azure does not support the following application-level features:
• Service Broker
• HTTP access
• CLR stored procedures

Administration Features

SQL Azure supports the following administration features:
• Plan and statistics
• Index tuning
• Query tuning
SQL Azure does not support the following administration features:
• Replication
• SQL profiler
• SQL trace flag
• Backup command
• Configuration using the sp_configure stored procedure

Leave a Comment