Upcoming Engagements
I haven’t been speaking a lot lately as I’ve been busy working, planning SQLSaturday #49 – Orlando, and planning PASS SQLRally,...
2010-09-07
481 reads
Auto Close – SQL Server
I ran into an issue recently where I had a third party supplied database set to auto close. I couldn't...
2010-09-07
3,000 reads
Unique and non-unique non-clustered indexes on a non-unique clustered index
In the last weblog post I have talked about the differences in unique and non-unique
non-clustered indexes on a unique clustered...
2010-09-07
4,110 reads
Virtual Labs - A Great Resource for SQL Server
I had someone send me a note recently asking some questions about how to get set up to work with...
2010-09-07
1,063 reads
Book Review: Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the United States
Another choice brought about by wandering the local library, Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the...
2010-09-07
592 reads
PASS BI Virtual Chapter Event - SSRS 2008 R2 The New Stuff
Quick update from your PASS BI Virtual Chapter folks!
September 29th, Mike Davis is doing a session on SSRS R2: The New...
2010-09-06
389 reads
Get ready for the Third Annual SW Florida .Net Code Camp!
Hey there database folks! Don’t be scared off by a little .NET. The SW Florida code camp is getting underway...
2010-09-06
364 reads
PASS BI Virtual Chapter – Adaptive BI: Engineering a BI Solution
Hey there folks – PASS Virtual BI Chapter Event Alert!
Don’t forget to come out on Sept 20th and get Adaptive with...
2010-09-06
1,088 reads
SQL Lunch #38-Restartability in SSIS
Hey There SQL Lunchers – Come out and check out Kyle Walker talking about restartability in SSIS.
Specifics to make sure you...
2010-09-06
405 reads
Where do you get your motivation and drive?
I was asked by someone the other day, where do you get your drive and motivation? For a second, I...
2010-09-06
652 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