Pictures in the Cloud – SSDS demo app

I’ve been playing around with SQL Server Data Services, Microsoft’s new concept for the ‘datacenter in the cloud’.

Anyhow, I’ve been having a bit of hack around to show how pictures can be stored by this kind of service. There isn’t any reason to use this over the other online photo sharing sites, but it demonstrates how to use the API.

As far as I can tell, there are no ‘best practices’ about how to use SSDS (probably because no one is publicly using it for the enterprise yet). Hopefully writing this application will show me the best way to achieve this.

There isn’t a ‘release’ yet, but if you download the source, build it (VS 2008) get a username and password and edit the app.config then it should work straight away.

6 thoughts on “Pictures in the Cloud – SSDS demo app

  1. Have you considered using blobs now that they are available in SSDS? Granted, they are only presently (now) in the REST head but they would make your application considerably easier to develop (IMO).

  2. Absolutely. I wanted the first iteration to be SOAP only, and then have some pluggable REST functionality to compare it to.

    I’m also interested in the performance improvement from using BLOB’s…

  3. Performance may not be misleading on smaller blobs. However, on larger blobs it will be better as we end up spreading the blob over the entire cluster. This gives you better throughput as you are restricted by the I/O on any one node in the cluster (as you would be with the current approach you have).

    What’s more, once we complete partial read/write support (via the Range header) you would be able to use multi-threading to really get better throughput.

    Hope it helps,


  4. That first sentence should say, “Performance may be misleading on smaller blobs”… Hit the, “Say it button a bit too quick”. 🙂

  5. Thanks Jeff!

    My app actually uses two threads when it uploads an image (one for the image and the other for its thumbnail + details) in order to shorten time.

    It would be great to optimize that further with partial reads/writes. I didn’t know that was coming so thanks 🙂

    I’ll follow up with a post on using REST soon

  6. They are coming soon. We had other PDC features that had to make it before we could get to the partial reads or writes 😦 Hang in there though it’s coming soon.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s