T-SQLTuesday #42! The Long and Winding Road
The Long and Winding Road It is time for another installment in the monthly blog party for SQL Server professionals known as TSQL Tuesday. This month...
2013-05-14
7 reads
Blog Posts
T-SQLTuesday #42! The Long and Winding Road
The Long and Winding Road
It is time for another installment in the monthly blog party for SQL Server professionals known...
2013-05-14
689 reads
T-SQLTuesday #42: The New Adventure!
It’s time for T-SQL Tuesday the forty-second, Wendy Pastrick asked that we talk
T-SQL Tuesday!
about our experiences with change in our work lives. I’d...
2013-05-14
583 reads
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...
2013-05-13 (first published: 2013-05-07)
3,784 reads
Copy / Paste Code
Copy / Paste formatted text is a nightmare in WordPress. I’m singling out WordPress because I use it, and, from what...
2013-05-13
603 reads
DMV-10 : Does my database contain edition specific features?……..sys.dm_db_persisted_sku_features
sys.dm_db_persisted_sku_features (Introduced in SQL Server 2008) DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/cc280724.aspx
Some features of the SQL...
2013-05-13
2,093 reads
How to Tell Your Windows Azure SQL Database Moved
The very concept of the Windows Azure SQL Database (WASD) is predicated on the up-time created by having three active copies...
2013-05-13 (first published: 2013-05-07)
1,585 reads
Last Weeks Top “Reading” Links #32
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-13
668 reads
SQL Server – How to Move Table to Another Schema
Starting with SQL Server 2005 all tables are grouped into schemas. While creating a table if the schema name is...
2013-05-13
1,827 reads
Use Powershell to find and punish – er, delete – rogue files
I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I...
2013-05-13
1,087 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