THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby updated, gives clues about future SQL Azure enhancements

The OData website at has been updated today to provide a much more engaging page than the previous sterile attempt. Moreover its now chockful of information about the progress of OData including a blog, a list of products that produce OData feeds plus some live OData feeds that you can hit up today, a list of OData-compliant clients and an FAQ. Most interestingly SQL Azure is listed as a producer of OData feeds:

If you have a SQL Azure database account you can easily expose an OData feed through a simple configuration portal. You can select authenticated or anonymous access and expose different OData views according to permissions granted to the specified SQL Azure database user.

A preview of this upcoming SQL Azure service is available at and it enables you to select one of your existing SQL Azure databases and, with a few clicks, turn it into an OData feed. It looks as though SQL Azure will soon be added to the stable of products that natively support OData, good news indeed.


Related blog posts:

Published Tuesday, March 16, 2010 3:00 PM by jamiet
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Adam said:


I just went and checked out this website as I have never heard of it before and in principle it looks quite interesting. However, it looks like you need to be a hardcore .NET programmer to get anywhere with it. And, after reading through some of the sections on the website I don't really understand it's 'real world' purpose.

Can you help me out here...what do I need to know?


March 18, 2010 1:55 PM

SSIS Junkie said:

Those that have followed my blogs for a while may know that I have a slightly banal interest in Windows

March 18, 2010 5:24 PM

jamiet said:

Hi Adam,

The way I think of it is this. For the past 15 years or so we've had ODBC which helped different kinds of databases on the same network LAN talk to each other. ODBC was a standard that database providers could adhere to that enabled that "talking" to occur.

Today we have a new network across which databases need to talk to each other - the internet. And its not just databases as we know them either, people are now surfacing spreadsheets, non-relational data stores, report data, queries, metadata etc... as queryable "things". Even a web page can be considered to be queryable data these days.

OData provides the same job that ODBC did - its a standard that can enable all of these things to talk to each other across the network.

Jon Udell describes it better in his blog post "OData is grease to cut data friction" (


March 19, 2010 6:40 AM

amorts said:

Hi Jamie,

Thanks for the description and the link. I can certainly see the requirement of something like OData, although the actual hands on use appears somewhat mystical!



March 19, 2010 6:02 PM

GoAzure said:

There is now the capability to crete and use an OData Service for SQL Azure in Azure AppFabric

For more information:

April 27, 2010 2:12 PM

Leave a Comment


This Blog


Privacy Statement