“Introduction to Data Sync Service for SQL Azure” and other Google-Starred Items
Wayne Walter Berry: “Data Sync Service for SQL Azure doesn’t allow you to program the handling of conflict resolution as compared to the Microsoft Sync Framework. For this reason it is best if you are inserting row into multiple member databases that you use uniqueidentifier data type as primary keys to your tables, instead of the int IDENTITY data type. This will prevent identity conflicts during the bi-directional synchronization. If you are working with a legacy database or do not want to use the uniqueidentifier data type, there are several other methods of ensuring a unique primary key across all the databases. I will blog more about this later.”
“Demo: Using Entity Framework to Create and Query a SQL Azure Database In Less Than 10 Minutes”
Steve Yi: “As we’ve shared in earlier posts this week, one of the beautiful things about EF is the Model First feature which lets developers visually create an entity model within Visual Studio. The designer then creates the T-SQL to generate the database schema. In fact, EF give developers the opportunity to create and query SQL Azure databases all within the Visual Studio environment and not have to write a line of T-SQL.”
“10 things you Need to Know About NoSQL Databases”
Herman Mehling: “MongoDB and Redis are good choices for storing frequently-written, rarely read statistical data, such as a web hit counter. …Hadoop, a freeform, distributed DB does a good job of storing Big Data such as weather stats or business analytics work. …Memcache, a transient DB, excels at storing web sessions, locks, and short-term stats) . …Cassandra and Riak (automatically clustered, redundant stores) perform well in environments with high availability apps, when maximum uptime is vital.”
“Porting the MVC Music Store to SQL Azure”
Steve Yi: “The default membership and roles providers that are used in MVC Music Store aren’t completely available in the Windows Azure Platform. For simplicity of the blog post, we are going remove this functionality from the MVC Music Store. However if you are interested in keep it you can use implementations that are in included in the SDK samples that use Cloud Storage. See this post for more information on how to set those up.”