Powershell PowerShell With Uptime – Getting Days Only benjf.com.blog@benjf.com, 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) benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 2016-08-04 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 benjf.com.blog@benjf.com, 2016-08-04 Creating and writing to output file in PowerShell. https://gist.github.com/benf101/379e8040393a24771af81360ee0111ab Continue Reading
Generate Red Gate MultiScript .dat File benjf.com.blog@benjf.com, 2016-07-14 This is a PowerShell script that puts out the XML required to update your Red… Continue Reading
PowerShell – Get All SQL Instances On Server benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 2016-04-08 Maybe this is a one-off type of thing, but if you need to see every… Continue Reading