The PowerShell Bug That Wasn’t, and More Package Management

Have you ever tracked down a bug, been confident that you had found the root of your problems, only to realize shortly afterwords that you missed it completely? What I posted yesterday as a bug in PowerShell (having to do with recursive functions, dot-sourcing, and parameters) seemed during my debugging session to clearly be a …

Continue reading ‘The PowerShell Bug That Wasn’t, and More Package Management’ »

SQL PowerShell Extensions (SQLPSX) 2.0 Released

The first module-based release of the SQL PowerShell Extensions (SQLPSX) was released recently on CodePlex.  It features very handy wrappers for most of the SMO objects used to manipulate SQL Server metadata, SSIS packages, Replication, and (new in the 2.0 release) an ADO.NET module which I wrote based on the code in this post.  There’s …

Continue reading ‘SQL PowerShell Extensions (SQLPSX) 2.0 Released’ »

PowerShell Tools and Books That I Use

Tools I Use (note…these are all free!): PowerGUI Script Editor (I haven’t ever gotten the hang of PowerGUI itself) Powershell Community Extensions 1.2  (PSCX) PowerTab SQL PowerShell Extensions 1.61 (SQLPSX) PrimalForms Community Edition Books: PowerShell In Action by Bruce Payette Professional Windows PowerShell Programming: Snapins, Cmdlets, Hosts and Providers by  Arul Kumaravel et. al. Mastering …

Continue reading ‘PowerShell Tools and Books That I Use’ »