Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ


Choose your language

InfoQ Homepage News SQL Server Data Services: Microsoft's Answer to Amazon S3

SQL Server Data Services: Microsoft's Answer to Amazon S3

This item in japanese


Microsoft has announced SQL Server Data Services (SSDS) at MIX08. Being a storage service on the web, SSDS is Microsoft's Amazon S3 competitor.

SSDS is another Microsoft service running on the web in addition to BizTalk Services. Neil Hutson offers a concise summary of what SSDS is all about:

SSDS you can think of as a structured data store in the cloud(building block service), which is accessed using Internet protocols using a basic data manipulation language. SSDS is for developers and businesses that need scalable, easily programmable, and cost-effective data storage with robust database query capabilities.

The SQL Server Data Services offer a flexible data model, which is structured as follows: Customer > Account > Authority > Container > Entity. Customers are companies or individuals that use SSDS. Each customer might open an arbitrary amount of accounts, which is connected with a unique Windows Live Id. Authorities are a concept analogous to namespaces,  and are  a in the context of billing and geo-location. Containers are a unit of consistency, defining boundaries for search and update operations.  The smallest and fundamental data unit is the entity.

Neil Hudson describes this fundamental data unit as "a Flexible Entity Model, where no schema required and you can update name/value pairs (which is the smallest unit of storage)". The name/value pairs represent properties, whose type information can be changed on the fly. Properties maybe added at any time. SSDS supports "simple types such as decimal, string, bool, etc and all the properties are indexed".

Data can be accessed and altered in many ways:

  • Microsoft Sync Framework (offline access)
  • ADO.NET Data Services
  • REST
  • SOAP

Data can be manipulated by CRUD operations on authorities, containers, and entities. Queries can be executed based on a text base query language, whose syntax follows the LINQ pattern for C#.

Regarding the predominance of Amazon S3 on the web storage market Robert Scoble said:

It’s almost too late for the others to get into the game [of data storage on the web]. It’s amazing (or maybe it should be “amazoning”) to me that Ray Ozzie over at Microsoft has let Amazon have so much runway.

According to Jamie Thomson nothing's carved in stone, yet:

Can [Microsoft] stop Amazon? Who knows, it might slow them down a bit (when SSDS finally gets released - it hasn't even reached beta yet) but Amazon are already miles and miles ahead with this. Having said that, its difficult to know how far Amazon have got into the enterprise data storage market and that will be Microsoft's key battleground.

Further information can be found on the product web site and the SSDS whitepaper.

Rate this Article


Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Community comments

  • WS computer cloud and S3 surpassed the usage of all of's global

    by Jean-Jacques Dubray,

    Your message is awaiting moderation. Thank you for participating in the discussion.


    an interesting piece of information came out yesterday on the Seattle Times. Brier Dudley reported that:

    Bandwidth usage by the AWS computer cloud and S3 storage services during the fourth quarter of 2007 surpassed the usage of all of's global Web sites. That's during the holiday shopping season.

    If anyone doubt that this is real, this is yet another piece of evidence.

  • Good to have some competition

    by Ted Slusser,

    Your message is awaiting moderation. Thank you for participating in the discussion.

    I see this more as a competitor to SimpleDB than S3, but nevertheless, I think this is a great thing for the market. Amazon, please pay attention.

    I really like these features of SSDS that SimpleDB is lacking

    - Support for simple types: string, numeric, datetime, boolean
    - Query language supports the retrieval of complete entities
    - Use the same service interfaces for your storage needs at any scale (SimpleDB vs S3)

    AWS outage notwithstanding the future is very "cloudy"

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p