Failover Clustered Instance (FCI)

SQLServerCentral Article

How to Add a New Shared Disk to a WSFC as a SQL Resource

  • Article

Adding a new shared disk to Windows Server failover Cluster is not a complex process but special care must be taken when you want to use the new disk for any existing SQL Instance. In this article, we will show you all the required steps to add the disk to WSFC and then to properly assign it to an existing SQL role in the WSFC.

5 (1)

You rated this post out of 5. Change rating

2024-09-16

988 reads

SQLServerCentral Article

Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)

  • Article

Setting up High Availability in SQL server has some prerequisites. One of these is that the database servers must be members of the same Windows Server Failover Cluster. In this article I show how to succesfully set up WSFC and activate Cluster Aware Updating

5 (1)

You rated this post out of 5. Change rating

2024-06-28

3,465 reads

SQLServerCentral Article

Configuring Availability Groups in Ubuntu

  • Article

In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]

5 (2)

You rated this post out of 5. Change rating

2020-08-25

3,445 reads

Blogs

A New Word: Tangency

By

tangency– n.  a fleeting glimpse of what might have been. I tend to live...

Join me at the Microsoft Fabric Community Conference with a discount code

By

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...

Is Your Business Truly Ready for AI?

By

The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...

Read the latest Blogs

Forums

Several Questions: Relationships and SSMS and Data Diagrams

By Ahr Aitch

I'm struggling setting relationships among tables.  I understand the one-to-many, many-to-one, many-to-many, and self-referential...

Query Help to show record in single row

By sqldba20

Hi All, need help with an SQL query. We have an existing table that's...

MSDTC not available on Windows 2022 clustered SQL 2019 CU30

By Johan Bijnens

I connect to this clustered instance and run : begin distributed transaction Msg 8501,...

Visit the forum

Question of the Day

Counting Bits III

What is the output of this code in SQL Server 2022?

select bit_count(0xEF)

See possible answers