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

  • Today's agile organizations pose operations teams with a tremendous challenge: to deploy new releases to production immediately after development and testing is completed. To ensure that applications are deployed successfully, an automatic and transparent process is required. We refer to this process as Zero Touch Deployment™. This white paper reviews two approaches to Zero Touch Deployment--a script-based solution and a release automation platform. The article discusses how each can solve the key …

  • Live Event Date: January 28, 2015 @ 11:00 a.m. ET / 8:00 a.m. PT Check out this upcoming live webcast and join Jeff Sloyer, IBM Developer Evangelist and Master Inventor, for a tutorial for building cloud-based applications. Using IBM's platform as a service, Bluemix, Jeff will show you how to architect and assemble cloud-based applications built for cloud scale. Leveraging the power of microservices, developers can quickly translate monolithic applications to a cloud-based microarchitecture. This hour-long …

Most Popular Programming Stories

More for Developers

RSS Feeds

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