Just a quick note on a scenario I ran into, and what I did to…
Category: SQL Server
SQL Server Maintenance Plan Backups Failing On Secondary Replica in High Availability Environment
When a High Availability (HA) environment failed over, on the node that became Secondary, the…
TSQL – Make Excel Link In Output
Here is a situation I just came across (boiled down and simplified). An end user…
TSQL – Get All Queries Currently Running
This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in…
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?
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.
T-SQL – Get Currently Running Jobs With Duration
Query to get all currently running jobs with their run duration in seconds. Source: http://www.sanssql.com/2013/08/t-sql-query-to-find-currently-running.html…
Restore All Databases With Most Recent Backup
This is a bit of a scary task. Someone tells you about 87 databases that…
SQL Server – Database Stuck In Single User Mode
If you've painted yourself into the single_user corner, here is how you can get out.