Synapse Analytics and .NET for Apache Spark Example 4 - JOINS
This is a bit of a longer one, a look at how to do all the different joins and the exciting thing for MSSQL developers is that we get...
2021-02-05 (first published: 2021-01-25)
159 reads
Recovering Data from a Backup with SQL Data Compare
I had a customer recently ask about how to recover data from a backup file. I believe the request was for SQL Backup, but I knew there was another...
2021-02-02 (first published: 2021-01-25)
309 reads
Data Lakehouse defined
As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk about the various definitions I am seeing about what a data lakehouse is, including a...
2021-01-25
11 reads
Data Lakehouse defined
As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk about the various definitions I am seeing about what a data lakehouse is, including a...
2021-02-02 (first published: 2021-01-25)
603 reads
SELECT * Hurts Performance, Badly
Quite a few years ago, I wrote a post about SELECT * and performance. That post had a bit of a click-bait title (freely admitted). I wrote the post...
2021-02-01 (first published: 2021-01-25)
698 reads
Daily Coping 25 Jan 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-01-25
24 reads
Upgrading Ola Hallengren’s Maintenance Solution with dbatools
While presenting Backup Basics with Powershell and dbatools at ONDT, I mentioned a caveat with the -ReplaceExisting switch for Install-DbaMaintenanceSolution. This switch drops all of the objects installed by...
2021-01-25
199 reads
Speaking about Latches & Spinlocks at the EightKB Online Conference
This Wednesday I have the pleasure to speak about Latches, Spinlocks, and Latch Free Data Structures at the EightKB Online Conference. This year they are expecting more than 1500 attendees and...
2021-01-25
5 reads
Speaking about Latches & Spinlocks at the EightKB Online Conference
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-01-25
4 reads
Speaking about Latches & Spinlocks at the EightKB Online Conference
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-01-25
3 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