# invoke sql cmd
[System.Reflection.Assembly]::LoadWithPartialName("System.Data") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("System.Data.SqlClient") | Out-Null

function Invoke-SqlcmdCustom {
	[CmdletBinding()]
	Param(
		[parameter(Mandatory=$false)]
		[string]$ServerInstance,
		[parameter(Mandatory=$false)]
		[string]$Database,
		[parameter(Mandatory=$false)]
		[string]$Query
	)
	$connstr = "Server=$($ServerInstance);Database=$($Database);Trusted_Connection=True;"
	$conn = new-object System.Data.SqlClient.SqlConnection($connstr)
	$conn.Open()
	$cmd = new-object  System.Data.SqlClient.SqlCommand($Query, $conn)
	$dt = new-object System.Data.DataTable
	$dt.Load($cmd.ExecuteReader())
	$cmd.Dispose()
	$conn.Close()
	$conn.Dispose()
return $dt.Rows
}