SQLServerCentral Editorial

Things Move Fast

I have several things I’d like to say in the editorial today, but I feel I have to start off with my condolences to the family of Queen Elizabeth II. For that matter, my condolences to the people of Britain. This truly is the end of an era. Things do indeed move fast sometimes. Working […]

External Article

Rollbacks, Undos and Undonts

Rollback scripts are designed to allow us to recover safely from a failed deployment that leaves the database in an indeterminate state. They must check exactly what needs to be reverted before doing so. If you work with an RDBMS that cannot support transaction DDL rollback they are vital. This article proposes a strategy where you create and test a rollback file, at the same time as the forward migration, and reuse it as a Flyway undo script.

SQLServerCentral Editorial

Developer Optimism

Developers, in general, are very optimistic about the code they write. This is likely one cause of their estimates of the time required being low, as well as the various bugs that slip through because of corner cases that appear for the problem being solved. Often developers think they've considered the various ways this code […]

Blogs

SQL Server In Place Upgrades

By

Good morning dear blog reader. Today’s episode is fresh from a great weekend with...

Daily Coping 27 Sep 2022

By

Today’s coping tip is take your time. Make space to just breathe and be...

Running SQL Server in Windows Subsystem for Linux (WSL)

By

I previously wrote a post on how to convert a SQL Server Docker image...

Read the latest Blogs

Forums

The Migration Tool to Use III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Migration Tool to Use...

SSIS File System Deployments

By RonMexico

I created a package that utilizes environment variables in the configuration manager to toggle...

Create a DACPAC to only update not replace a SQL Server Database

By Weegee71

Hi there We have been creating a DACPAC from a SQL server database project...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers