Tag: Sync

TechEd North America 2014: Empower your Demanding Mobile Line of Business Apps with SQLite and Offline Data Sync on Windows 8.1

TechEd North America 2014: Empower your Demanding Mobile Line of Business Apps with SQLite and Offline Data Sync on Windows 8.1

| May 20, 2014 | 1 Comment

Presenting at TechEd 2014 in Houston, watch my session: “Empower your Demanding Mobile Line of Business Apps with SQLite and Offline Data Sync on Windows 8.1.” Most mobile apps require the ability to store data locally to deal with the realities of a disconnected world where ubiquitous wireless networks are non-existent.  While many consumer apps […]

Continue Reading

Keeping Windows 8 Tablets in Sync with SQL Server 2012

Keeping Windows 8 Tablets in Sync with SQL Server 2012

| June 2, 2013 | 5 Comments

I’m pleased to announce that my newest book, “Keeping Windows 8 Tablets in Sync with SQL Server 2012,” is now available for sale on Amazon. Spending a decade travelling the globe to help the world’s largest companies design and build mobile solutions had taught me a few things.  Large organizations are not interested in constantly running on […]

Continue Reading

Keeping Windows Tablets in Sync with SQL Server

Keeping Windows Tablets in Sync with SQL Server

| March 19, 2013 | 11 Comments

So you need to build a mobile enterprise app that runs on Windows tablets… Your app must retrieve data from SQL Server and take it offline.  It must allow the mobile user to view, manipulate, capture new information, and then send it back to the data center.  There’s lots of data involved, so you require […]

Continue Reading

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 III

| April 21, 2012 | 4 Comments

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 data with the new SQL Server 2012 (Denali) database. Just imagine, you now have mobile sync components that give you the flexibility to to work with SQL Server 7, 2000, […]

Continue Reading

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 II

| April 9, 2012 | 6 Comments

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 Sync Server Tools.  With that series of tasks completed, you’re now capable of performing data synchronization with a mobile Windows client. Open SQL Server 2012 Management Studio and connect to the local SQL […]

Continue Reading

Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode I

Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode I

| March 27, 2012 | 1 Comment

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 of Cumulative Update Package 6 for SQL Server Compact 3.5 Service Pack 2, the answer is a resounding yes! Build number 3.5.8088.00 adds support for replication with SQL Server “Denali” which is […]

Continue Reading

Books and Taxes

Books and Taxes

| February 4, 2012 | 0 Comments

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 on! A separate 1099 for Hood Canal Press tells me that my SQL Server Merge […]

Continue Reading

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

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

| September 11, 2011 | 16 Comments

The profound effects of the Consumerization of IT (CoIT) is blurring the lines between consumers and the enterprise.  The fact that virtually every type of mobile device is now a candidate to make employees productive means that cross-platform, enabling technologies are a must.  Luckily, Microsoft has brought the power to synchronize data with either SQL Server […]

Continue Reading

Performance and Memory Management Improvements with Windows Embedded Handheld

Performance and Memory Management Improvements with Windows Embedded Handheld

| September 4, 2011 | 0 Comments

It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.

Continue Reading

Consumerization of IT Collides with MEAP: Windows > Cloud

Consumerization of IT Collides with MEAP: Windows > Cloud

| August 9, 2011 | 1 Comment

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 you’re talking about a Windows 7 tablet or laptop, I showed that you can follow the Garter MEAP Critical Capabilities to integrate with our stack in a consistent manner.  Remember, […]

Continue Reading

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

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

| March 9, 2011 | 0 Comments

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 a given period of time. If more things can happen in a given period of […]

Continue Reading

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

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

| February 27, 2011 | 0 Comments

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 technologies figure out “what’s-changed” on the fly when a Subscriber synchronizes.  This means all change-tracking […]

Continue Reading