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

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 give you just the right amount of sharding. May your 15,000 RPM, RAID 10 disk … 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 for CIOs today is extending critical data from their backend systems out to the wireless … Read more

Human Table Scan

VB Grid

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 the unproductive process of visually scanning and endlessly scrolling unfiltered lists of data in your mobile … Read more

Getting Started with SQLite on Windows 8 > Installation

SQLite

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

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 system. You’re probably thinking this is an antiquated phenomenon that disappeared decades ago with the advent of … Read more

Sync Framework v4 is now Open Source, and ready to Connect any Device to SQL Server and SQL Azure

Sync

Microsoft has brought the power to synchronize data with either SQL Server on-premise or SQL Azure in the cloud to the world of mobility.

Performance and Memory Management Improvements with Windows Embedded Handheld

It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.

SQL Server Compact 4.0 Lands on the Web

SQL Server

With the new version 4.0, the little-database-that-could has grown up into a powerful server database ready to take on the web.

Reducing SQL Server Sync I/O Contention :: Tip 3

Primary Key

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 know, each row is uniquely identified by its Primary Key.

Reducing SQL Server I/O Contention during Sync :: Tip 2

Database Storage

All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.

Reducing SQL Server I/O Contention during Sync :: Tip 1

SAN Storage

The act of tracking changes made by each SQL Server Compact or Silverlight sync subscriber can cause a lot of locking and blocking on the server.

Windows Phone 7 Line of Business App Dev :: Improving the In-Memory Database

Phone 7

About a month ago, I wrote an article intended to help you fill some of the gaps left by the missing SQL Server Compact database. Since your Windows Phone 7 Silverlight app is consuming an ObservableCollection of objects streaming down from Windows Azure and SQL Azure, it makes sense to organize those objects in a … Read more

Windows Phone 7 Line of Business App Dev :: Working with an In-Memory Database

Phone3

In my last article of this series, you finally got to consume wireless-friendly WCF REST + JSON Services from both Windows Server and Windows Azure with data coming from SQL Server/SQL Azure. You now have an ObservableCollection of Customer objects residing in a Singleton on your Windows Phone 7 device.  This Singleton looks similar to … Read more