My Application to the PASS Board
The application form mentions that the quite a bit of what you include will be made public. While I won’t...
2010-07-20
711 reads
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-20
1,140 reads
Free SQL Server DMV Starter Pack
The SQL Server DMV Starter Pack is a free eBook (84 pages) that describes 28 different ways that DMVs can...
2010-07-20
4,905 reads
Increasing or Decreasing Sampling Size in SSAS Data Source View Data Explorer
Recently, I have begun my quest of mastering SSAS. I realize that it may take time and I am more...
2010-07-19
512 reads
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-19
3,965 reads
Creating UDL Files On The Fly
Many years ago, in the dark ages of DTS I created a little app that would take two parameters and...
2010-07-19
660 reads
Finding Your Next Job
We’ve had a few people in the SQL community find jobs lately and many of them attributable to their network....
2010-07-19
522 reads
How to Deal with Quebec’s Extremists: Expose Their Malfeasance Publicly?
NB - to my regular blog readers, excuse the tangent here, but the local provincial extremists attempted something in my 'hood...
2010-07-19
6,761 reads
I Did It - PASS Nomination Application
I send my board of directors nomination application to PASS and asked for a confirmation. I always worry that something...
2010-07-19
675 reads
SQL University: Introduction to Indexes, Part the First
Right, all eldritch tomes are to be closed and Elder Signs are to be put away during this course.
Welcome to...
2010-07-19
758 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
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