SQL Server 2008 CTP6 gives you PowerShell

re: SQL Server 2008 CTP6 gives you PowerShell

Siraj Jamdar — Mon, 13 Oct 2008 02:01:54 GMT

I find it intriguing that finally PowerShell provides an opportunity to pipe AND tee output.

One scenario I can think of is as follows. An SSIS package encounters an error. If I tee the output, relevant details can be logged. Simultaneously, based on severity, a case statement might fire off to send an SMS if it is very high priority, or it can send out an email so that the issue can be dealt with at a more sedate pace...

Using ScriptingOptions with SQLPS

Rob Farley — Mon, 03 Mar 2008 22:53:49 GMT

I've written before that SQL Server 2008 (February CTP) gives you SQLPS - a PowerShell interface

Transfer SQL Server Objects Task internals

Rob Farley — Sat, 23 Feb 2008 06:57:19 GMT

How often do you wonder what something's actually doing under the hood (in the way that it talks