Very basic Powershell script to execute a SQL Query and show the result in a GridView

Invoke-SQLCmd.ps1

function Invoke-SQLCmd {
    param(
        [Parameter(Mandatory=$True)]
        [string] $Server,
        [Parameter(Mandatory=$True)]
        [string] $Database,
        [Parameter(Mandatory=$True)]
        [string] $Query
    );

    $con = New-Object System.Data.SqlClient.SqlConnection($('Server = {0}; Database = {1}; Integrated Security = True;' -f $Server, $Database));
    $con.Open();
    $command = New-Object System.Data.SqlClient.SqlCommand($Query, $con);
    $datatable = New-Object System.Data.DataTable;
    $adapter = New-Object System.Data.SqlClient.SqlDataAdapter;
    $adapter.SelectCommand = $command;
    $adapter.Fill($datatable) | Out-Null;
    $con.Close();
    return $datatable;

}

$server = 'example.com';
$db = 'master';
$query = "SELECT * FROM sys.databases;";
Invoke-SQLCmd -Server $server -Database $db -Query $query | Out-GridView;