Managing database changes using Flyway: an Overview

This article describes the principles of using Flyway migrations to build a database from scripts, to a specified version, and to track, manage and apply all database changes.

Getting your SQL Server Development Data in Three Easy Steps

Phil Factor takes a staged approach to generating development data, creating one project that simply copies data from an existing database, another that copies most data but generates any personal or sensitive data, and a third that starts from 'anonymized' data and then generates other columns entirely and increase the number of rows for testing.

Database Updates: Rolling Back and Fixing Forward

Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update.

What is database continuous integration?

Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of better quality, quicker to change, and cost less? Grant Fritchey explains some of the secrets of doing Continuous Integration for Databases to relieve some of the pain-points of the Database Delivery process.

Explore the Role of Normal Forms in Dimensional Modeling

In this tip we walk through an exercise of developing a data model based on the characteristics of the data requirements.

Solving the Provisioning Problem in Database Development using Clones

When database development is described, the details often get vague when the data gets beyond spreadsheet-size. There is 'hand-waving' talk of providing databases for each developer, but little detail of how you would provision all the databases that would be needed, at the correct version and with the correct development data, and then keep them all in sync with the source code, as developers commit changes. This article explains the requirements, and how SQL Clone can meet them.

How Many Databases Can You Name?

There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases!

Quick ADD & ALTER Generator

Generate Add & Alter columns from an existing database

SQL Server 2014 system databases

Status and Name Please