T-SQL – Get Listener Name on AlwaysOn Cluster Writer #1, 2016-05-252024-08-31 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? Continue Reading
SQL Server – Cluster Queries Writer #1, 2016-03-24 Get some clustered facts about your server. Continue Reading
PowerShell – Find Active Node On Cluster Writer #1, 2016-03-20 PowerShell script that prints out the state of the node you are on – Active or Passive. Continue Reading
Finding Active Node in SQL Server Cluster Writer #1, 2016-03-19 The T-SQL method to find the active node that a SQL service is running on:… Continue Reading