- Easier management of large databases to support heavier workloads with parallel queries (Premium only), table partitioning, online indexing and worry-free large index rebuilds with 2GB size limit removed, and alter database command.
- Support for key programmability functions to drive more robust application design with CLR, T-SQL Windows functions, XML index, and change tracking.
- Drive breakthrough performance with support for In-memory columnstore queries (Premium only) for data mart and smaller analytic workloads.
- Improved monitoring and troubleshooting: Extended Events (XEvents) and visibility into over 100 new table views via an expanded set of Database Management Views (DMVs).
Preview for greater SQL Server compatibility coming soon to Azure SQL Database
Posted on November 5, 2014
Today at the annual PASS Summit conference, we announced a new preview of Azure SQL Database coming later this year that represents another major milestone for our database-as-a-service. With this preview, we continue our journey to bring industry-leading in-memory technologies to the cloud as well as unlock new functionality that makes it even easier to move SQL Server database applications to the cloud. Primarily focused on unlocking the most popular T-SQL functions, this preview will help you work with heavier database workloads, improve monitoring and troubleshooting, and support more robust applications with support for key programmability functions while support for columnstore index queries will help improve performance for data mart-type analytics. Full documentation and detailed enhancements will be published upon availability of the preview, however, key highlights are as follows: