SQL Server 2012 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-07
760 reads
Blog Posts
SQL Server Hardware and Acronyms
Over the weekend I finished reading yet another Red Gate book, this one was SQL Server Hardware by Glenn Berry...
2013-05-07
925 reads
SQL Server Travels–May 2013
At the end of this month of May, I will be teaching Learning Tree’s 3 day SQL Server Virtualization course...
2013-05-07
781 reads
Tips for Minimizing Deadlocks
Deadlocks are caused by poor database design, inappropriate isolation level, inefficient code etc.
Checkout my article (Tips for Minimizing Deadlocks) on...
2013-05-07
911 reads
Webcast Presentation Materials: Introduction to SQL Server Security
Last Thursday, I delivered a presentation for Pragmatic WorksTraining on the T’s. The session for last week was Introduction to...
2013-05-07
664 reads
Webinar: Scripting and SSIS
Tomorrow at 10am (11am EDT), I’ll be joining together with my good friend and SSIS Design Patterns coauthor Andy Leonard...
2013-05-07
866 reads
XML Support and SQL Server (Part 6)
Checkout the sixth part of my XML support and SQL Server article series here.
In this part, you will learn about...
2013-05-07
561 reads
2013 Carolina Code Camp Presentations
As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended...
2013-05-06
1,014 reads
A SQL Shirt Style For Any Occasion
Recently at work we had a “Hawaiian Shirt Day”, a nice change from the usual business casual. I picked one...
2013-05-06
588 reads
Donating for a little kid
One of my authors sent me this note:
“
I know you only know me as a writer for SQLServerCentral, but I...
2013-05-06
699 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