Latest news from IT-Forum/TechEd 2007 Barcelona, is that the upcomming CTP 5 release of MS SQL Server 2008 won't come with integrated PowerShell - this feature won't be available until CTP 6 of SQL Server 2008 :-(
I work as a Database Administrator for JN Data (www.jndata.dk), as well as a freelance SQL Server consultant.
My main use of PowerShell is as a Windows and SQL Server automation tool. But I also use it to do web monitoring, data extraction as well as other administrative tasks.
In my spare time i enjoy building with LEGO with and without my son.