FLX SQL

Blog Post

Did You Really Name That Default?

Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:

SQL Server...

2026-04-17 (first published: )

379 reads

Blog Post

Presenting Twice in May 2026

I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person twice in May 2026. With summer vacations coming up, this is a perfect time of...

2026-03-30

22 reads

Blog Post

T-SQL Tuesday #193 - Notes to Self

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mike Walsh
(blog) asks us:

Write two short notes to yourself. One to the...

2025-12-29 (first published: )

239 reads

Blog Post

Finding Data Friends

I’ve been enjoying Ben Weissmann (Blog | LinkedIn) & Jess Pomfret’s (Blog | LinkedIn ) weekly program Finding Data Friends for a couple years now, getting to know (by...

2025-10-27

8 reads

Blogs

Narrow Task Decomposition in AI Pipeline Agents

By

A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...

Car Update: August 2026

By

It’s been some time since I provided a car update, so I decided to...

Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To

By

An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...

Read the latest Blogs

Forums

Managing Incidents and Fighting Fires

By Pat Wright

Comments posted to this topic are about the item Managing Incidents and Fighting Fires

Backing Up a DMK

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing Up a DMK

The Quiet Part

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Quiet Part

Visit the forum

Question of the Day

Backing Up a DMK

In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?

See possible answers