My Ideal SQL Server Test Box is on the Way
Several weeks ago I wrote a blog post called “What is the Ideal SQL Server Test Box?” At that time...
2010-07-01
1,168 reads
Building A Remote Desktop Manager Cluster List
The Microsoft Clustering and High Availablity bloggers have taken noticed of the Remote Desktop Connection Manager (RDCMan) utility from a...
2010-06-30
1,612 reads
MDX Puzzle #2
Now that we have our feet wet, let’s get started with the next puzzle. In this puzzle we will write...
2010-06-30
1,452 reads
One of these things is not like the other
I’m working with PowerShell, and digging it. I decided that I wanted to create a new script (blog post later,...
2010-06-30
2,092 reads
The Politics of SQL Server Performance
Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL...
2010-06-30
1,521 reads
SQL Saturday #48 - Columbia, SC - Registration and Call for Speakers is On-line
The website is up for SQL Saturday #48 - Columbia. We're holding it on October 2, 2010, in West Columbia, SC,...
2010-06-30
1,445 reads
PASS, Don’t Waste My Time
Update: Apparently I can't write, or get a point across from the
comments and a few emails, so I have...
2010-06-30
2,518 reads
DB2 – Create a Database
OK for my next DB2 trick and remaining off the path of the righteous for the time being we will...
2010-06-30
4,991 reads
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
Blogs
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...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
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