Poll Reveals DBAs Actively Tune TEMPDB
When I manage a SQL Server instance, I always make an extra effort to optimize the performance of TEMPDB, so...
2011-02-03
717 reads
Blog Posts
SQL Saturday #63 Dallas Needs YOU
Dallas’ first SQL Saturday ”was full of nothing but smooth, rich #awesomesauce.” And we had Italian gelato.
Dallas’ second SQL Saturday (BI edition) ”had over...
2011-02-03
474 reads
SQL Saturday Advice–Upload Decks Early
One of the neat features for the SQL Saturday site is that it allows the speakers to upload a deck...
2011-02-03
1,418 reads
SQL University: State of the Union
The new SQL University Logo
Well the new year is here and SQL University is back and better than ever! I...
2011-02-03
650 reads
The Many Faces of SQL Server
Well, one of my goals this year was to focus on branding myself a little more. So I decided to...
2011-02-03
453 reads
Time’s Makin’ Changes
Some History Almost exactly 7 years I ago my wife and I decided to apply to be missionaries with New Tribes Mission. We decided at that time to...
2011-02-03
6 reads
Time’s Makin’ Changes
Some History
Almost exactly 6 years I ago my wife and I decided to apply to be missionaries with New Tribes...
2011-02-03
787 reads
What SQL Server Service Pack Do I Have Installed?
If you’ve used SQL Server for a while, you’re probably familiar with the @@version function. @@ variables are system variables that...
2011-02-03
853 reads
Who Changed Jobs in 2010?
Linked in sent me an email saying that an astounding 209 of my connections changed jobs in 2010, out of...
2011-02-03
539 reads
A Full Backup can Impact a Log Backup–MCM Prep
In the early days of SQL Server you could not run a log backup while a full backup was running....
2011-02-02
2,927 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