alzdba

  • Interests: family, mantrailing / dogs, riding my motorbike, volleyball

SQLServerCentral Article

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 […]

5 (3)

You rated this post out of 5. Change rating

2025-04-04

2,019 reads

SQLServerCentral Article

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 […]

5 (5)

You rated this post out of 5. Change rating

2021-10-29

4,517 reads

Blogs

Secret management using Pulumi ESC SDK and Azure Key Vault

By

This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What...

The Book of Redgate–Being Reasonable

By

As a part of the Book of Redgate, we have a series of (red,...

Azure Data Factory Pipeline Debugging Fails with BadRequest

By

I recently had a new pipeline fail. It was actually a copy of an...

Read the latest Blogs

Forums

The User Login

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The User Login

Using Feature Flags

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using Feature Flags

Understanding UNION and UNION ALL in SQL Server

By omu

Comments posted to this topic are about the item Understanding UNION and UNION ALL...

Visit the forum

Question of the Day

The User Login

When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?

See possible answers