failover clustering

2016-05-25

T-SQL – Get Listener Name on AlwaysOn Cluster

When using AlwaysOn, you must connect using your listener name, not your node name. If you connect with the node name, it will only work until there is a failover, which would defeat the purpose of your High Availability setup, right?

SQL Server

2016-03-24

SQL Server – Cluster Queries

Get some clustered facts about your server.

SQL Server

2016-03-20

PowerShell – Find Active Node On Cluster

PowerShell script that prints out the state of the node you are on – Active or Passive.

Powershell

2016-03-19

Finding Active Node in SQL Server Cluster

The T-SQL method to find the active node that a SQL service is running on: SELECT...

SQL Server

Archives

Recent Posts

failover clustering

T-SQL – Get Listener Name on AlwaysOn Cluster

SQL Server – Cluster Queries

PowerShell – Find Active Node On Cluster

Finding Active Node in SQL Server Cluster