PowerShell Scripting Added to SQL Server 2008
After years of listening to complaints about Windows not being scriptable, Microsoft has finally taken action. PowerShell is being pushed into server products such as the next Windows Server and Exchange Server.
PowerShell is Microsoft's replacement for VBScript and batch-file based scripting. It is a fully object-orientated, meaning streams of objects flow from command to command instead of traditional text streams.
Francois Ajenstat has recently announced that SQL Server is the next to pick up PowerShell scripting in the next CTP. While CTP features are not guaranteed to be in the final product, they usually are.
David Beyer, Olaf Carlson-Wee, Richard Minerich Aug 02, 2015