This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator. We build the latest database version (schema only), then copy into it, from the production database, the data for any tables and columns that don’t require masking.... Read more
“Understanding the existing product consumes roughly 30 percent of the total maintenance time.” Facts and Fallacies of Software Engineering by Robert L. Glass. You should be documenting your database schemas. I know it, you know it. Having (current, accurate) documentation available accelerates time-to-resolution for faults, aids tech-to-business conversations, and is a regulatory requirement for a great number of... Read more
We’re pleased to announce that you can now monitor more databases in DLM Dashboard. The latest version, 1.6.2, supports up to 50 databases! Higher database limit was one of the most requested features on UserVoice. Along with the ability to exclude changes using filters, and the option to restrict access to the tool through permissions, we’ve... Read more
From a business risk perspective, data change can be just as significant as code or schema change. Sometimes even more so; an incorrect static (or reference, or master) data change can drive your software’s behaviour more dangerously askew than pretty much any bug can. Imagine treating a retail customer for an investment fund as a corporate... Read more
Richard Macaskill