Tag: Data

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

Data + APIs + Devices

Data + APIs + Devices

| April 19, 2014 | 0 Comments

Data is the new oil, APIs are the new drills & devices are the new smart cars fueled by context and meaning.

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

Data is a Platform

Data is a Platform

| April 18, 2013 | 0 Comments

The realization that Data is a Platform provides a moment of clarity. Apps just present data to users and support its manipulation and capture. Mobile devices are convenient binary execution engines that facilitate the running of apps so you can work with that data. Focus your energy on securing data in-transit and at-rest while controlling its […]

Continue Reading

Mobile World Congress 2013 Takeaways

Mobile World Congress 2013 Takeaways

| March 4, 2013 | 1 Comment

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

Continue Reading

Books and Taxes

Books and Taxes

| February 4, 2012 | 0 Comments

Wow!  Just opened a 1099 tax document for 2011 from Apress.  People must still be buying my old books on eMbedded Visual Basic, the .NET Compact Framework 2.0, and SQL Server Compact 2.0.  The Pocket PC and Windows Mobile live on! A separate 1099 for Hood Canal Press tells me that my SQL Server Merge […]

Continue Reading

Encrypting your Credentials on Windows Phone 7.5

Encrypting your Credentials on Windows Phone 7.5

| December 12, 2011 | 1 Comment

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

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

The Important User Experience (UX) You Can’t See

The Important User Experience (UX) You Can’t See

| February 10, 2011 | 1 Comment

Whenever I hear the term, “UX,” I immediately think of graphic designers, artists and folks who focus on making the UI of your application beautiful.  Nine times out of ten, this is the appropriate connection to make.  Great UX folks at Microsoft came together to make Windows Phone 7 the most visually-appealing smartphone on the […]

Continue Reading