Database Design

Stairway icons Database Deployments

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

  • 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,048 reads

SQLServerCentral Article

Implementation of Normalization in SQL Server

  • Article

Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]

(2)

You rated this post out of 5. Change rating

2021-02-22

4,574 reads

Blogs

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

The Book of Redgate: Products

By

We are product focused at Redgate Software. Here is another of our values that...

KDA: Echoes of Deception - Case 7

By

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Read the latest Blogs

Forums

The SQL Server 2016 Plan

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server 2016 Plan

ALAMAT BCA KCU BANJARMASIN TLP/WA 08217555651

By m4rt1n4

Hub Cs:08217555651 Jl. Lambung Mangkurat No.11-13, Kertak Baru Ulu, Kec. Banjarmasin Tengah, Kota Banjarmasin,...

ALAMAT BANK BCA KCU SAMARINDA TLP/WA 08217555651

By R4nt4u

Hub Cs:08217555651 Jl. Jend. Sudirman No.30, Ps. Pagi, Kec. Samarinda Kota, Kota Samarinda, Kalimantan...

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)
What is returned?

See possible answers