If you’ve ever had to implement Change Data Capture (CDC) for a database in an Availability Group, then you know that the CDC jobs don’t really consider the Availability...
2022-02-03
134 reads
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-02-02
76 reads
Checkpoints are essential in SQL Server to help with the durability and reliability of data persisted in the database. When done right, you barely even notice them and performance...
2022-02-02 (first published: 2022-01-14)
512 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...
2022-02-02
8 reads
(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held...
2022-02-02
56 reads
Well, it’s a new year and a new start, even if I am a bit behind the start of the ... Continue reading
2022-02-02
Well back at the end of 2019 I finished writing most of the checks related to the CIS Center for Internet Security requirements. I have yet to write a...
2022-02-02 (first published: 2022-01-21)
2,167 reads
Kerberos delegation is not a new concept in Active Directory; however, setting it up for Group Managed Service Accounts (gMSA) can be a bit confusing. Unlike normal domain accounts,...
2022-02-01
655 reads
Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.
2022-02-01
175 reads
It is time for T-SQL Tuesday #147 and this month I get to be the host. Since I’m in charge, I usually try to ensure I remember what this...
2022-02-01
20 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers