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



Comments

  • 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

  • Mobile is introducing sweeping changes throughout your workplace. As a senior stakeholder driving mobile initiatives in your organization, you may be lost in a sea of technologies and claims from vendors promising rapid delivery of applications to your employees, customers, and partners. To help explain some of the topics you will need to be aware of, and to separate the must-haves from the nice-to-haves, this reference guide can help you with applying a mobile strategy in the context of application …

  • Java developers know that testing code changes can be a huge pain, and waiting for an application to redeploy after a code fix can take an eternity. Wouldn't it be great if you could see your code changes immediately, fine-tune, debug, explore and deploy code without waiting for ages? In this white paper, find out how that's possible with a Java plugin that drastically changes the way you develop, test and run Java applications. Discover the advantages of this plugin, and the changes you can expect to see …

Most Popular Programming Stories

More for Developers

Latest Developer Headlines

RSS Feeds