Recursively Querying Row Groups
Watch this week's video on YouTube
Recursively Querying Related Rows
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you...
2020-08-25
31 reads
Recursively Querying Row Groups
Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....
2020-09-02 (first published: 2020-08-25)
598 reads
Don’t Forget Unique with FILESTREAM–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. While testing FILSTREAM with SQL Clone the other...
2020-08-24
19 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! ...
2020-08-24
13 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! This course...
2020-08-24
13 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! This course...
2020-08-24
23 reads
Persist Sample Percent in SQL Server IS NOT PERSISTED!
Update: Sept 14, 2021 Persist sample percent is fixed. The fix is now rolled into SQL 2016 SP2 CU17, SQL 2019 CU10, and the future SQL 2017 CU26. When a bug...
2020-08-24
19 reads
Persist Sample Percent in SQL Server IS NOT PERSISTED!
When a bug jumps out and surprises me I like to share it so others do not run into the same unexpected result. I don’t think there is any...
2020-09-03 (first published: 2020-08-24)
862 reads
Daily Coping 24 Aug 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-24
23 reads
Cosmos DB for the SQL Professional – Referencing Tables
I had a previous blog comparing Cosmos DB to a relational database (see Understanding Cosmos DB coming from a relational world) and one topic that it did not address...
2020-09-07 (first published: 2020-08-24)
367 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