Execute query with SqlCmd variables and save SQL Server execution plan example

get-plan-example.ps1

$SqlCmdVariables = "DatabaseName=master", "ColumnName=name";
$Results = (Invoke-Sqlcmd -ServerInstance "localhost\sql2017" -Query "SET STATISTICS XML ON; SELECT `$(ColumnName) FROM sys.databases WHERE [name] = '`$(DataBaseName)';" -Variable $SqlCmdVariables -MaxCharLength 10MB);
$Plan = [xml]$Results[$Results.GetUpperBound(0)].Item(0);
$Plan.Save("C:\temp\test.sqlplan");