Rob Tiffany

Tag Archive: SQL Server Compact

Sync

Sync Framework v4 is now Open Source, and ready to Connect any Device to SQL Server and SQL Azure

Microsoft has brought the power to synchronize data with either SQL Server on-premise or SQL Azure in the cloud to the world of mobility. The profound effects of the Consumerization of IT (CoIT) is blurring the lines between consumers and…
Read more

pp-Psion-Teklogix-12-6-10

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.

Windows Phone 8 Tiles

What the new App Hub in Windows Phone Mango means for the Enterprise

If you attended MIX 11 or watched it on Channel 9, you might have seen Todd Brix’s session titled “Making Money with your Applications on Windows Phone.” In this session, Todd talked about all the great things Windows Phone users…
Read more

SQL Server

SQL Server Compact 4.0 Lands on the Web

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.

Primary Key

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

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.