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 – Timestamp Column Writer #1, 2016-05-02 While this seems like a simple thing to do, I recently discovered so many ways not to do it (also known as failing) that I just had to document this one. Continue Reading