PowerShell – Get All SQL Instances On Server Writer #1, 2016-04-27 This script will return all SQL instances running on a server or list of servers…. Continue Reading
PowerShell – Get “Logon As” Information From Remote (or local) Server Writer #1, 2016-04-20 This was made possible by the Scripting Guy. I have boiled it down to the… 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
PowerShell – List All Directories With Users Who Can Access Writer #1, 2016-04-08 Maybe this is a one-off type of thing, but if you need to see every… Continue Reading