Placeholders come in very handy in Flyway, but troubleshooting the SQL migration and callback scripts that use them can be tricky. This articles demonstrates how to develop, test and debug these scripts in a tool designed for these tasks, such as SSMS, leaving Flyway to do what it's designed for, which is running the scripts.
The post Debugging Flyway Callbacks and Migrations that Use Placeholders appeared first on SQLServerCentral.

Learn how to connect your Synapse workspace to a Git repository.
The post How to Integrate Azure DevOps with Azure Synapse Studio appeared first on SQLServerCentral.

Often, we want to test the new version of a database, produced by a Flyway migration, before committing the new migration file, or to test the same migration run on a number of different databases. This article demonstrates how to do it, by generating and using JSON parameter files to run a series of Flyway actions on any number of databases, on any number of servers.
The post Testing a Flyway Database Migration appeared first on SQLServerCentral.

Crowdsourcing is one way to get a job done. In this article, Devyani Borade describes crowdsourcing quality testing of software.
The post Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing? appeared first on SQLServerCentral.

Introduction In this article, we will talk about a newly introduced activity in Azure Data Factory, which is the fail activity. The fail activity is very useful to stop or fail the pipeline at the specified point. For example, a lookup activity might return no data or a switch activity executes the default block. We […]
The post Working with Fail Activity in Azure Data Factory appeared first on SQLServerCentral.

Flyway uses a schema history table to track the version of each database, recording in it every versioned migration file applied to build that version. It's worth understanding exactly how Flyway uses this table, the possible dangers of moving it to a non-default location and how to do it safely, if required.
The post Exploring the Flyway Schema History Table appeared first on SQLServerCentral.

SQL Server provides two ways to include an incrementing number in a table. Greg Larsen explains how to replace an identity column with a sequence number.
The post How to replace an identity column with a sequence number appeared first on SQLServerCentral.

Learn about enabling soft-delete for your Azure Storage containers.
The post Prevent Accidental Data Deletion in Azure Storage Container with Soft Delete Features appeared first on SQLServerCentral.