2/27/09

SQL Data Services (SDS) Tutorial (Part2)

This blog entry is the second part of the SQL Data Services (SDS) Tutorial.

This article is based on CTP release of SQL Data Services.

Let's get us started. You begin by opening "SDS Exlorer" from Windows Start menu.

First of all, delete the text in Query text area so that you can disregard Query stuff for now. (I will discuss Query in future)

Next, set the address to
https://[your_authority].data.database.windows.net/v1/
where [your_authority] is the actual authority id yours (read Part 1 of this Tutoria if you don't have one). In this example, I use my test authority called "yoshi".



Then, click "Get" button.


You receive information about your Authority (if you get alot more information that what I got above, don't worry. Its called "metirics metadata" and we will cover this later)

Now, without changing the value in Address, click "Query" button.


This time, you receive an XML element called "EntitySet" with nothing in it. This measn that your Authority is empty. In order to make this Authority useful, we need to add a Container. Let's do that.

Without changing the Address, Click "Container" button. You will get a template in the main text area. SDS Explorer generated GUID value for you as Id of the new Container, which is about to be created. I changed this to "bookmarks" because that's the application I want to build.


When you are happy with the name of Container, click "Create" button.

As usual, it is not appearent if the requst succeeded or not, so open the "Request/Response" window and check HTTP "Response".


The status says "Created" so that's a good sign!

Now, let's talk about an important concept called "Scope" in SDS. If you look at the Address bar right now, you see:

https://yoshi.data.database.windows.net/v1/bookmarks

This is in the format of:

https:[your authority id].data.database.windows.net/v1/[your container id]
... and you are in "container scope".

Understanding "Scope" is important because all operations you perform using SDS Explorer works within the context of the current Scope. For example, if you make a simple HTTP GET request while Authority is the scope, you will get metadata information about the Authority; while Container is the scope, you will get metadata information about the Container.

Take a look at the output results of clicking "Get" and "Query" buttons while we are in bookmarks container scope.

Result of "Get":


Result of "Query":


You observe some metadata information about my "bookmarks" container, and my container is still empty because I haven't added anything. We will cover working with Container in future. For now, let's validate that our Authority indeed contains my newly created container.

Go back to Authority scope by either clicking on "Go up" button (looks like a folder icon) in Address bar or manually type in:

https://yoshi.data.database.windows.net/v1/

And then click "Query" button.


This time, we get EntitySet with one element called Container. This container is the "bookmarks" container that I just created.

You have successfully created a Container and now you can do a lot of things with it. I will talk about working with Container in future.

48 comments:

popka said...

анальное порно видео в клинике онлайн порно слаткие попки тонкий анал порно

acido ialuronico iniezioni said...

thanks for sharing

radiofrequenza said...

Lovely blog, thanks

Vitoliv liver detox pills said...

Wow looks to be really Interesting but sorry to tell you I am really not a big fan of database.

Herbal penis enlargement pills said...

I am really amazed to see that you have done a lot of work on this sector.

Natural stress relief pills said...

Although I am really not a big fan of database...its really a good post...

Orgasm enhancement pills said...

Wow looks to be really Interesting..nice post indeed....

Vimax penis enlargement pills said...

SQL is another language which I have a little knowledge and I can work out things pretty easily.

Premature ejaculation pills review said...

looks to be really Interesting but sorry to tell you I am really not a big fan of database.

Best acne treatment for sensitive skin said...

Thanks alot for this very helpful post. Both parts are well explained and I found them very informative. Hats off

Prosolution erectile dysfunction gel said...

I am really sorry to say that I am not interested about data base. But i found it interesting.

Hersolution female stimulant gel said...

SQL data is very effective for me,as I was searching that for so many days.Would you please tell me where I should find the part 1?

hcg buy said...

Wow looks to be really Interesting HCG Blue Drops, the Faster and Natural way to lose weight

NeosizeXL increase penis size pills said...

Thank you very much.Very useful indeed.It is very nice to see your another post.Keep up article like this.

Best penis enlargement supplement said...

The process of Data services is awesome one,Thanks for sharing the process with us.

NeosizeXL increase penis girth pills said...

This article is based on CTP release of SQL Data Services. really nice...

locksmith in brooklyn said...

Walk confidently, talk confidently, smile confidently, act confidently and soon you will be confident.

Weak erection pills said...

This way of Data Services is very much effective.Everyone can apply it for the further process.

Duramale delayed ejaculation pills said...

Function name should have a single action word. Basically a function should do one thing, or a unit of things that is coherent.

19PFL3505D said...

nice tutorial man!

Un26d4003 review said...

i like to work with SQL databases. useful post

Natural penis growth pills said...

Container is the scope, you will get metadata information about the Container.

Vimax penis enlargement pills said...

This is such a great tutorial. Thanks for sharing.

Duramale stop quick ejaculation supplement said...

Wow looks to be really Interesting but sorry to tell you I am really not a big fan of database.

Increase low semen volume supplement said...

Each shift register is rated to handle the current of the 8 LEDs that could possibly be on at one time.

Infrared grills review said...

Yoshi you are the MAN! Your information today helped me a lot and i think i am going to be promoted thanks to you.

All Top models 2012 said...

I really love your SQL Data Services (SDS) Tutorials and hope that your future articles will be as informative as this one.

Anonymous said...

That is a good tip particularly to those new to the blogosphere.
Short but very accurate information… Thank you for sharing
this one. A must read post!

my homepage volume pills scam

Anonymous said...

What's up, after reading this awesome post i am also cheerful to share my experience here with colleagues.

Feel free to surf to my web-site: Proenhance Reviews

Anonymous said...

I think this is one of the most significant info for me.
And i am glad reading your article. But wanna remark on few general things, The
website style is great, the articles is really excellent : D.
Good job, cheers

Also visit my web site :: experience desire

Anonymous said...

Hi, i feel that i noticed you visited my blog thus i got here to return the favor?
.I am trying to to find things to improve my web site!
I assume its good enough to make use of some of your ideas!
!

Feel free to visit my webpage - diet pills phentermine

Anonymous said...

May I just say what a comfort to uncover an individual
who genuinely understands what they are
discussing on the internet. You certainly understand
how to bring a problem to light and make it important.
A lot more people need to look at this and understand this side of
your story. It's surprising you're not more popular given that you certainly
have the gift.

my homepage ... male enhancement pills

Anonymous said...

At this time I am going away to do my breakfast, once having my breakfast coming over again to read more news.



Also visit my web site ... genf20 plus review

Anonymous said...

I absolutely love your site.. Very nice colors & theme.
Did you develop this amazing site yourself? Please reply back as I'm attempting to create my own site and would love to learn where you got this from or exactly what the theme is named. Many thanks!

Also visit my site thelittlelovebirds.blogspot.com

Anonymous said...

Hi friends, how is everything, and what you want to say regarding this piece
of writing, in my view its truly awesome in support of
me.

my page: Thyromine

Anonymous said...

I know this іf off topic but I'm looking into starting my own blog and was wondering what all is needed to get set up? I'm
аssuming having a blog lіκе yοurs
would cоst a prеtty pеnny? I'm not very internet savvy so I'm not 100% posіtіve.
Any ѕuggestions or advice wоuld be greatly aρpreciated.
Thank you

My ωеbpage ... buy raspberry ketone

Anonymous said...

Awesome issues here. I'm very glad to peer your post. Thank you so much and I'm having
a look ahead to contact you. Will you kindly drop me a mail?


Check out my page - breast actives results how long

Anonymous said...

When I initially commented I seem to have clicked the -Notify me
when new comments are added- checkbox and now whenever a comment is added I recieve four
emails with the exact same comment. Is there a means you can remove
me from that service? Cheers!

My page ... buy provillus

Anonymous said...

When some one searches for his necessary thing, thus he/she
desires to be available that in detail, thus that thing is maintained over
here.

My web page :: buy virility ex

Anonymous said...

I comment each time I like a post on a site or I have something to contribute to
the conversation. Usually it's a result of the passion communicated in the article I looked at. And after this post "SQL Data Services (SDS) Tutorial (Part2)". I was actually moved enough to post a thought :-) I do have some questions for you if you usually do not mind. Is it only me or do some of these responses appear like they are left by brain dead visitors? :-P And, if you are writing at other online social sites, I'd like to keep up with anything fresh you have to
post. Could you list all of all your public pages like your linkedin profile, Facebook page or
twitter feed?

Review my blog :: smoke deter cost

Anonymous said...

Hello, Neat post. There is a problem together with your web site in internet explorer,
might test this? IE nonetheless is the market chief and a
large component to other folks will miss your fantastic writing because of this problem.


My web blog: buy provacylprovacyl review

Anonymous said...

Spot on with this write-up, I really think this website needs
a lot more attention. I'll probably be returning to read more, thanks for the info!

My blog profollica review

Anonymous said...

Right here is the right website for anyone who
would like to find out about this topic. You realize a whole lot
its almost hard to argue with you (not that I actually
would want to…HaHa). You certainly put a new spin on a
subject which has been written about for a long time.
Great stuff, just great!

Here is my web blog - tinnitus control

Anonymous said...

Pretty! This has been an incredibly wonderful article. Many thanks for providing this information.


Also visit my website :: where to buy capsiplex

Anonymous said...

Ιt is approрriаte time to make а few plans for the futurе and іt's time to be happy. I have read this post and if I could I wish to counsel you some attention-grabbing issues or tips. Perhaps you could write next articles referring to this article. I want to learn more issues approximately it!

Also visit my blog post; km3 african american baby shower

Anonymous said...

I like whаt уou guys аre up toо. This tуpe of cleveг
work and еxposure! Keep up the amаzіng works guys I've you guys to blogroll.

Feel free to visit my website ... Human growth hormones

Anonymous said...

I'm amazed, I have to admit. Seldom do I encounter a blog that's both educative and engaging,
and without a doubt, you have hit the nail on the
head. The issue is an issue that not enough people are speaking intelligently about.
Now i'm very happy that I came across this in my hunt for something concerning this.

my web blog; virility ex (weebly.com)

Anonymous said...

I read this paragraph fully on the topic of the resemblance of latest and
earlier technologies, it's remarkable article.

My web page: male enhancement supplements