Convert Several Columns in SSIS With Fewer Clicks and Confusion
I've had this one in my toolbox for a while now, decided to publish it on CodePlex a while back,...
2010-08-30
718 reads
Testing for NULLS in a Dataset Filter
Some seemingly simple filtering logic can be more difficult to achieve when using
a dataset filter rather than the WHERE clause...
2010-08-30
623 reads
PASS Update #42
Our most recent board meeting was in Nashville on Aug 19, 20. We had originally discussed meeting in Seattle/Redmond/Vancouver, but...
2010-08-30
972 reads
NetFlix and Null
There are some progressive companies out there, and I think they are doing some very interesting things with how they...
2010-08-30
1,569 reads
MDX Puzzle #7
I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up...
2010-08-29
478 reads
Dynamic SQL and Cached Query Plans
Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using...
2010-08-29
610 reads
Restarting SQL Server using a Batch Script
In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of...
2010-08-29
13,343 reads
Restarting SQL Server using the GUI
Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...
2010-08-29
489 reads
Jax Code Camp - My Presentation and Projects
First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due...
2010-08-28
424 reads
Microsoft Offers New Certification Exam Discount
If you are intending to take any Microsoft Certification tests soon, you are in luck, because Microsoft has recently introduced...
2010-08-28
1,270 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