SQL 2008 and powershell (Sunday, January 25, 2009) - with the 2008 releases from microsoft powershell is really making its way into the mainstream. sql server 2008 ships with standard powershell as well as an add-in that provides an interesting degree of integration that will allow DBAs to write scripts that are far more generalized than T-SQL scripts. getting ready to play with it is pretty strait forward. all you
Asynchronous and remote execution with powershell 2 ctp3 (Tuesday, June 30, 2009) - An interesting feature released with the PowerShell 2 CTP3 is the ability to run background jobs consisting of arbitrary PowerShell code. In order to use this functionality you must download and install the PowerShell 2 CTP3 and the WinRM (Windows Remote Management) 2.0 CTP. Keep in mind that installing the CTP requires uninstalling previous versions of PowerShell.
PowerShell 2.0 Out-GridView, ISE and ScriptCmdlets (Sunday, July 05, 2009) - In my last post I discussed the background-job and remoting systems of PowerShell 2.0. While I find those features interesting personally there are three more that I'd like to discuss that have a broader appeal: the Out-GridView CmdLet, ScriptCmdlets and the PowerShell Integrated Scripting Environment (ISE). Note that PowerShell 2.0 is in CTP 3 at the time of writing
