Q2 Goal Review
As we close out the Second Quarter of 2010 it is time to review progress made on the Goals I...
2010-07-06
522 reads
Scripting Linked Servers
A co-worked asked me to look at a T-SQL script I had written 8 years ago for scripting out linked...
2010-07-06
3,104 reads
Webcast Today – Performance Impacts Related to Different Function Types
I’ll be speaking for the SQL PASSPerformance Virtual Chapter later today starting at 12 PM Eastern time. The topic will...
2010-07-06
461 reads
Small PowerShell Script
I’m still trying to learn PowerShell better. The opportunity to answer simple questions and problems with the tool is hard...
2010-07-06
1,196 reads
Newest Pragmatic Works’ Team Book on Amazon
Check out our latest book on Amazon. It’s not for sales yet, but just seeing the title up there is...
2010-07-06
344 reads
Before You Begin Auditing...
There is a fine line between auditing and attacking. The line actually is one built based on authorization. Same tools,...
2010-07-06
959 reads
MDX Puzzle #3
The next puzzle comes from a BIDN.com forum post. Here are the requirements:
Columns: Internet Order Quantity and Percentage Of Total...
2010-07-06
524 reads
Tinkering with a local queue
I've been toying with the idea of using a file as a queue instead of a database table for use with my Enhanced Threading Framework. This has been challenging...
2010-07-06
11 reads
Tinkering with a local queue
I've been toying with the idea of using a file as a queue instead of a database table for use with my Enhanced Threading Framework. This has been challenging...
2010-07-06
17 reads
Tinkering with a local queue
I've been toying with the idea of using a file as a queue instead of a database table for use...
2010-07-06
489 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