Scheduling backups in SQL Server Express
I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always...
2010-03-29
1,706 reads
Indexes - where you cannot create them!
Indexes are the objects that DBA uses them everyday and maintaining them very often, during the maintenance routines. The main...
2010-03-29
3,706 reads
Notes from the Orlando Code Camp March 2010
I arrived about 7:15 and already quite a few people on hand. Registration was moved to inside this time, just...
2010-03-29
972 reads
Using Custom Connection Colors in SSMS
One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was...
2010-03-29
3,976 reads
To Get Certified or Not Get Certified
I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think...
2010-03-29
932 reads
TempDB – Relocate the TempDB Database Files
I took control of a new server recently and noticed that Tempdb was not configured to best practice. It was...
2010-03-28
1,295 reads
DBCC INPUTBUFFER vs fn_get_sql
Someone asked a question in the forums the other day and I realized it would make a pretty decent blog...
2010-03-28
8,775 reads
Making Sense of Replication Errors in Replication Monitor
Making Sense of Replication Errors in Replication Monitor If you've ever had to deal with errors in Replication Monitor, your first...
2010-03-27
12,088 reads
SQL Server Social Group a Fresh Perspective on User Group Meetings
The Cam river flows through Cambridge, England. At the center of the river you can see a punt (a type...
2010-03-27
475 reads
So you want to write a blog?
First, figure out what you want to write about. It should be something you have passion for. And it should...
2010-03-27
1,536 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