We at WindowsDevPro are excited to bring this news to the DBAs active on this site. SQL Server development is a classic area of focus for WindowsDevPro because there is so much overlap and blending of roles between database administration and writing lots of code to drive SQL server.
The latest news is that SQL Server 2008 running on Windows Server 2008 is on track to provide simplified scripting with PowerShell. Jeffery Snover, the PowerShell architect at Microsoft, is excited, but offers a word of caution in his blog, "We should be clear - just because something ships in a CTP does not mean that it will ship in the product. There are lots of times and reasons why we’ll pull something for the final release. As such, you should get the SQL CTP, kick the tires on their PowerShell support and let the team know what you think. If you like it – let them know. If you don’t like it – let them know that as well." Here's his blog--
http://msdnrss.thecoderblogs.com/2007/11/13/sql-server-support-for-powershell/