The Future of SQL Data Services with Nigel Ellis
- Posted: Apr 27, 2009 at 12:49 PM
- 25,708 Views
- 10 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…”
- High Quality WMV (PC, Xbox, MCE)
- MP3 (Audio only)
- MP4 (iPod, Zune HD)
- Mid Quality WMV (Lo-band, Mobile)
- WMV (WMV Video)
I had the pleasure of sitting down with one of SQL Server’s brightest, Nigel Ellis, to discuss the future direction of SQL Data Services. Nigel goes deep on the changes of SDS. If you want to learn what’s really going on behind the scenes this is a great
place to start.
Check out
Nigel's MIX session here.
Follow the SQL Data Services team blog here.
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
Is there any type of concurrency manager in the cloud ?
Nigel.
I agree there are cases where large databases are required. Your example of Exchange backup (or other backup scenario) is a case for large blob data. This is something supported using Azure blob storage - we will also be investigating supporting the SQL Server RBS interface which would allow seamless storage of large blobs alongside your structured data. 10GB of structured data is a great deal of information and covers our initial target application segments which shows most applications have databases in the order of < 3GB in size.
Remember any limits are just a starting point not an end.
Thanks,
Nigel.
I also would vote for easy tenant virtualization in terms of applications. So I make a cloud app, but I need to support X different customers. I need each tenant/customer "virtualized" (and seperate) without having to update my tables and queries to support tenant IDs. All my queries "route" to proper virtual db based on login id. This would abstract uneeded complexity I think.
For all of the mortals out there (like myself) here is a link to some information about SQL Server 2008 Concurrency which essentials deals with how the SQL Server handles locking.
http://msdn.microsoft.com/en-us/library/ms189132.aspx
Buzza, is there a particular situation unique to the Cloud that you are concerned about related to Concurrency?
10GB of "pure" data may sound like a reasonable starting point, but if the data are moderately indexed, the space would run out much-much faster.
Are you planning to charge for the total consumed space (data and indexes), or table pages only?
Are you planning to offer space compression by any chance?
Seva.
> Are you planning to charge for the total consumed space (data and indexes), or table pages only?
The exact billing model is still under discussion. The size caps would apply to the physical database size so it would include all indexes defined.
> Are you planning to offer space compression by any chance?
This is not currently in scope for our initial release.
Nigel.
FILESTREAM (see http://technet.microsoft.com/en-us/library/bb933993.aspx) will not be supported in SDS v1. There are some unique challenges with supporting this in our SDS cluster environment. We are however considering building a SQL RBS provider (see http://msdn.microsoft.com/en-us/library/cc905212.aspx) that would allow you to store blob data within Windows Azure and manage link level consistency from within SQL Data Services.
Nigel.
Remove this comment
Remove this thread
close