Cross Database RI Issues
I had an issue with a user recently. Actually it has been going on over a few weeks, due to...
2010-02-23
962 reads
Why Do I Need All These Servers?
Introduction
I am frequently getting requests for a new server to do this or that. Running through the usual questions to...
2010-02-23
472 reads
Why All The Fuzz?
I really must thank Steve for his editorial on FizzBuzz. It seemed like a really good topic to do some...
2010-02-23
791 reads
Power Plans and Windows Server 2008 R2
After seeing an interesting blog post on AnandTech IT last week that showed slower query response time in x64 SQL...
2010-02-22
3,454 reads
SQL Server 2008 - Adding Row Totals
During a recent client engagement I was asked if there was a quick way to add a row containing totals...
2010-02-22
738 reads
Free Webinar Series This Week
If you haven’t heard already this week there is a great free webinar series going on that’s meant for beginners. ...
2010-02-22
629 reads
It will happen on a spring day in May...
"The world's favorite season is the spring. All things seem possible in May." - Edwin Way Teale This spring, the Portland,...
2010-02-22
463 reads
IgnoreUnrelatedDimensions in Analysis Services 2008
Once of the more common issues with working with data in a cube is that it does not always line...
2010-02-22
466 reads
Basic SQL Querying From PowerShell
I promise to make this worth your time. (Oops, I better make this quick.)
Alright so with PowerShell if you open...
2010-02-22
1,282 reads
Christmas Holiday
We booked a vacation over the weekend, so I’m marking off the week before Christmas as vacation this year. Hoping...
2010-02-22
933 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