What Has Jack Been Up to?
It has been awhile since my last post mainly because I was on a working vacation in northern New England...
2010-06-25
459 reads
Lock Pages in Memory
It is generally recommended that 'lock pages in memory' be enabled for your SQL Servers to prevent the OS paging...
2010-06-25
9,655 reads
Speaking and Presenting Tips - Bullets
I’ve heard this before, it came up in the Tufte seminar I took, and it also was something that grated...
2010-06-25
1,104 reads
The Exceptional DBA of 2010
I’ve been a judge in this contest for the last 3 years, and each years we’ve had really good finalists,...
2010-06-25
822 reads
Growing the SQL Community – Carefully
If you’re a blogger or a twitterer or a SQL speaker or PASS volunteer, you do it because you have...
2010-06-25
560 reads
My SELECT statement has hung!
One of the first roadblocks many developers run into when using SQL Server for the first time is firing off...
2010-06-24
2,610 reads
PowerShell Script to Remove Old Backups
A Twitter user asked for a script to remove old backups, and I had one I built back in February,...
2010-06-24
1,129 reads
MDX webinar
Today I did a webinar on MDX solutions. For those of you interested you can grab the slides here and...
2010-06-24
1,213 reads
Traveling with Steve
I don’t travel a lot, but with the success of SQL Saturday, I find myself heading out on the road...
2010-06-24
1,330 reads
Building a PASS Voting Solution – Part 6
Today we’ll try to finish up by looking at a couple of the semi-interesting parts of the code in this...
2010-06-24
644 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
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 James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
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