There is a handy and free tool to check your system’s uptime called “Uptime”. (Clever, no?) It…
Tag: powershell
Discover How User Is Accessing SQL Instance (PowerShell and T-SQL)
When your security gets unruly, it can get time consuming to figure out how a…
Powershell
Continue Reading
PowerShell With Uptime – Getting Days Only
There is a handy and free tool to check your system's uptime called "Uptime". (Clever, no?) It…
Powershell
Continue Reading
PowerShell – Update All SQL Services To Restart On Failure
PowerShell script to quickly change all Recovery Options to “Restart the Service”. https://gist.github.com/benf101/a3c7020c0a582aca06059b750bd08528
PowerShell – Create And Write Out To Log File
Creating and writing to output file in PowerShell. https://gist.github.com/benf101/379e8040393a24771af81360ee0111ab
Generate Red Gate MultiScript .dat File
This is a PowerShell script that puts out the XML required to update your Red…
PowerShell – Check If Module Is Loaded
This is how to check if a particular module is loaded, and if it’s not…
PowerShell – Get All SQL Instances On Server
This script will return all SQL instances running on a server or list of servers….
PowerShell – Get “Logon As” Information From Remote (or local) Server
This was made possible by the Scripting Guy. I have boiled it down to the…
Restore All Databases With Most Recent Backup
This is a bit of a scary task. Someone tells you about 87 databases that…