sp_help_partition
If you are using partitioned tables, this may come in handy. I’ll keep it short and just post the code....
2010-08-08
1,746 reads
Getting Drive Info Part 1, sp_OA
This blog series will cover several different methods to collect drive information from a Windows server that is running SQL...
2010-06-29
2,655 reads
SSIS-DTS Package Search 2.0.18 released
SSIS-DTS Package Search 2.0.18 has been released. This is a bug fix release that addresses a problem with the search...
2010-06-08
815 reads
Living with DTS on SQL Server 2005 and 2008
The DTS support in SQL Server 2005 and 2008 is excellent (almost). Typically the packages and jobs do not need...
2009-11-02
1,339 reads
Which version of SSIS-DTS Package Search is right for you
The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...
2009-08-12
1,466 reads
Moving to Hyper-V
My primary development machine for the past 3 years was a 32 bit Toshiba Satellite notebook running XP named PROBE-DROID....
2009-06-04
861 reads
Anti-Virus Adventures
Denny Cherry wrote a blog post recently discussing whether to run anti-virus software on Sql Server machines. He said you...
2009-05-20
782 reads
SQL This, Not That – Episode 2
When creating a table with a column that will hold the name of a stored procedure that feeds an EXEC...
2009-04-30
1,434 reads
2009-04-28
1,483 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