New SQL Azure Features Available

New features introduced to Microsoft’ Cloud data platform make it easier for customers to migrate away from on-premise deployments, according to David Robinson, SQL Azure senior program manager. In this regard, SQL Azure now features Multiple Active Results Sets, ALTER rename and Application and Multi-server management. The evolution of SQL Azure was announced at the end of the past week, and the new additions are now live for customers to leverage and test-drive.

“These news features include: MARS (Multiple Active Results Sets), which simplifies the application design process; ALTER rename process for symmetry in renaming databases; Application and Multi-server management for Data-tier Applications which further streamlines application design and enables deployments of database applications directly from SQL Server 2008 R2 and Microsoft Visual Studio 2010 to SQL Azure for database deployment flexibility,” Robinson stated.

SQL Azure (formerly SQL Server Data Services and later SQL Services) is a cloud-based service from Microsoft offering data storage capabilities similar to Amazon S3 and Amazon Relational Database Service as a part of the Azure Services Platform. Unlike similar cloud-based databases, SQL Azure allows relational queries to be made against stored data, which can either be structured or semi-structured, or even unstructured documents. SQL Azure features querying data, search, data analysis and data synchronization.

SQL Azure uses Microsoft SQL Server as a backend, but it exposes only a subset of the data types — including string, numeric, date and boolean. It uses an XML-based format for data transfer. Like Microsoft SQL Server, SQL Azure uses T-SQL as the query language and Tabular Data Stream (TDS) as the protocol to access the service over internet. It does not provide a REST-based API to access the service over HTTP. Microsoft recommends using ADO.NET Data Services for this purpose.

Earlier this month, Microsoft expanded the global availability of the Windows Azure platform, which also includes SQL Azure. Both the Cloud operating system and the data store are now available to customers in 41 countries and regions worldwide, up from 21 when Windows Azure was initially introduced. Streamlining migration from on-premise to the Cloud is a strong focus for Microsoft, and, with the new SQL Azure features, the company aims to simplify design and deployment tasks for customers opting for hosted Database Management Systems (DBMS).

“Many customers have looked to SQL Azure as an alternative to MySQL due to the fact that it provides a simple way to offer a highly available and publicly accessible data store. A primary issue customers have faced in the migration process from a database such as MySQL is the ability to support multiple active resultsets (MARS),” Robinson added.

MARS, ALTER rename and Application and Multi-server management

View Article


  • There are no comments yet. Be the first to comment!

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Moving from an on-premises environment to Office 365 does not remove the need to plan for disruptions or reduce the business risk requirements for protecting email services. If anything, some risks increase with a move to the cloud. Read how to ease the transition every business faces if considering or already migrating to cloud email. This white paper discusses: Setting expectations when migrating to Office 365 Understanding the implications of relying solely on Exchange Online security Necessary archiving …

  • Anthony Christie, the Chief Marketing Officer for Level Communications, is responsible for customer experience, worldwide marketing and product management. In this informative asset, he shares his insights into why a private network connection to cloud-bases applications is the right decision for your enterprise. Download now to find out more.

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date