The merry-go-round scan or advanced scan is something that I’ve seen mentioned a few times recently and it’s a lovely little feature of Enterprise Edition that not all that...
2020-09-23 (first published: 2020-09-16)
239 reads
When it comes to database backups for IaaS based Azure SQL Servers you have 3 options. Automated Backups, both V1 and V2 depending on the SQL Server version. Azure...
2020-09-16
27 reads
I was lucky enough to go to the Data Platform Summit in 2017. I still have one of my favorite speaking pictures from the event: I took my whole...
2020-09-15
26 reads
It is Tuesday!! Time for Part 3 in the series about SQL Server Agent Job Failures. This installment will show you how to setup SQL Agent Alerts and Operators...
2020-09-22 (first published: 2020-09-15)
316 reads
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-09-15
9 reads
One of the few good, safe uses for the local SSD D: volume of an Azure VM is for SQL Server TempDB data and log files. There's a gotcha....
2020-09-21 (first published: 2020-09-14)
487 reads
Recently someone asked a good question about SQL Data Compare. How can they add applicationintent to the connection? If you are using Data Compare, and you are reading from...
2020-09-22 (first published: 2020-09-14)
217 reads
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-09-14
20 reads
(2020-Sep-13) Array of arrays, in a JSON world, it’s a very common concept to have a set of sets of other elements in a dataset. Despite how strange it may...
2020-09-21 (first published: 2020-09-14)
16,354 reads
2020-09-13
9 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
WA CS 08218154392 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl....
WA CS 08218154392 Jl. Jend. Ahmad Yani No.169, Watampone, Kec. Tanete Riattang Bar., Kabupaten...
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
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