SQL Server

TSQL – Make Excel Link In Output

August 4, 2016 | 0 Comments

Here is a situation I just came across (boiled down and simplified).  An end user was having to manually find a user id, navigate to an image folder, and [...]

TSQL – Get All Queries Currently Running

August 4, 2016 | 0 Comments

This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in action ebook. The output shows the spid (process identifier), the ecid (this [...]

T-SQL – Get Listener Name on AlwaysOn Cluster

May 25, 2016 | 0 Comments

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?

[...]

SQL Server – Timestamp Column

May 2, 2016 | 0 Comments

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.

[...]
1 2 3 4 5