Tag:

Data

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

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

Empower your Demanding Mobile Line of Business Apps with SQLite and Offline Data Sync on Windows

Presenting at TechEd in Houston, watch my session: “Empower your Demanding Mobile Line of Business Apps with SQLite and Offline Data Sync on Window.” 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 get by …
Read more

Mobile Enterprise App Platform (MEAP)

In this week’s episode of “Inside Windows Phone,” Matthijs Hoekstra and I discuss how to build the Microsoft Mobile Enterprise App Platform (MEAP). Mobility is the top priority for Chief Information Officers (CIOs) today.  To drive their business, they must empower their mobile employees by unlocking the value of their enterprise systems.  To do this, …
Read more

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

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

Mobile World Congress 2013 Takeaways

Mobile World Congress has wrapped up and most of us are back home after spending four days at Fira Gran Via in Barcelona. Between delivering presentations, walking miles of expo halls, and participating in dozens of meetings, the event is both exciting and tiring.  This conference used to be the sole domain of mobile operators, wireless equipment …
Read more

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

Encrypting your Credentials on Windows Phone 7.5

The last time I talked to you about Windows Phone security, I showed you how to encrypt your data and save it in Isolated Storage using Silverlight’s AesManaged class to create a Key and an Initialization Vector (IV) based on a password and salt value.  This gave your consumer and line-of-business apps the iron-clad AES …
Read more