How To Get a List of Your SSDS Account’s Authorities

It might seem obvious, but it wasn’t to either me or SSDS guru Mike Amundsen. The syntax to query for a list of SQL Server Data Services (SSDS) authorities for your account is the default address

https://data.beta.mssds.com/v1/

followed by the default Query

from e in entities select e

which translates to

GET https://data.beta.mssds.com/v1/?q='from e in entities select e'
HTTP/1.1

Here’s SSDS showing the request (Address and lower text boxes) and the response (upper text box) for the current OakLeaf authority oakleaf1:

(Microsoft limits SSDS beta testers to a single authority.) See comment by the SSDS team’s Stan Kitsis of 9/17/2008.

The inability to obtain a list authorities with

https://data.beta.mssds.com/v1/?q=

is due to a bug, according to a post by Stan Kitsis in the same thread.

Here’s a list of the containers uploaded to the oakleaf1 authority by the latest version of my updated SSDS Test Harness:

You can obtain a list of containers with a pseudo-LINQ query (above) or by executing

https://oakleaf1.data.beta.mssds.com/v1/?q=

(Click either image for the full-size capture.)

Note: Help for SSDS Explorer is at http://msdn.microsoft.com/en-us/library/cc752965.aspx.

Technorati tags: SQL Server Data Services, SSDS, SSDS Provisioning