For those of you who have had the pleasure of installing SQL 2008 and noticed that there are several prerequisites (which it would have been really nice if the SQL install program had included rather than it being a manual process).
Prerequites for installing SQL 2008
One of these is Windows Power Shell. You may have thought if power shell was powerful: it would blow a hole in your security. If power shell did not blow a hole in your security it could not be very powerful and therefore not worth learning about. Well it is powerful and it seems it does not blow a hole in your security. However the attitude - I'll install it and see what it does, is not quite as fruitful as one might hope. Power shell is not quite like a batch file. You install it, find a useful script from the internet, down load it to a *.ps1 file on your desk top, double click and get an error message. The shower shell script does not run. The following article takes you through the process of actually running a power shell script. I like the way it's written as well!
http://www.microsoft.com/technet/scriptcenter/topics/winpsh/manual/run.mspx