Tag: Database

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

NoSQL

NoSQL

| January 16, 2014 | 1 Comment

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 of wireless connectivity.  In addition to SQLite and SQLCE, NoSQL is a great option to […]

Continue Reading

SQLite WinRT for Windows and Windows Phone: Data Definition

SQLite WinRT for Windows and Windows Phone: Data Definition

| August 1, 2013 | 3 Comments

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 complimented by simplified, dynamic data types including INTEGER, NULL, REAL, TEXT, and BLOB.  Admittedly, this takes some […]

Continue Reading

SQLite WinRT for Windows and Windows Phone: Installation

SQLite WinRT for Windows and Windows Phone: Installation

| July 31, 2013 | 2 Comments

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 for indexes, views, foreign keys, and triggers.  Developers of SQLite apps on iPhones, iPads and Android devices […]

Continue Reading

Keeping Windows 8 Tablets in Sync with SQL Server 2012 is available on the Kindle

Keeping Windows 8 Tablets in Sync with SQL Server 2012 is available on the Kindle

| June 10, 2013 | 2 Comments

For all you tech readers that like to keep your books digital, I’m happy to announce my new book “Keeping Windows 8 Tablets in Sync with SQL Server 2012″ is available on the Kindle. For just $9.99 USD, you can learn how to rapidly virtualize your data sync infrastructure for private, public, or hybrid cloud scenarios.  […]

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

Building Microsoft MEAP: Scaling Out SQL Server 2012

Building Microsoft MEAP: Scaling Out SQL Server 2012

| January 8, 2013 | 4 Comments

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

Continue Reading

Happy Tech 2013

Happy Tech 2013

| January 1, 2013 | 1 Comment

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 give you just the right amount of sharding. May your 15,000 RPM, RAID 10 disk […]

Continue Reading

Building Microsoft MEAP: Adapters

Building Microsoft MEAP: Adapters

| December 3, 2012 | 1 Comment

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 for CIOs today is extending critical data from their backend systems out to the wireless […]

Continue Reading

Getting Started with SQLite on Windows 8 > Installation

Getting Started with SQLite on Windows 8 > Installation

| October 24, 2012 | 6 Comments

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 database engine.  We all know that there’s no such thing as ubiquitous wireless connectivity and […]

Continue Reading

A Quick Note on Speedy, Scalable, Available Architectures

A Quick Note on Speedy, Scalable, Available Architectures

| December 2, 2011 | 0 Comments

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 database. If you have to get your answer from your database, make sure to add […]

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