Mobile Apps Must Work Offline Because Wireless Connectivity isn’t Ubiquitous
Intermittent wireless connectivity requires #mobile apps to follow sync patterns using pre-fetched data via APIs and offline local storage.
Sync
Looking to the Future of Cross-Platform Mobile Data Sync with SQL Server
If you’ve used Merge Replication to sync SQL Server Compact data on mobile devices with #SQL Server in the past and you’re looking for a cross-platform solution to take you into the future, take a look at Zumero.
Empower your Demanding Mobile Line of Business Apps with SQLite and Offline Data Sync on Windows
Presenting at TechEd in Houston, watch my session: “Empower your Demanding #Mobile Line of Business Apps with SQLite and Offline Data Sync on Window.”
Keeping Windows 8 Tablets in Sync with SQL Server 2012
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… Read More »Keeping Windows 8 Tablets in Sync with SQL Server 2012
Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode III
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… Read More »Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode III
Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode II
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… Read More »Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode II
Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode I
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… Read More »Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode I
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.
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.
Consumerization of IT Collides with MEAP: Windows > Cloud
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… Read More »Consumerization of IT Collides with MEAP: Windows > Cloud
Reducing SQL Server Sync I/O Contention :: Tip 5
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… Read More »Reducing SQL Server Sync I/O Contention :: Tip 5
Reducing SQL Server Sync I/O Contention :: Tip 4
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… Read More »Reducing SQL Server Sync I/O Contention :: Tip 4
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.
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.
Reducing SQL Server I/O Contention during Sync :: Tip 2
All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.