Tag Archives: failover clustering

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 – Cluster Queries

Get some clustered facts about your server.

PowerShell – Find Active Node On Cluster

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

Finding Active Node in SQL Server Cluster

The T-SQL method to find the active node that a SQL service is running on: SELECT SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) as ActiveNode