Running SQL Scripts Against Multiple Servers Using PowerShell

In this post I’m going to share a function I use run scripts against multiple instances of SQL servers and run the data into a GridView. I use this mainly for a replacement of the CMS feature of running against a folder and to put the output to a GridView that I can sort and filter any way I want which you can’t do in CMS.

The first function Get-CmsHosts was written by my colleague Mark Wilkinson (m82labs.com) to pull a pattern of hosts from your CMS server or your can pass an -InstanceList as a file or comma separate list.

Then I use PSSessions to run any query I specify and output to a GridView.

 

Tracy Boggiano
Follow me

Tracy Boggiano

Database Administrator at ChannelAdvisor
Tracy has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Platform. She has worked on SQL Server 6.5 and up including currently SQL 2017 CTP 2.0. She enjoys monitoring, performance tuning, and disaster recovery technologies.

She also tinkered with databases in middle school to keep her baseball card collection organized.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through http://www.casaforchildren.org.
Tracy Boggiano
Follow me