Microsoft to switch cloud SQL Server from Web APIs to relational one
Changes will give developers more control over manipulating data, ease porting apps to the cloud
Computerworld - Microsoft Corp. said today that its upcoming hosted database service will switch from standard Web programming interfaces to the same relational one used by its on-premise counterpart.
The software maker said it will give developers more control over manipulating data as well as make it easier for them to port existing database applications to the cloud.
SQL Server Data Services (SDS) will connect to database applications via Tabular Data Stream (TDS), the same protocol used by SQL Server, according to a posting at Microsoft's Data Platform Insider blog.
TDS is compatible with Transact-SQL (T-SQL), a proprietary version of the SQL language long used by database developers to write applications for every major database. T-SQL works with SQL Server and Sybase Corp.'s Adaptive Server Enterprise.
The announcement confirmed a report several weeks ago that Microsoft planned to bring "full SQL Server" to its cloud service.
In testing thus far, SDS had connected to applications via general-purpose Web application programming interfaces (API) such as Representational State Transfer and Simple Object Access Protocol. Although they are popular open standards, REST and SOAP are less fine-tuned for pulling and crunching data compared with T-SQL, say the latter's advocates.
Microsoft plans to "decommission" REST and SOAP support, according to the blog. Programmers who are more comfortable with those interfaces, however, can continue to use them by "building custom services with ADO.Net Data Services" or through the table-storage feature of Microsoft's application-hosting platform, Windows Azure, according to the blog.
SDS with TDS support will be available as a public community technical preview by the middle of this year, and it will launched in the second half of the year.
Read more about Databases in Computerworld's Databases Topic Center.
- IDC MarketScape: Worldwide Client Virtualization Software 2013 Vendor Assessment IDC has placed Citrix in the 2013 IDC MarketScape Leaders Category once again noting that, "Citrix's position reflects the company's market leadership and...
- Infographic: Top Use Cases for Desktop Virtualization A wide range of business issues is driving IT toward desktop virtualization. One solution-Citrix XenDesktop with FlexCast technology-helps IT teams empower their entire...
- Budd Van Lines Moves Data Closer to Home Shipping and logistics company Budd Van Lines uses Infinio to improve performance on their VDI environment. The company employs a virtualized datacenter based...
- Storage Performance with Cost Control As IT groups expand their server virtualization initiatives, central storage performance can become the bottleneck and create poor end user experience.
- The Key to Happiness: Throw out Your Data Warehouse In this webinar, Kerry Reitnauer, Director, Solution Architect at FairPoint Communications will discuss the challenges the data warehouse brought, how they migrated to...
- Building Tomorrow's Data Center with Converged Technologies A number of forces are converging: the cloud, converged infrastructure, big data and fabric architectures to name a few. All Data Center White Papers | Webcasts
Our new bimonthly Internet of Things newsletter helps you keep pace with the rapidly evolving technologies, trends and developments related to the IoT. Subscribe now and stay up to date!