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
PowerShell – Getting All Running SQL Services Writer #1, 2016-03-23 Getting all SQL Server services running on a server using PowerShell: Get-WmiObject -Class sqlservice -Namespace… Continue Reading
PowerShell – Making Arrays Writer #1, 2016-03-23 The basics of creating a PowerShell array and working with it. Continue Reading
PowerShell – Find Active Node On Cluster Writer #1, 2016-03-20 PowerShell script that prints out the state of the node you are on – Active or Passive. Continue Reading
PowerShell – Query Database Remotely Writer #1, 2016-03-18 The basic syntax for sending a query to SQL Server using PowerShell. sqlcmd -S SERVER_NAME… Continue Reading