Building Microsoft MEAP: Scaling Out SQL Server 2012

Super Scale

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 Application Integration Tools (EAI) critical capability for building a Mobile Enterprise Application Platform (MEAP) using Microsoft … Read more Building Microsoft MEAP: Scaling Out SQL Server 2012

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

SQL Server Compact

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, … Read more 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 II

SQL Server Compact

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 … Read more 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 I

SQL Server Compact

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 … Read more Simple Mobile Sync with SQL Server 2012 and SQL Server Compact: Episode I