Powershell PowerShell With Uptime – Getting Days Only Writer #1, 2019-10-18 There is a handy and free tool to check your system’s uptime called “Uptime”. (Clever, no?) It… 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
Powershell PowerShell With Uptime – Getting Days Only Writer #1, 2017-12-16 There is a handy and free tool to check your system's uptime called "Uptime". (Clever, no?) It… Continue Reading
Powershell PowerShell – Update All SQL Services To Restart On Failure Writer #1, 2016-08-042024-08-31 PowerShell script to quickly change all Recovery Options to “Restart the Service”. https://gist.github.com/benf101/a3c7020c0a582aca06059b750bd08528 Continue Reading
PowerShell – Create And Write Out To Log File Writer #1, 2016-08-042024-07-14 Creating and writing to output file in PowerShell. Continue Reading
Generate Red Gate MultiScript .dat File Writer #1, 2016-07-142024-08-31 This is a PowerShell script that puts out the XML required to update your Red… Continue Reading
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
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