QueryLauncher

A PowerShell query launcher for SQL Server Data Warehouse

How to Install

I finally had the time to re-write this tool and it now takes only 20 lines of code, this thanks to:

Install-Module -Name dbatools

Install-Module -Name ImportExcel

Once you installed both you are good to go

How to use it

1) Paste a list of servers into the very first variable of the script:

# Put your list of SQL Server estate here
$SqlInstances = 'ServerName1','ServerName2','ServerName3'

2) Paste your SQL queries into the Queries folder. In the Queries folder you will find 10 queries which are the Glenn Berry’s Diagnostic Information Queries 2012; you can replace them with your preferred queries
3) Run QueryLauncer.ps1
4) QueryLauncher will run all queries one by one and will save the results in a file with server name and date. Each query output will be stored on a different Excel tab

Troubleshooting

If you have a query with the same column mentioned twice you will receive this error:

invoke-sqlcmd : Duplicate column names are not permitted in SQL PowerShell. To repeat a column, use a column alias for the duplicate column in the format Column_Name AS New_Name.
At C:\Users\FrancescoM\Desktop\CSV\QueryLauncher.ps1:30 char:15
+ ... $oresults = invoke-sqlcmd -ServerInstance $Server -Database $Database ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : SyntaxError: (:) [Invoke-Sqlcmd], SqlPowerShellSqlExecutionException
    + FullyQualifiedErrorId : DuplicateColumnNameErrorMessage,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

…so remove the duplicate columns

Future developent

On spare time my TODO list is:

• Error catch

Please if you have requests drop me a line