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. Continue reading
All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform. Continue reading
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. Continue reading
About a month ago, I wrote an article intended to help you fill some of the gaps left by the missing SQL Server Compact database. Since your Windows Phone 7 Silverlight app is consuming an ObservableCollection of objects streaming down … Continue reading
By now, you’ve heard me talk a lot about the role wireless data networks play when it comes to the success of your mobile application. They are unreliable, intermittent, highly latent and often slower than they should be due to … Continue reading
In my last article of this series, you finally got to consume wireless-friendly WCF REST + JSON Services from both Windows Server and Windows Azure with data coming from SQL Server/SQL Azure. You now have an ObservableCollection of Customer objects … Continue reading
Do you have a burning question related to Windows Phone? Are you unsure, confused or need more information? Do you have feedback you want to share? Whatever your motivation, this session is not to be missed. For one time only … Continue reading
A Mobile Enterprise Application Platform (MEAP) allows corporate IT departments to support multiple mobile applications on a single platform. Gartner states that this market currently tops $1 billion, and forecasts that 95% of the world’s organizations will standardize on a … Continue reading
The Silverlight development environment has proven itself to be a rich, capable and adaptable runtime that has reached across platforms to support Windows, the Mac, the Web, Nokia and Windows Phone 7. Azure is Microsoft’s powerful cloud offering that brings compute, … Continue reading
Run, don’t walk, and download the new SyncFx bits to sync your connected devices with SQL Server and SQL Azure! Below is a quick rundown of all the features from the Microsoft Download Center page: Microsoft Sync Framework 4.0 October … Continue reading
In my last two articles, I showed you how to build WCF REST services using Visual Studio 2010 that can reside on-premise in Windows Server 2008 or in the Cloud in Windows Azure. Furthermore, I demonstrated pulling data from a … Continue reading
Written by: J. Gerry Purdy 10/20/2010 You have to hand it to Microsoft. They have certainly fulfilled the old saying, “If at first you don’t succeed, try, try again.” Microsoft has had a number of previous attempts to build a … Continue reading