SQL Data Services will be more like SQL Server

I have to say when I got to discussing SQL Server Data Services as was with James Rowland Jones at SQL Bits cubed it left me a bit cold.  I am not a web developer I guess because I am too old, but while the ACE (Authority, Containers and Entities and Flexible Entities) model sounded attractive it looked like back to the drawing board if you wanted to port your application from SQL Server in your data centre to the cloud.

That has changed and SDS will now support SQL (T-SQL) and understand transactions like any relational database. For a simple soul like me it seems that this is for the better -  If I have written a load of code to work with SQL Server on my phone/ laptop/server shouldn’t I also be able to also opt to deploy that to the cloud, without having to rewrite it? 

This announcement was only made yesterday and the only public details I could find are on the SDS blog. So many of the other resources on MSDN and the SQL Server micro-site have yet to be changed, and I need to get hold of James to reshoot it hopefully at the next SQL Bits!  

Technorati Tags: SQL Data Services,Software plus Services,Cloud Computing,SQL Server

Comments

• Anonymous
  March 11, 2009
  Hi Andrew, I am game if you are! For those of you thinking about attending SQLBits  http://www.SQLBits.com Simon Munro http://blogs.conchango.com/simonmunro will also be presenting on the differences between Azure Storage and SDS.  Should be fun! Cheers, James

• Anonymous
  March 18, 2009
  I had a bunch of stuff to do at the same time today – a variety of watching, listening, tweeting, responding,