A Small Collection of DBCC Commands
There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a...
2010-08-02
1,990 reads
PASS Update #40 (Elections)
Last week I made it through the first screening of candidates for this years Board of Directors election. Seven of...
2010-08-02
355 reads
SQLSaturday #40 – South Florida Recap
I had the great privilege to be able to attend and speak at SQLSaturday #40 – South Florida this past weekend...
2010-08-02
654 reads
SQL Saturday #28 - Two Weeks Away
It’s a little less than two weeks until SQL Saturday #52 in Baton Rouge. I attended last year, and thoroughly...
2010-08-02
359 reads
SQL Saturday 28 Baton Rouge and Ask the Experts
The second annual SQL Saturday Baton Rouge event is coming up in less than two weeks! Have you registered?
I’m honored...
2010-08-02
609 reads
What Are You Afraid to Ask?
There are some questions that can’t necessarily be answered in a book or a training video. Those are often the...
2010-08-02
600 reads
MDX Puzzle #5
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. ...
2010-08-01
553 reads
A Milestone
I just passed 100,000 views on the blog. That’s from 400 posts over a period of time starting in March...
2010-08-01
661 reads
Moving to a New Blog Platform
Moving to a New Blog Platform
First, I want to say that having my blog on SQL Server Central has been...
2010-08-01
1,023 reads
Like a Phoenix rising from the ashes ...
NOTE: At least one project will be selected every week for the remainder of 2010. Like the Phoenix rising from...
2010-07-31
1,436 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