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.
Generate Red Gate MultiScript .dat File
This is a PowerShell script that puts out the XML required to update your Red…
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…
PowerShell – List All Directories With Users Who Can Access
Maybe this is a one-off type of thing, but if you need to see every…