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?
Month: May 2016
PowerShell – Check If Module Is Loaded
This is how to check if a particular module is loaded, and if it’s not…
SQL Server – Timestamp Column
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.