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
SQL Server – Database Stuck In Single User Mode Writer #1, 2016-03-29 If you've painted yourself into the single_user corner, here is how you can get out. Continue Reading
SQL Server – Cluster Queries Writer #1, 2016-03-24 Get some clustered facts about your server. Continue Reading
SQL Server – Getting All SQL Services Running On System Writer #1, 2016-03-23 Getting all services running SQL Server using T-SQL: SELECT * FROM sys.dm_server_services Continue Reading
PowerShell – Getting All Running SQL Services Writer #1, 2016-03-23 Getting all SQL Server services running on a server using PowerShell: Get-WmiObject -Class sqlservice -Namespace… Continue Reading
PowerShell – Making Arrays Writer #1, 2016-03-23 The basics of creating a PowerShell array and working with it. Continue Reading
PowerShell – Find Active Node On Cluster Writer #1, 2016-03-20 PowerShell script that prints out the state of the node you are on – Active or Passive. Continue Reading