Tally Table CTE
Now that I have several posts on what you can do with a Tally table, I figured I'd share my...
2010-03-19
5,154 reads
Windows Themes (We need a PASS Theme!)
I imagine most of us change our wallpaper on the desktop from time to time. Frivolous but fun, a simple...
2010-03-19
868 reads
Losing Two Days
I’m off tomorrow to the UK for a week of work at the Red Gate offices, and then a couple...
2010-03-19
657 reads
Be Wary
We make mistakes when we publish things. It happens, and I am as guilty as some people of mistakenly putting...
2010-03-19
921 reads
Need to Persuade Your Manager or Co-Worker to Your Point of View?
At one time or another, each of us has been in a position where we need to persuade a manager,...
2010-03-18
564 reads
Want to Learn More About How to Master Microsoft Technologies?
If you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This...
2010-03-18
1,435 reads
Script: Backup All your Databases
We all know the importance of taking regular backups of our SQL Server databases. This is a useful little script...
2010-03-18
1,722 reads
The Coming Upgrade Tidal Wave
Microsoft is poised to release new versions of several different products and technologies that have the potential to have a...
2010-03-18
722 reads
Undocumented Virtual Column: %%lockres%
One of my development teams needed a mechanism for identifying the value of a key that was part of a...
2010-03-18
4,672 reads
This is Dumb - eBooks
Amazon v Apple, both pressuring publishers on ebook concessions. It’s big business, and it could easily be good or bad...
2010-03-18
947 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