Rob Tiffany

Tag Archive: SQL Server

Windows NoSQL

Wrap a Web API around Your Enterprise & Take Microsoft SQL Server 2014 Data Offline w/ NoSQL via Universal Apps for Windows

At TechEd New Zealand, I presented a session on how to integrate a company’s backend systems into SQL Server 2014 and deliver that data out to mobile devices via Web APIs to support the operations of occasionally-connected apps on mobile devices using NoSQL tables.…
Read more

Windows Phone SQLite

Supercharge your Mobile Line of Business Solutions with SQLite and Offline Data Sync via Universal Apps for Windows

At TechEd New Zealand, I presented a session on Microsoft’s next generation data sync technology from Azure Mobile Services that uses SQLite to support the operations of occasionally-connected apps on mobile devices. Most mobile apps require the ability to store data locally…
Read more

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

CRMDataFlowTaskRunning

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