change management

Stairway Step

As database changesets accumulate over time, they gradually become more than deployment artifacts. This level explores how a well-organized changeset library evolves into a replayable representation of the database’s structural history, supporting not only reliable deployments but also reconstruction, auditing, and long-term maintainability. Through practical examples and a real-world case study, it shows why maintaining coherent Create and Rollback scripts continues to provide value long after a successful production deployment.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-08-05

695 reads

Discuss

Concurrency and Baseline Control: Stairway to Reliable Database Deployments Level 5

by Massimo Preitano

SQLServerCentral

Uncategorized

Stairway Step

As database development scales across multiple contributors, concurrency becomes an inherent aspect of the process. Changes that are individually correct may still conflict when developed against a shifting baseline. This level introduces a disciplined approach to managing parallel changesets by controlling their scope, identifying overlap, and resolving conflicts through realignment. By ensuring that only one changeset retains its original baseline while others are adapted accordingly, deployments remain predictable and consistent. Once released, changesets are treated as immutable, and further evolution proceeds through new, forward-only changes.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-06-24

1,208 reads

Discuss

Defining the Deployment Contract: Stairway to Reliable Database Deployments Level 2

by Massimo Preitano

SQLServerCentral

Stairway Step

Level 2 formalizes the behavioral guarantees that a changeset must provide in order to be safely deployed and rolled back. It introduces the deployment contract, checkpoint semantics, and the structural scope of Create and Rollback scripts. Data changes are addressed through a dedicated Update mechanism, with clear boundaries and limitations. By the end of this level, a changeset becomes a predictable and well-defined unit that can be reasoned about independently of execution context.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-05-06

1,302 reads

Discuss

change management

Managing Changesets Over Time: Stairway to Reliable Database Deployments Level 6

Concurrency and Baseline Control: Stairway to Reliable Database Deployments Level 5

Defining the Deployment Contract: Stairway to Reliable Database Deployments Level 2

Blogs

T-SQL Tuesday #203: Risk and Reward

dataMinds Connect 2026 – Slides & Scripts

How to Clear the SSMS Cache (SSMS 21 and Later)

Forums

Risk Vs Reward, The never ending ROI discussion.

Alamat BCA KCP Cideng Timur Telp:0821-8200-203

Alamat BCA KCP KEM Tower Telp:0821-8200-233

Question of the Day

Hyperscale Replicas IV