T-SQL – Get Listener Name on AlwaysOn Cluster benjf.com.blog@benjf.com, 2016-05-25 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 benjf.com.blog@benjf.com, 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