sp_who2 Alternative (T-SQL, SQL Server) Writer #1, 2018-05-012024-03-10 The trusty "sp_who2" is a quick way to look at what’s happening on your SQL… Continue Reading
Discover How User Is Accessing SQL Instance (PowerShell and T-SQL) Writer #1, 2018-04-302023-06-23 When your security gets unruly, it can get time consuming to figure out how a… Continue Reading
TSQL – Make Excel Link In Output Writer #1, 2016-08-042024-08-31 Here is a situation I just came across (boiled down and simplified). An end user… Continue Reading
TSQL – Get All Queries Currently Running Writer #1, 2016-08-042024-08-31 This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in… Continue Reading
T-SQL – Get Listener Name on AlwaysOn Cluster Writer #1, 2016-05-252024-08-31 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? Continue Reading
T-SQL – Get Currently Running Jobs With Duration Writer #1, 2016-04-14 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… Continue Reading
Restore All Databases With Most Recent Backup Writer #1, 2016-04-14 This is a bit of a scary task. Someone tells you about 87 databases that… Continue Reading
SQL Server – Cluster Queries Writer #1, 2016-03-24 Get some clustered facts about your server. Continue Reading
SQL Server – All Objects On Instance Sorted By Date Writer #1, 2016-03-20 One common question I hear whenever something begins to go wrong is, “Has anything been… Continue Reading
Validate SQL Code Without Running It Writer #1, 2016-03-19 Validate SQL Code Without Running It In a nutshell: SET NOEXEC ON; — The script… Continue Reading