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.

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

by Massimo Preitano

SQLServerCentral

This level examines how a rehearsed changeset is transformed into production-ready deployment artifacts. By consolidating scripts into controlled execution units and validating the resulting artifacts, the approach ensures that production deployment remains predictable and aligned with what was proven during rehearsal.

How Do the Experts Become Experts?

by Kathi Kellenberger

SQLServerCentral.com

How do the experts get to that level? A few thoughts today in a guest editorial from Kathi Kellenberger.

SSMS Copilot is Messing With Your AI Prompts

by Additional Articles

Brent Ozar Blog

You might notice that the advice you get from Copilot in SSMS isn’t very good, but it isn’t necessarily AI in general. Part of the problem is something specific about SSMS Copilot and the way it prompts LLMs, and I wish I could tell you exactly what it is, but I can’t because I don’t have access to how SSMS is changing your prompts.

Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For

by vgupta

SQLServerCentral

This article shows how you can generate embeddings in SQL Server 2025, store them, and use them in your queries.

Would You Retire Rather Than ...

by Steve Jones

SQLServerCentral

Career Growth

What would make you retire? Steve asks the question today.

Microsoft are retiring role-based certifications. Here’s why they shouldn’t

by Additional Articles

SimpleTalk

Uncategorized

In this Simple Talk opinion piece, Microsoft certification veteran Dr Greg Low considers – and shares his thoughts on – the recent announcement that many role-based Microsoft certifications are being retired.

PASS Europe comes to Frankfurt

by Steve Jones

SQLServerCentral

PASS Summit

PASS Europe comes to Frankfurt, Germany on June 10-11, 2026.

The Data Model Matters

by Steve Jones

SQLServerCentral

Is a data model important in modern software? Steve thinks it is and gives a few reasons why we might want to spend a little time on ensuring we have good models as we build software.

Understanding SQL Server PARTITION BY with Examples

by Imran2629

SQLServerCentral

Introduction When developers first learn SQL aggregation, they usually start with the GROUP BY clause. It works well for summary reports because it combines multiple rows into a single result for each group. For example, you can calculate total sales per region or average salary per department. The limitation of GROUP BY appears when you […]

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

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

How Do the Experts Become Experts?

SSMS Copilot is Messing With Your AI Prompts

Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For

Would You Retire Rather Than ...

Microsoft are retiring role-based certifications. Here’s why they shouldn’t

PASS Europe comes to Frankfurt

The Data Model Matters

Understanding SQL Server PARTITION BY with Examples

Blogs

AI Experiments: Parsing Payment Memos

5 Starter Projects for Your AI and Data Engineering Portfolio

The Book of Redgate: Taking Breaks

Forums

Displaying Money

The Slow Growing Problems

Calculating the Harmonic Mean in Power BI

Question of the Day

Displaying Money