Monthly Archives: January 2010

One of the frustrations of working with files in PowerShell is that you can’t append to a pre-existing CSV file. Dmitry has fixed that for version 2 by creating a proxy function that adds that capability. http://dmitrysotnikov.wordpress.com/2010/01/19/export-csv-append/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+DmitrysPowerblog+%28Dmitry%27s+PowerBlog%29 Excellent Technorati Tags: … Continue reading →

So far we have only created a single table but in a database with a number of tables we need to be able to view the table definitions. 001002003004005006007008009010011012013014015016 #### connect to database##$conn = New-Object -ComObject ADODB.Connection$mydb = "c:testtest03.mdb"$conn.Open("Provider = Microsoft.JET.OLEDB.4.0; Data Source = $mydb")$cat = New-Object -ComObject ADOX.Catalog$cat.ActiveConnection = $conn ## … Continue reading →

I was building some test machines yesterday and needed to add them to the domain. As they were Windows 2008 R2 with PowerShell v2 I decided to try Add-Computer. Add-Computer -DomainName mydomain -Credential mydomainmyaccount; restart-computer You will be prompted for … Continue reading →

We have seen how to add indexes. We also need to be able to remove them 001002003004005006007008009010011012013014015 function Remove-AccessIndex {# .ExternalHelp Maml-AccessFunctions.XML[CmdletBinding()]param (    [string]$table,    [string]$index,    [System.Data.OleDb.OleDbConnection]$connection)     $sql = "DROP INDEX $index ON $table"    Write-Debug $sql        $cmd = New-Object System.Data.OleDb.OleDbCommand($sql, $connection)    $cmd.ExecuteNonQuery()}   The function accepts connection plus table … Continue reading →