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
Hey folks, just wanted to let you know that cumulative update package 7 for SQL Server Compact 3.5 Service Pack 2 has been released to the web. You can download the new bits over at http://support.microsoft.com/kb/2665342. This is a hotfix for an
Wow! Just opened a 1099 tax document for 2011 from Apress. People must still be buying my old books on eMbedded Visual Basic, the .NET Compact Framework 2.0, and SQL Server Compact 2.0. The Pocket PC and Windows Mobile live
It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.
Today’s tip is an easy one. 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
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
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.
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.
All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.
The act of tracking changes made by each SQL Server Compact or Silverlight sync subscriber can cause a lot of locking and blocking on the server.