Rob Tiffany

Tag Archive: Database

NoSQL on Windows

In this week’s episode of “Inside Windows Phone,” Matthijs Hoekstra and I discuss the use of NoSQL. When building mobile apps for the enterprise, an offline data store is absolutely essential so that users can keep working in the absence…
Read more

SQLite

SQLite for Windows and Windows Phone: Data Definition

SQLite WinRT allows Windows and Windows Phone developers to create and manipulate database objects through the SQLite Data Definition Language (DDL). SQLite supports DDL statements including CREATE, ALTER, and DROP to work with objects like Tables, Indexes, Triggers, and Views.  This is…
Read more

SQLite

SQLite for Windows and Windows Phone: Installation

SQLite WinRT empowers Windows and Windows Phone developers to build mobile enterprise apps using Windows Runtime (WinRT) APIs to work with the world’s most popular mobile database. SQLite advantages include cross-platform (OS + Processor) support, speed, ACID reliability, and support…
Read more

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

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

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

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

SQLite

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