Powershell script to demo Jorge's (@sqlchicken) Problem

Get-Rows.ps1

$cn = New-Object System.Data.SqlClient.SqlConnection 'Data Source=.;Initial Catalog=master;Integrated Security=SSPI;';
$cn.Open();
$cmd = $cn.CreateCommand()
$cmd.CommandText="SELECT * FROM sys.tables"
$rdr = $cmd.ExecuteReader();

$dt = New-Object System.Data.DataTable;
$dt.Load($rdr);

$dt.Rows | Format-Table;

$dt.Dispose();
$rdr.Dispose()
$cmd.Dispose();
$cn.Dispose();