I’m pleased to announce that my newest book, “Keeping Windows 8 Tablets in Sync with SQL Server 2012,” is now available for sale. Spending a decade travelling the globe to help the world’s largest companies design and build mobile solutions had taught me a few things. Large organizations are not interested in constantly running on the new … Read more
Back in my first article, I showed you where to find Microsoft’s latest updates to the SQLCE and RDA technologies so you can begin synchronizing data with the new SQL Server 2012 (Denali) database. Just imagine, you now have mobile sync components that give you the flexibility to to work with SQL Server 7, 2000, … Read more
In my last article, I walked you through finding, downloading, installing, and configuring SQL Server 2012 Express, SQL Server Compact 3.5 SP2 CU6, and the Sync Server Tools. With that series of tasks completed, you’re now capable of performing data synchronization with a mobile Windows client. Open SQL Server 2012 Management Studio and connect to the local SQL … Read more
Now that SQL Server 2012 has been released, some of you might be wondering if SQL Server Compact is capable of synchronizing with it. With the release of Cumulative Update Package 6 for SQL Server Compact 3.5 Service Pack 2, the answer is a resounding yes! Build number 3.5.8088.00 adds support for replication with SQL Server “Denali” which is … Read more
In my Consumerization of IT Collides with MEAP article last week, I described how to connect a Windows 7 device to Microsoft’s On-Premises servers. Whether you’re talking about a Windows 7 tablet or laptop, I showed that you can follow the Garter MEAP Critical Capabilities to integrate with our stack in a consistent manner. Remember, … Read more
When it comes to delivering server solutions with Windows Server and SQL Server, speed is your friend (as we used to say in the submarine service). More speed means more things can happen in a given period of time. If more things can happen in a given period of time, then you can derive greater … Read more
One of the features that makes SQL Server Merge Replication superior to other sync technologies is something called Precomputed Partitions. SQL Server creates and maintains distinct data partitions/subsets for each unique user or other type of filter value. Other sync technologies figure out “what’s-changed” on the fly when a Subscriber synchronizes. This means all change-tracking … Read more
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.