DDL Trigger to log database level security commands.
In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in ... Continue reading
2021-07-05 (first published: 2021-06-24)
242 reads
Azure SQL Managed Instance Versions
Just a really quick FYI for the readers. If you are using Managed Instances in Azure (If not, why not?) and you connect vis SSMS (SQL Server Management Studio)...
2021-06-23
359 reads
A summary of new features in Azure SQL Database
It has been some time since I last wrote about Azure SQL Database. Although it has been more than three years since SQL Server 2017 was released, Microsoft have...
2021-06-23
60 reads
Daily Coping 23 Jun 2021
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...
2021-06-23
17 reads
P2 Puts Easy, Flexible Project Tracking Tools In Your Hands
Improve your team's workflow and productivity with these project tracking blocks.
2021-06-22
35 reads
Daily Coping 22 Jun 2021
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...
2021-06-22
16 reads
Why are my permissions missing?
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz ... Continue reading
2021-06-22
130 reads
Suggested Topics in Power Virtual Agents
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a guided, no-code graphical interface. In this video you will learn how
2021-07-07 (first published: 2021-06-22)
145 reads
Abuse, Patience, and Understanding
I’ve been struggling with an author for a few months. I tried to work throughs some issues, and I couldn’t get anywhere. This was very frustrating, and I spoke...
2021-06-21
199 reads
Daily Coping 21 Jun 2021
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...
2021-06-21
41 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