Invoke-SQL.ps1

function Invoke-SQL {
	param(
		[Parameter(Mandatory = $true)]
		[string]$DataSource,
		[Parameter(Mandatory = $true)]
		[string]$Database,
		[Parameter(Mandatory = $true)]
		[string]$SqlCommand,
		[Parameter(Mandatory = $false)]
		[switch]$Scalar
	)

	begin {
		$connectionString = "Data Source=$DataSource;Integrated Security=SSPI;Initial Catalog=$Database"

		$connection = New-object System.Data.SqlClient.SQLConnection($connectionString)
		$command = New-object System.Data.SqlClient.SqlCommand($SqlCommand, $connection)
		$connection.Open()
	}
	process {

		if ($Scalar) {
			$command.ExecuteScalar()
		}
		else {
			$adapter = New-Object System.Data.SqlClient.SqlDataAdapter $command
			$dataset = New-Object System.Data.DataSet
			$adapter.Fill($dataSet) | Out-Null
			$dataSet
		}
	}
	end {
		$connection.Close()
	}
}