How Automation Activates Agile

Harsh, yes... but too often true. Certainly, Agile is a great start for business user collaboration to ensure requirements fit, but it depends on Working Software. This is exactly what automation provides: Working Software, Now. Here's how.

Overview

This article illustrates how Automation, coupled with an Agile Process, can dramatically improve time to market, and reduce requirements risk:

What Is a Smart Database Proxy?

Smart database proxies may not be familiar to many people, and it's a shame because they can solve many difficult problems elegantly. This article explains what they are, what they do, and when they are useful.

A Quick Comparison

Let me start with a seemingly unrelated topic: web pages. Bear with me, it will all come together in a minute.

How to Choose a Suitable Type of Database for Mobile Apps?

Mobile apps are the most important components of a smartphone, which is why every mobile app needs to possess both the best offline and online capabilities, as well as synchronization, which is the key to a successful mobile app. Mobile apps are widely used for different types of purposes, and thousands of apps are created every day. Each app has to perform to its fullest to get noticed and stay on top all the time.

No matter what purpose an app targets, if it doesn't work well and relate to the audience, it won't be used. Or it will be downloaded and then removed with no mercy. This is why syncing the right database for your mobile app is a quite substantial aspect of high-performance mobile apps. A suitable database makes sure your app stays reliable, responsive, and competitive under all circumstances.

Add Databases to CI With Production Database Clones

DevOps involves source control and automated application builds with binaries as immutable artifacts for a repeatable DevOps process. Updating SQL Server databases, however, is not accomplished so simply and must be upgraded in place. Current SQL DevOps practices involve building a development database with schema and objects and static data for functional testing. The “development database” is succeeded by a “production like” database for later stages and ultimately, upgraded scripts are applied to production. This approach is complex and breaks the principle of working with unchanging artifacts throughout the DevOps process.

Fortunately, a simpler approach with production database clones and SQL Server containers delivers simplicity, horizontal scalability, and economy. Production database clones are delivered in seconds with immutable writable replicas of production for higher fidelity releases. Full disclosure: I am a principal at Windocks where we focus on SQL Server containers and database cloning, but these same approaches should work with storage array cloning with Bash or other scripting.