Whats a Good Rule for Max Degree of Parallelism?
Introduction
I am one of those people that believe that anything worth doing is worth having a script to do it....
2010-04-20
556 reads
Stepping Stone Cert II
Back on March 30, I wrote about a Stepping Stone Certification that seems to be missing between the MCM and...
2010-04-20
749 reads
SQL Saturday #39, New York, New York
A town so big they named it twice.
If you’re not excited about SQL Saturday in NYC this weekend… why not?...
2010-04-20
520 reads
Staying Current with SQL Server Builds
There was some conversation on Twitter about how to get notification when new Cumulative Updates are released for SQL Server...
2010-04-20
975 reads
Sad Sack – Hardware Failures all over
I feel like I have some bad digital karma lately. In the past week I’ve had these downed systems:
iPod iTouch...
2010-04-20
646 reads
Growing PASS Step One - Communication
My History with PASS
Over the last two years I have become more involved in the SQL Server community through attending...
2010-04-20
614 reads
SQL Server Agent
Found out this week – that we should be restarting this service at least once a week ! (thus allowing the CPU...
2010-04-20
381 reads
Review: Ninite
Found Ninite while browsing a list of efficiency tools on PCWorld.com. It’s a one stop super installer, you run through...
2010-04-20
629 reads
A DMV a Day – Day 20
The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as:
Returns a row for each query plan that...
2010-04-20
1,095 reads
How Do I Find SSIS Packages that Exist in Multiple Folders?
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
309 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