Monthly Archives: October 2008

PowerScripting Podcast

I did an interview,  Episode 46 – SQL PSX. at the PowerScripting Podcast show discussing:   Powershell adoption and deployment at my company My day-to-day usage Powershell My thoughts on the SQL Server 2008 Powershell host (see this blog post for a more … Continue reading

Posted in PowerShell

Microsoft SQLPS Review

There have been several blog entries which about Microsoft’s sqlps.exe, the PowerShell host provided with SQL Server 2008, most of which have centered around the SQL Server product teams’ decision to implement a closed shell. It would seem after much negative … Continue reading

Posted in PowerShell

Tampa Bay SQL User Group Presentation Oct 21 2008

Presentation and supporting scripts from the Tampa Bay SQL User Group Presentation on RSS Reporter for SQL Server. This was a short 15 minute talk on RSS Reporter from xSQL Software. If you’re a member of the Tampabay SQL Server … Continue reading

Posted in RSS

sqlps.exe, the ShellId and Closed Shells

Jaykul at huddledmasses has an interesting post on Is PowerShell $ShellId too big a burden? which explains why sqlps.exe, the PowerShell host provided by Microsoft in SQL Server 2008, is a closed shell and lacks support for Add-PSSnapin. To see the shellid run $shellid … Continue reading

Posted in PowerShell

SQLServerCentral SQLPSX Articles

I wrote a two part article on SQL Server PowerShell Extensiosn (SQLPSX) installation and usage. SQLPSX Part1 SQLPSX Part2 Check out the discussion area for each article: Part 1 Discussion Part 2 Discussion   In Part  1 a reader had a … Continue reading

Posted in PowerShell

SQL Server PowerShell Extensions (SQLPSX)

SQL Server PowerShell Extensions (SQLPSX) is open source project hosted on CodePlex for purpose of providing an intuitive PowerShell scripting experience when working with SQL Server.  The original reason I created SQLPSX was to collect, analyze and report SQL Server security and … Continue reading

Posted in PowerShell

My First Blog Entry

My name is Chadwick (Chad) Miller, I’ve been a SQL Server DBA since 2000 and I’ve alway been someone who writes scripts using VBScript, Windows bat files, wmic, Perl, XSLT, T-SQL, GNUWin32 Shell tools, and now PowerShell.  After spending hundreds of hours writing … Continue reading

Posted in PowerShell