Articles

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 (4)

You rated this post out of 5. Change rating

2025-04-04

2,845 reads

External Article

Basic Regex Emulator for SQL Server

Regular expressions (REGEX) let you adaptively investigate, employ, and authenticate text data. This makes it easy to search for simple or complex string patters. There is no direct way to do this in SQL Server, but in this article we look at some SQL functions you can create to emulate regex like functionality.

2025-03-28

External Article

Beyond Single-Cloud: A Peek into Multi-Cloud

The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology to how to effectively use it to drive business growth and innovation. Having recognized the power of the cloud in terms of agility, scalability and innovation, organizations are turning their focus to how to get more from their investment. One such consideration is multi-cloud.

2025-03-26

Blogs

SQL Server 2025 Unleashed Live Training – A New Era Begins

By

I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on...

Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition

By

In my previous post, I showed you how to build a snapshot backup catalog...

Advice I Like: Training Employees

By

Train employees well enough that they could get another job but treat them well...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Connecting to SQL express 2019 server

By waltthrombey

Hello, Our old server is on its last legs, and I'm transitioning to a...

Docker Advice for SQL Server in Production

By Vincent92

Comments posted to this topic are about the item Docker Advice for SQL Server...

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers