Who remembers using Remote Data Access to synchronize data between SQL Server and SQL Server Compact? I certainly do! Before I dove head first into the world of Merge Replication, I always used RDA to get my customers up and running quickly. Mobilizing an organization’s workforce quickly and easily...

Just wanted to let everyone know that version 1.1 of the Mobile Architecture Pocket Guide is now available on CodePlex at http://www.codeplex.com/AppArch/Release/ProjectReleases.aspx?ReleaseId=19798 . This is the first patterns & practices update to this guide since 2002 so it's a welcome sight to...

Looking forward to seeing lots of familiar faces and meeting new ones starting December 10th at Tech Ed EMEA! While I ran the Windows Mobile track for Tech Ed North America last June in Orlando, this time around I'll just be delivering a couple of presentations and spending most of my time helping empower...

Mobile Data Synchronization with Microsoft SQL Server 2005 and SQL Server Compact > Second Edition Achieving Global Scalability via Merge Replication Republishing Download and review the PDF from my Windows Live SkyDrive @ http://cid-8b9c82da88af61fc.skydrive.live.com/self.aspx/Sync/Ch%201...

I was recently interviewed by Carl Franklin and Richard Campbell who run one of the Internet's most popular developer sites, .NET Rocks! You can catch the interview at http://www.dotnetrocks.com/default.aspx?showNum=384 where you can either listen to it live via the website, or download it to your favorite...

As you know from my recent posts, I've been hanging out at 1,200 concurrent Subscribers trying to boost performance. When I first hit the 1,200 Subscriber mark, I was able to change and replicate ~13 million rows per hour. I was happy with the scalability, but the performance was no better than what...

"Windows Mobile Data Synchronization with SQL Server 2005 and SQL Server Compact 3.1" is now available in print! Those of you in the continental U.S. can just buy it directly from the Hood Canal Press site at http://www.hoodcanalpress.com/catalog.htm and get free ground shipping. It's on Amazon in the...

Yet again, I've doubled the number of concurrent Subscribers to 1,200 where each Subscriber is equivalant to a Windows Mobile device. I used 6 servers running 200 Subscribers each to create client load, plus 3 load-balanced IIS servers, and a separate SQL Server Distributor and Publisher. Each IIS server...

The Windows Mobile Partner Summit is going great and the event looks to be twice as big as last year. It's always nice to reconnect with our partner community. Steve Hegenderfer was kind enough to allow me to bring my rack of servers to his event. This time, I have a much lighter, 24U half rack which...

I just finished up a week of teaching attendees at the Dev Connections conference how to setup and use mobile merge replication to sync data between their Windows Mobile devices and SQL Server 2005. As usual, I brought along my favorite teaching tool, my portable data center, to take attendees on deep...

The non-linear fashion by which I've been writing this book reminds me of the way Pulp Fiction jumps around. Chapter 1 is ready to go so you can get started with Merge Replication for Windows Mobile devices. In addition to obvious technology walkthroughs, I also decided to add a bunch of scenarios that...

The biggest and most comprehensive chapter of the new book is ready to preview! Chapter 3 is ready to go for some relaxing Labor Day weekend reading. It's the deepest coverage that I've seen on all the nuances of the SQL Server Publisher for mobile replication if I may say so myself. The book is called...

Not to be outdone by a refresh to chapter 4, I've made some updates and additions to chapter 2 for you to look at as well. Don't worry, chapter 3 is almost ready... The book is called "Windows Mobile Data Synchronization with SQL Server 2005 and SQL Server Compact 3.1" and it's being published by...

I've made some updates and additions to chapter 4 for you to look at. The book is called "Windows Mobile Data Synchronization with SQL Server 2005 and SQL Server Compact 3.1" and it's being published by Hood Canal Press . Click on Chapter4.pdf below to download Chapter 4 on installing and configuring...

Here comes another chapter! My forthcoming book is called "Windows Mobile Data Synchronization with SQL Server 2005 and SQL Server Compact 3.1" and it's being published by Hood Canal Press . Click on Chapter2.pdf below to download Chapter 2 on installing and configuring the SQL Server Distributor...

Best Windows Mobile Development Book Ever Written! Trust me, I've read them all going back to 2001 and I've written two of them myself. This is as broad and deep as it gets when it comes to managed code development on Windows Mobile. This should come as no surprise as it was written by the Windows...

As I mentioned in a previous post, my latest book is underway. For those of you who visited my booth at MEDC 2007 in Las Vegas or Tech Ed 2007 in Orlando and wondered how I built my 4-tier merge replication architecture, your questions are about to be answered as I promised. The good news is I won't...

As some of you know, I've been building and piecing together the documentation necessary to build out a scalable merge replication architecture for your Windows Mobile devices. If you've been to MEDC 2007 in Las Vegas or Tech Ed 2007 in Orlando, you may have stopped at my booth where I demonstrated a...

The Magic is Back! The performance of our 800 concurrent subscribers rocked! Less proved to be definitely better than More when it comes to thread pools on IIS. Before launching the 800 subscriber test run, I throttled back the number of threads that are available in the 3 pools that do work on IIS...

In the beginning, Windows Mobile could sync a Pocket Access database with Access on the desktop over ActiveSync. Today, the Swiss Army Knife of Integration that is Windows Mobile 6 can communicate with almost anything. Windows Mobile 6 can communicate directly with any enterprise package or hosted service...

At MEDC 2007, we introduced an IT Pro/Infrastructure booth called "Enterprise Mobility in Action." This booth was designed to show off the performance and scalability of Merge Replication between SQL Server 2005 SP2 and SQL Server Compact Edition 3.1. The ability to deploy applications that are occasionally...

If you're looking for resources to give you a head start in building a Windows Mobile line of business application to deploy in your enterprise, look no further than http://www.microsoft.com/downloads/details.aspx?FamilyID=80a5c2c5-4f9b-4c1a-bff6-2a3c6b68d15b&displaylang=en . Covering the use of...