Run SQL from Powershell

run-sqlcommand.ps1

function Run-SqlCommand($serverName, $databaseName, $command, $timeoutSeconds = 30) {
    $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
    $SqlConnection.ConnectionString = "Server=$serverName;Database=$databaseName;Integrated Security=True"
    $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
    $SqlCmd.CommandText = $command
    $SqlCmd.Connection = $SqlConnection
    $SqlCmd.CommandTimeout = $timeoutSeconds
    $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
    $SqlAdapter.SelectCommand = $SqlCmd
    $DataSet = New-Object System.Data.DataSet
    $SqlAdapter.Fill($DataSet)
    $SqlConnection.Close()
}