SQL Server 2025 Backup Compression Algorithm

Learn about the new ZSTD compression algorithm in SQL Server 2025.

Windows Clustered MSDTC and SQL Server 2019 mishap

Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each clustered SQL Server instance with its own Microsoft Distributed Transaction Coordinator (MSDTC) resource. Since SQL Server 2012 this advice has been withdrawn. Microsoft now recommends to provide your instance with its own MSDTC resource, once you notice the […]

Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events

Intro In 2008 I wrote an article called “Scope: The drastic caveat with Logon Triggers.” Ever since, we have been using Event Notifications to capture logins for our SQL Server instances. Issues were only very rare, usually on servers that had an extreme load of many connections. In such a case, we stopped this continuous monitoring and […]

Restoring Master on a Windows 2019 / SQL Server 2019 Cluster

Howto restore master database on a Clustered SQL Server 2019 Instance

Scripting SQL Server databases with SMO using EnforceScriptingOptions

Obscure impact of switch EnforceScriptingOptions to scripting a SQL Server database.

Instant File Initialization and restores

Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.

Me, myself and Powershell

Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.

Troubleshooting Service Broker (SSB)

Troubleshooting Service Broker (SSB)

Reset count for all alerts

To see the frequency of alerts in use, you can reset their fire count.
Restart count from zero for all alerts using the propre stored procedures.

SQL 2008 - SSMS