SQL Saturday#52 – Colorado Recap
This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it,...
2010-09-28
2,016 reads
Blog Posts
SQLSaturday #52 Report
I was lucky enough to present two sessions at SQLSaturday #52 in Denver on September 25, 2010. By my estimate,...
2010-09-28
547 reads
To Be There Or Not To Be There
Are you ready for Seattle? Have you registered for the PASS Summit? Hopefully with some good reasons you will be...
2010-09-28
679 reads
Windows Power Plans and CPU Performance
Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans...
2010-09-28
2,316 reads
Can Deadlocks be Resolved by Adding an Index?
Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.
First, let me...
2010-09-27
1,414 reads
Index Black Ops Part 4 – Index Overhead and Maintenance
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-09-27
1,134 reads
Journal: SQL Saturday #52
Friday
6am – up to catch an 8:30 flight. My daughter Lisette is going with me on this trip.
9:30am local time, we...
2010-09-27
691 reads
Orlando – Reminder to Register for SQLSaturday #49
We’re less than 30 days out from SQLSaturday #49 and we’re working hard on the logistics. Speaker gifts ordered, lanyards...
2010-09-27
634 reads
Parameter Name Size And Performance
I saw an odd statement the other day, “The size of the name of the parameter does not affect performance.”...
2010-09-27
1,031 reads
People are talking about you
I was listening to a friend give a presentation on getting a job recently. In the presentation, Chris Shaw, the...
2010-09-27
969 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