Attach Database with Missing NDF File
I wonder if you’ve had the situation that I had before where you have to attach a database with one or few missing .ndf files. It seems pretty common...
2013-05-07
10 reads
Blog Posts
Billing rates – other side of the fence, part 2
Here is another response to my blog “Should a placement firm tell you what they are billing the client?” (the...
2013-05-07
1,108 reads
Books On The Desk
I read quite a bit and it’s rare that I don’t have a book or magazine with me in case...
2013-05-07
677 reads
Find Duplicate Indexes on SQL Server (Script)
Like other mainstream commercial database systems, Microsoft SQL Server allows you to create multiple indexes on the same column of...
2013-05-07
1,216 reads
I'm Giving a SQL Server Security Webinar on May 9, 2013
On May 9, 2013, at 3 PM EDT I will be presenting on 5 Steps Every DBA Should Take to...
2013-05-07
1,200 reads
Installing SSMS 2012 all by it’s lonesome
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,613 reads
Presentation Materials “Discovering the Plan Cache” #SQLSat175
I’m a little late getting the information from my Fargo SQL Saturday session posted, titled ”Discovering the Plan Cache“. But it’s...
2013-05-07
528 reads
SQL Saturday Jacksonville 2013 Wrap-up
It was another great year at SQL Saturday Jacksonville. For the last several years I have been lucky enough to...
2013-05-07
479 reads
SQL Server – Finding TCP Port Number SQL Instance is Listening on
By default SQL Server listens on TCP port number 1433, and for named instances TCP port is dynamically configured. There...
2013-05-07 (first published: 2013-05-01)
4,827 reads
SQL Server 2008 R2 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-05-07
752 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