Microsoft adds database to list of online services

SQL Server Data Services designed to give users storage, query capabilities without having to build infrastructure

Microsoft Wednesday added SQL Server Data Services to its freshly introduced lineup of online infrastructure services for corporate users and said it is registering users now for the beta.

Ray Ozzie, Microsoft's chief software architect, disclosed the new service during his keynote address at the company's annual Mix conference in the US. He said SQL Server would be used to create a database in the cloud to support all types of applications.

"This highly scalable database service will bring the benefits of SQL Server for developers into the cloud," said Ozzie.

Ozzie's announcement follows Monday's kick off of a beta program to introduce online infrastructure services around Exchange 2007 and SharePoint 2007 to corporate users of any size.

Microsoft also said it will launch a beta of Office Communications Server (OCS) available in the second half of 2008, called Office Communications Online, to round out its suite of online services, which will also include Web-based conferencing via Live Meeting.

Microsoft said SSDS will be targeted at small and midsized businesses to help reduce costs, corporate users to support applications and sharing data, and at developers and service providers.

Microsoft said some of the use cases would revolve around storage of archival or reference data, storage of large amounts of structured or semi-structured data using a flexible schema, run applications on the Internet that can tolerate some latency, and support for business needs such as HR services, healthcare records management, data archiving and Internet facing applications like social networking and picture sharing.

Microsoft said the database server will be exposed via Simple Object Access Protocol and REST APIs, which will allow the creation of authorities, containers and the creation, update and deletion of single entities.

Users will be able to upload and query data and access large unstructured data objects using a URL.

Users will pay for each "account" they open and each will be accessed using a unique Windows LiveID. Microsoft did not announce pricing for accounts.

SSDS will support a text-based query language that follows the LINQ pattern for C#, Microsoft said.

Microsoft will offer security at the account, authority and container levels. Each authority is secured by a single "secret key" granting read/write access. In addition, each container within an authority is secured by its own single "secret key" granting read/write access. User also can make the contents of containers read-accessible to a general audience.

The primary wire format for SSDS is XML, but Microsoft said multiple protocols including AtomPub would be supported.

Microsoft also used the Mix 08 keynote to unveil betas of Internet Explorer 8 and Silverlight 2.0 and demo the software.

Join the newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection
Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

John Fontana

Network World
Show Comments



Victorinox Werks Professional Executive 17 Laptop Case

Learn more >



Back To Business Guide

Click for more ›

Most Popular Reviews

Latest Articles


PCW Evaluation Team

Louise Coady

Brother MFC-L9570CDW Multifunction Printer

The printer was convenient, produced clear and vibrant images and was very easy to use

Edwina Hargreaves

WD My Cloud Home

I would recommend this device for families and small businesses who want one safe place to store all their important digital content and a way to easily share it with friends, family, business partners, or customers.

Walid Mikhael

Brother QL-820NWB Professional Label Printer

It’s easy to set up, it’s compact and quiet when printing and to top if off, the print quality is excellent. This is hands down the best printer I’ve used for printing labels.

Ben Ramsden

Sharp PN-40TC1 Huddle Board

Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.

Sarah Ieroianni

Brother QL-820NWB Professional Label Printer

The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.

Ratchada Dunn

Sharp PN-40TC1 Huddle Board

The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.

Featured Content

Product Launch Showcase

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?