Feeds

Microsoft promises 'first' relational cloud storage

Policy U-turn adds SQL Server network protocol

Protecting against web application threats using SSL

Microsoft has revealed a single, simple change for its cloud platform that should make full SQL-Server functionality available almost overnight this year.

Microsoft said it will expose the Tabular Data System (TDS) protocol used in its popular SQL Server database as a service protocol in the online SQL Data Services (SDS) system. The first outing will be in a community technology preview (CTP) in the middle of the year with commercial availability planned for the second half of 2009.

Microsoft boasted the change would make SDS - part of its nascent Azure Services Platform - the industry's “first” relational database service, letting you run many existing SQL Server applications online.

The proof of such claims will be in the actual testing and deployment, once the service becomes available. Ahead of that, Microsoft set some limits on what it wants to see running on SDS.

Senior program manager David Robinson blogged Tuesday that Microsoft is "initially" targeting web and departmental applications with the change. So don't go putting your SAP HR system on SDS.

The company's SDS team revealed the change after Microsoft general manager for developer and platform evangelism Mark Hindsbro told The Reg last month Microsoft was working as fast as possible to add as many of the SQL Server features to Azure.

Using TDS will make help make available bread-and-butter SQL Server features in SDS such as tables, stored procedures, triggers, views and indexes in the cloud. You should also be able to access them using existing SQL Server and T-SQL tools and skills.

Robinson wrote: "Given the feature set we are planning to support in SDS v1, a majority of database applications will 'just work', allowing developers to target on and off-premises deployments with essentially the same code base."

The change follows pressure from early SDS testers and means Microsoft is dumping its original plan to slowly add relational functionality to the SOAP and REST web services layer around SDS.

The company plans to announce plans for decommissioning the existing REST-based SDS services with the introduction of the new TDS-based SDS service.

At this stage, it sounds like the separate-but-related Azure table storage will become the refuge for those who want to continue with the REST approach. Azure table storage will expose an ADO.NET-Data-Services compliant REST Service endpoint that Microsoft said would meet people's needs.

The company is devising guidance and a migration path for early adopters who jumped on the pre-relational architecture. ®

The next step in data security

More from The Register

next story
New 'Cosmos' browser surfs the net by TXT alone
No data plan? No WiFi? No worries ... except sluggish download speed
'Windows 9' LEAK: Microsoft's playing catchup with Linux
Multiple desktops and live tiles in restored Start button star in new vids
iOS 8 release: WebGL now runs everywhere. Hurrah for 3D graphics!
HTML 5's pretty neat ... when your browser supports it
Mathematica hits the Web
Wolfram embraces the cloud, promies private cloud cut of its number-cruncher
Google extends app refund window to two hours
You now have 120 minutes to finish that game instead of 15
Intel: Hey, enterprises, drop everything and DO HADOOP
Big Data analytics projected to run on more servers than any other app
Mozilla shutters Labs, tells nobody it's been dead for five months
Staffer's blog reveals all as projects languish on GitHub
SUSE Linux owner Attachmate gobbled by Micro Focus for $2.3bn
Merger will lead to mainframe and COBOL powerhouse
iOS 8 Healthkit gets a bug SO Apple KILLS it. That's real healthcare!
Not fit for purpose on day of launch, says Cupertino
prev story

Whitepapers

Providing a secure and efficient Helpdesk
A single remote control platform for user support is be key to providing an efficient helpdesk. Retain full control over the way in which screen and keystroke data is transmitted.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
Protecting users from Firesheep and other Sidejacking attacks with SSL
Discussing the vulnerabilities inherent in Wi-Fi networks, and how using TLS/SSL for your entire site will assure security.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.