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!


Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.
Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

John Fontana

Network World
Show Comments

Brand Post

Most Popular Reviews

Latest Articles


PCW Evaluation Team

Luke Hill


I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Laura Johnston

MSI GS65 Stealth Thin

If you can afford the price tag, it is well worth the money. It out performs any other laptop I have tried for gaming, and the transportable design and incredible display also make it ideal for work.

Andrew Teoh

Brother MFC-L9570CDW Multifunction Printer

Touch screen visibility and operation was great and easy to navigate. Each menu and sub-menu was in an understandable order and category

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.

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?