2016-07-14
Generate Red Gate MultiScript .dat File
This is a PowerShell script that puts out the XML required to update your Red Gate...
Powershell
2016-04-27
PowerShell – Get All SQL Instances On Server
This script will return all SQL instances running on a server or list of servers. cls...
2016-04-20
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 answer....
2016-04-14
Restore All Databases With Most Recent Backup
This is a bit of a scary task. Someone tells you about 87 databases that all...
2016-04-08
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 folder...
2016-03-23
PowerShell – Getting All Running SQL Services
Getting all SQL Server services running on a server using PowerShell: Get-WmiObject -Class sqlservice -Namespace “ROOT\Microsoft\SqlServer\ComputerManagement11″...
2016-03-23
2016-03-20
PowerShell – Find Active Node On Cluster
PowerShell script that prints out the state of the node you are on – Active or Passive.
2016-03-18
PowerShell – Query Database Remotely
The basic syntax for sending a query to SQL Server using PowerShell. sqlcmd -S SERVER_NAME -d...
2016-03-18