Connecting to a MSSQL db and doing a simple query

ps-mssql-sample.ps1

$sqlConn = New-Object System.Data.SqlClient.SqlConnection
$sqlConn.ConnectionString = 'Server=192.168.244.129;Initial Catalog=dbname;User Id=sqltest;Password=test123'
$sqlConn.Open()

$sqlcmd = $sqlConn.CreateCommand()
#$query = “SELECT name, database_id FROM sys.databases”
$query = “SELECT * from dbname"
$sqlcmd.CommandText = $query

$adp = New-Object System.Data.SqlClient.SqlDataAdapter $sqlcmd
$data = New-Object System.Data.DataSet 
$adp.Fill($data) | Out-Null 
$data.Tables.GetEnumerator() | % { $_ | ConvertTo-Csv }
$sqlConn.close()