Tag:

Database

Mobile Apps Must Work Offline Because Wireless Connectivity isn’t Ubiquitous

Intermittent wireless connectivity requires mobile apps to follow sync patterns using pre-fetched data via APIs and offline local storage. If the network isn’t available, it’s pretty hard for your native app to call web APIs or for your web app to load new web pages. On the Ethernet connected desktops of the past, developers didn’t …
Read more

It’s Time to Dump your 1990s App Authentication

Migrate Win32 applications secured by client/server database logins to mobile apps that use OAuth & enterprise cloud directories for authentication instead. Do you know Scott Tiger? Are you familiar with SA and no password? If so, you probably worked with client/server database security mechanisms from companies like Oracle, Microsoft, IBM and others. Anyone who’s built client/server, …
Read more

It’s Time for one Mobile Database to Rule Them All

Migrate Win32 applications using a mobile database like FoxPro, dBase, Access and SQL Server Compact to SQLite across all mobile devices. If it weren’t for desktop databases and learning SQL, my career as a developer may never have launched. I learned dBase for DOS in college, moved on to Paradox when Windows arrived on the scene …
Read more

Rob Tiffany Named Among Top 30 Technology Influencers in Major Report

I’m thrilled to be included in this group of technology influencers and luminaries like Werner Vogels, Steve Wozniak and Mark Russinovich. To become one of those technology influencers, it’s taken a lot of years of hands-on experience building mobile, cloud and Internet of Things solutions combined with writing books, speaking at conferences around the world, blogging, …
Read more

Improve Employee Productivity by Delivering Web Scale to your Mobile Workforce

Bring web scale to backend business systems via adapters, replication, sharding, queuing & caching to support a growing mobile workforce. Many of the backend systems running global business over the last several decades have something in common besides not being able to communicate with mobile devices. They’re not designed to support the scale needed to …
Read more

Looking to the Future of Cross-Platform Mobile Data Sync with SQL Server

If you’ve used Merge Replication to sync SQL Server Compact data on mobile devices with SQL Server in the past and you’re looking for a cross-platform solution to take you into the future, take a look at Zumero. As many of you know, I spent most of the first decade of the 21st century building massive-scale mobile …
Read more

Wrap a Web API around Your Enterprise & Take Microsoft SQL Server 2014 Data Offline w/ NoSQL via Universal Apps for Windows

At TechEd New Zealand, I presented a session on how to integrate a company’s backend systems into SQL Server 2014 and deliver that data out to mobile devices via Web APIs to support the operations of occasionally-connected apps on mobile devices using NoSQL tables. Enterprise mobility is a top priority for Chief Information Officers who must empower employees and …
Read more

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