Do the Packet Trace - Especially When Things Are Good
Last night we were troubleshooting really poor performance on a core system. One of the things being investigated was a...
2010-11-24
1,031 reads
Blog Posts
FreeCon
I got my FreeCon. What’s more, I did it in public and didn’t get in trouble.
FreeCon is the brain child...
2010-11-24
1,620 reads
Holiday Review: Stuff I
For the last two years, I’ve participated in Sean’s InfoWorld Xmas Wish List, where we review a bunch of cool...
2010-11-24
573 reads
How Do I Change SSRS Report Credentials with Powershell?
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-11-24
7,177 reads
I'm a Midnight DBA
Well, not really. However when I was recently up in Seattle, Jen and Sean McCown contacted me about being on...
2010-11-24
830 reads
Notes from SQLSaturday#59 - Waits & Queues Presentation
SQLSaturday#59 – Waits & Queues Presentation
At SQLSaturday#59 in NYC, my session was about Waits & Queues. I presented a topic I thought was...
2010-11-24
942 reads
SSIS Denali Annotations
I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali.In previous...
2010-11-24
672 reads
What I’m Thankful For
Since it is the week of Thanksgiving in the United States, Jason Strate (@strateSql) has requested that bloggers post what...
2010-11-24
587 reads
XQuery for the Non-Expert – Resources
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Learning XQuery...
2010-11-24
1,603 reads
2010 PASS Summit Recap
The 2010 PASS Summit has been over for a week and a half now and I've finally recovered & processed everything...
2010-11-23
686 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