Live Learning at the SQL Server and Azure SQL Conference–Dec 2021
It’s been a long two years for most of us, with little or no training budget being spent on us at conferences. Online events are convenient and accessible, but...
2021-11-03
53 reads
Microsoft Ignite Announcements Nov 2021
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...
2021-11-03
10 reads
Microsoft Ignite Announcements Nov 2021
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...
2021-11-12 (first published: 2021-11-03)
423 reads
Daily Coping 3 Nov 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-11-03
21 reads
SQL Server 2022 announced
SQL Server 2022 was announced yesterday at Microsoft Ignite, and it’s going to be a big one. Building on a lot of work in the Azure SQL space, SQL...
2021-11-03
106 reads
Which Processes are waiting on a Spinlock?
Spinlock contention is always a real headache to deal with. I recently saw an issue when spinlock contention on SOS_CACHESTORE was making the server virtually unresponsive. The issue was...
2021-11-15 (first published: 2021-11-03)
311 reads
Memories from SQL Saturday Orlando 2021
A few memories from this past weekend, during the first live SQL Saturday event in the US this year. I’ve had plenty of plane flights this year, actually this...
2021-11-02
41 reads
Daily Coping 2 Nov 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-11-02
15 reads
SQL Homework – November 2021 – Backup, restore, and move the system databases?
On any instance you have at least 5 system databases. Master, model, msdb, tempdb and one other. First 5 points ... Continue reading
2021-11-15 (first published: 2021-11-02)
390 reads
Skirmishes with automated deployment of Azure Data Factory
When it comes to Azure Data Factory deployment, I always have a few words to say. You might be aware that there are two approaches in this terms. I...
2021-11-01
13 reads
Blogs
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...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
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