Rob Tiffany

Tag Archive: Merge Replication

Building Microsoft MEAP: Scaling Out SQL Server 2012

Super Scale

In this third article on building Microsoft MEAP, I’ll show you how to Shard your SQL Server 2012 database using Replication to create a Shared Nothing data architecture to support Internet-scale mobile solutions. In the previous article, I discussed Gartner’s Enterprise…
Read more

Performance and Memory Management Improvements with Windows Embedded Handheld


It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.

SQL Server Compact 4.0 Lands on the Web

SQL Server

With the new version 4.0, the little-database-that-could has grown up into a powerful server database ready to take on the web.

Reducing SQL Server Sync I/O Contention :: Tip 3

Primary Key

Uniqueness is a key factor when synchronizing data between SQL Server/Azure and multiple endpoints like Slates and Smartphones. With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical. As you know, each row is uniquely identified by its Primary Key.