Extended Events Gets a New Home
One of the most versatile and awesome power tools given to SQL Server now has a new home! This new home will serve as a fabulous repository of extensive...
2020-05-18
2 reads
Blog Posts
I’m Speaking at #SQLSatBrisbane
I’ve always wanted to go to Australia, in fact we have a trip planned for Martin’s 60th birthday in a couple of years. But with all that’s happened in...
2020-05-18
61 reads
LANDMARK OF 1000 SUBSCRIBERS ACHIEVED. THANK YOU ALL FOR SUPPORT.
Thank you, everyone, to stay along with me on this journey. I started this blog for the self repository of SQL Server knowledge articles, Later I made it public...
2020-05-18
35 reads
Learner’s Guide to SQL Server Query Tuning
Following on from my Learner’s Guide to SQL Server Performance Triage, I’m tackling Query Tuning. In this guide, I’m experimenting with an outline style rather than expanding each paragraph....
2020-05-18 (first published: 2020-05-01)
1,002 reads
Negative (-) is an operator and will affect the order of operations.
An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 ... Continue reading
2020-05-18
414 reads
PASS Summit 2020 Precon Announcement
I am thrilled to announce that I have been accepted to deliver a preconference boot camp called ‘Amplify Your Virtual SQL Server Performance‘ at this year’s PASS Summit conference,...
2020-05-18
24 reads
Stairway to Microsoft Azure SQL Database Part 3 : Purchase Models DTU vs vCore continue
In the last post, we have discussed the DTU purchase model. Azure also provides another purchase mode which is called vCore. vCore purchase model available with all three deployment...
2020-05-17
10 reads
Azure DevOps Agent Job Names
I’ve been working with some complex builds lately, multi-stage ones, and I’ve been annoyed by the Azure DevOps agent. If you’re like me, you might see this in Agent...
2020-05-15 (first published: 2020-04-29)
336 reads
Clumio’s Rapid Recovery is amazing for SQL Server
Clumio’s Rapid Recovery is amazing, and you should know more about it. You might not have heard of Clumio before. Clumio is an upstart SaaS-based backup solution for both...
2020-05-15 (first published: 2020-04-30)
378 reads
Daily Coping 15 May 2020
I’ve 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-05-15
30 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