The trusty "sp_who2" is a quick way to look at what’s happening on your SQL…
Tag: TSQL
Discover How User Is Accessing SQL Instance (PowerShell and T-SQL)
When your security gets unruly, it can get time consuming to figure out how a…
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?
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 – All Objects On Instance Sorted By Date
One common question I hear whenever something begins to go wrong is, “Has anything been…
Validate SQL Code Without Running It
Validate SQL Code Without Running It In a nutshell: SET NOEXEC ON; — The script…