Saying Goodbye To 2009
I'll close out 2009 with an update on the goals I set at the beginning of this year and things...
2009-12-31
1,396 reads
My Biggest Weakness
I took some time off in December and I'm finally getting around to catching up on RSS feeds. Turns out...
2009-12-31
1,518 reads
Stored Procedures to Store and Get Database Users with All Permissions
Introduction
Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...
2009-12-31
1,789 reads
[OT] Happy New Year
Well, it's been an interesting year. I got to teach four different brand new SQL Server courses, and teach classes...
2009-12-31
1,342 reads
Final Recap – 2009 Goals
Well, I set 7 professional goals for 2009 and I did okay in meeting them, but I was not successful...
2009-12-31
1,387 reads
Goals for 2010
Last year I wrote about my goals for 2009. Yesterday I looked over them and evaluated my performance. I think...
2009-12-31
1,905 reads
Running a Small User Group - Remember, It's Not Exclusively Yours
I'm going to conclude this series on running a small user group with a topic that came up for discussion earlier...
2009-12-31
1,416 reads
Script Individual User Rights in a Database with PowerShell
Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...
2009-12-31
1,440 reads
Wrapping Up Blogging for 2009
I think I’ve met my goal of blogging every day. I’m at almost 800 posts now over the past 2.5...
2009-12-30
1,406 reads
A Small Collection of I/O Specific DMV Queries
It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many...
2009-12-30
4,232 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
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
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