Tag: Database

How to Create In-Memory Database Tables in SQL Server 2014

How to Create In-Memory Database Tables in SQL Server 2014

| August 18, 2014 | 0 Comments

Getting data off disk drives and into RAM is the biggest game changer for relational databases in decades and SQL Server 2014 brings it to the masses. RAM is cheap and it’s finally time to reap the benefits of 64-bit computing. SQL Server In-Memory OLTP, also know at Hekaton is here and it’s ready to […]

Continue Reading

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