Truncating the Log and Database Mirroring
I saw someone post recently that they wanted to run this code on their principal server in database mirroring to...
2010-06-30
2,129 reads
MS Access Annoyance: Doesn’t Link Synonyms
I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data...
2010-06-30
3,147 reads
Does Your Company Have a SQL Server DR Plan?
This past month I ran a poll asking this question: “Does your company have a formal, tested, disaster recovery plan...
2010-06-30
1,554 reads
The Trade Deadline Must be Drawing Near
The Trade Deadline Must be Drawing Near
Okay, so there is no trade deadline in SQL Server like there is in...
2010-06-29
2,138 reads
Does a missing data file send a database suspect?
Short answer: No
I keep seeing this come up on various forums when people ask what makes a database go suspect...
2010-06-29
2,038 reads
Partition Alignment and Late Night Infomericals
Late night infomercials make some amazing claims. “If you order now you too can cut through a cinderblock wall and...
2010-06-29
1,509 reads
‘Tis the Season for SQL Leaving
With the announcement of Brent Ozar (Blog | Twitter ) leaving Quest for SQL Skills, Exceptional DBA finalist Jorge Segarra (blog | twitter)...
2010-06-29
1,609 reads
SQL Saturday #28 (Baton Rouge) – All about User Groups
This year at SQL Saturday #28 we will be featuring a User Group Booth alongside the Sponsor booths. The User Group...
2010-06-29
1,566 reads
The Breakfast Plan Goes Awry
Here’s the editorial for SSC today and while it’s a humorous story about asking for donuts and getting a free...
2010-06-29
1,426 reads
Conference Calls Are Hard
Conference calls are a fact of life for most of us. Remote offices, remote workers, clients – lots of reasons to...
2010-06-29
1,428 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
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
BIT_COUNT in SQL Server
Comments posted to this topic are about the item BIT_COUNT in SQL Server
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