You are here

Monthly archive

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?

PowerShell - Check If Module Is Loaded

This is how to check if a particular module is loaded, and if it's not then load it. SQLPS is the module used in the example, but you can replace that with any module name.

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.

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
1 + 17 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer