With the recent public CTP of Azure, there has been a lot of confusion (both internally and externally) about what each service is supposed to do. Here’s my summary of some internal conversations along that line:
The other key question that I see constantly is “What is the difference between SDS and Azure Storage? They both store blobs…”.
The truthful answer to that is there is not much functional difference between them right now. The key is to look down the road. SDS’ stated goal is to add more and more database-type functionality. This means that you will start seeing SQL Server-type functionality added over time. In theory, you will eventually be able to just use SDS for your database instead of an instance of SQL Server. Obviously, that is waaaaaaay down the road, but you have to start somewhere!