Cloud Cover Episode 10 - Table Storage API
- Posted: May 07, 2010 at 8:23 AM
- 47,972 Views
- 2 Comments
Download
How do I download the videos?
- To download, right click the file type you would like and pick “Save target as…” or “Save link as…”
Why should I download videos from Channel9?
- It's an easy way to save the videos you like locally.
- You can save the videos in order to watch them offline.
- If all you want is to hear the audio, you can download the MP3!
Which version should I choose?
- If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
- If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
- If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
- If you just want to hear the audio of the video, choose the MP3 file.
Right click “Save as…”
- WMV (WMV Video)
- MP3 (Audio only)
- MP4 (iPod, Zune HD)
- Mid Quality WMV (Lo-band, Mobile)
Join Ryan and Steve each week as they cover the Microsoft cloud. You can follow and interact with the show at
@cloudcovershow
In this episode:
In this episode:
- Learn about the Table storage model - PartitionKeys, RowKeys, and more.
- Walk around the API using the StorageClient library and learn how to query the service without first building a data model.
- Hear the latest news and announcements for the platform.
- Troubleshoot a common query error when using Table storage.
Show Links:
Windows Azure Guidance - Failure Recovery (via Eugenio)
SELECT INTO with SQL Azure
Application Infrastructure Virtual Learning
Windows Azure Firestarter videos
Protecting Blobs from Application Errors
Protecting Tables from Application Errors
Table Storage Backup and Restore on CodePlex
Comments Closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation,
please create a new thread in our Forums,
or
Contact Us and let us know.
Follow the Discussion
The biggest issue I have with Azure Table Storage is the lack of string comparison operators.
If I can do
.Where(a=>a.Age > 21)
and
.Where(a=>a.Name.CompareTo("Dave"))
then why can't I do
.Where(a=>a.Name.ToLower().Contains("dave"))
Is this an architectural constraint or rather an implementation limitation?
If it's an implementation limitation, then I can hope that it will be fixed in a future release.
If it's architectural, then I will have to find an alternative solution such as SQL Azure.
Hi DaveSn,
Currently, this is a limitation in the actual storage service. The LINQ provider eventually boils down to a URI with some syntax that is or isn't supported on the service head. It turns out that certain operations that are supported in relational sources are not supported in Windows Azure tables. Your specific question would entail a full-text search to be performed on an arbitrary column in Windows Azure. This is not currently supported (there is no LIKE operation). This limit might be removed over time as more features are added to the service.
If you really need full text search capability over your data - take a look at the Lucene implementation here:
http://code.msdn.microsoft.com/AzureDirectory
Remove this comment
Remove this thread
close