Creating SQL Server 2008 Databases with T-SQL
Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file...
2010-03-24
1,402 reads
PASS Update #27
I’m just back from the March 2010 Board meeting and it went better than usual (for any meeting). Most of...
2010-03-24
594 reads
Getting Stubborn Chief Executive Officers to Listen: Speak Their Language
After consecrating several posts on workplace bullying, and hearing our great Steve Jones rant about Toshiba’s lack of action regarding...
2010-03-24
1,965 reads
Avoiding Plagiarism
Having gone to an academic magnet school, I have quite a few friends who are teaching at the university level...
2010-03-24
1,917 reads
Adding a Column to Every Table
I am Script. I will update your database.
Despite the best laid plans, sometimes circumstances or project scope change and the...
2010-03-24
671 reads
A Personal Story about Networking
This is not a technical or SQL Server post, but it does illustrate the power of networking.
We recently took my...
2010-03-24
512 reads
SQL Server 2008 R2 - The list of the supported features
The MSDN - Microsoft, has collected too much info about features supported by the SQL Server 2008 R2, for all editions...
2010-03-24
1,243 reads
Why I Don’t Run for the PASS Board
It’s getting close to that time of year when you can apply to run for the PASS Board of Directors....
2010-03-24
1,649 reads
Managing Your Backup Files
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-23
1,334 reads
SQL Saturday #39 New York
New York, New York, it’s a hell of a town. The Bronx is up and the Battery’s down. The people...
2010-03-23
554 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