Facebook App ID is missing!
Windows 8 Book Front

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 travelling the globe to help the world’s largest companies design and build mobile solutions had taught

Super Scale

Building Microsoft MEAP: Scaling Out SQL Server 2012

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

Happy Tech 2013

Here’s to having all your tech dreams come true in 2013! May you seamlessly integrate with backend systems and data sources in a simple and consistent manner. May replication enable your databases to scale horizontally in a shared-nothing fashion to

Building Microsoft MEAP: Adapters

In this second article on building Microsoft MEAP, I’ll focus on implementing Gartner’s Enterprise Application Integration Tools critical capability using SQL Server Integration Services (SSIS) to connect to back end systems. As I mentioned in the Introduction article, one of the top priorities

VB Grid

Human Table Scan

HTS (Human Table Scan) Definition:  When an employee has to manually search an entire list or grid of data because the mobile app doesn’t provide any filtering or search capabilities. You’re probably thinking the advent of the ‘magnifying glass’ icon put an end to


Getting Started with SQLite on Windows 8 > Installation

Over the summer of 2012, Microsoft announced support for SQLite on both Windows 8 and Windows Phone 8. This is exciting news because it allows developers to build enterprise and consumer apps that utilize the world’s most widely used embedded

Human Extract, Transform, and Load

HETL (Human Extract, Transform, and Load) Definition:  When an employee in the field captures data with a pen or pencil & paper, drives back to the office at the end of the workday, and manually transcribes the data into a back-end computer


A Quick Note on Speedy, Scalable, Available Architectures

Just a few thoughts on concepts needed to give mobile users of your SOA infrastructure the best, fastest User eXperience possible: If you care about speed & scalability, your web service will always check the distributed cache before querying the

Primary Key

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