Do You Really Need HA?

Steve asks the question about whether or not a particular environment really needs HA implemented.

SQL Server 2022 Clusterless Distributed Availability Group

This article shows the final step of an availability group creation, specifically for a distributed clusterless one.

Removing Log Shipping

The Monitor Server

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

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

The Secondary Database Name in an AG

Troubleshoot SQL Server Always On Availability Groups with SQL LogScout

We experienced several unplanned outages and failovers on our SQL Server Always On Availability Groups. We want to know the root cause to prevent them from happening in the future. How do we identify the root causes of unplanned Availability Group outages and failovers?

Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster - Part 3

I used the guide in a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1 to install a SQL Server 2008 on a Windows Server 2008 failover cluster (WSFC). Now, I would like to upgrade and migrate my SQL Server 2008 failover clusters to SQL Server 2022 running on Windows Server 2022. What is the process for installation and configuration?

Understanding Windows Server Cluster Quorum Options

If you're deploying SQL Server, you are likely running business-critical applications on it and you need to ensure it's protected from downtime and data loss.

Three Mile Island And Your Databases

Grant takes a few lessons for database DR from a nuclear accident in the US.