Easy as pie and built right in...
Shift+Right click on a folder in any Explorer window and choose "Open Command Windows Here".
Now if only I could figure out how to get it to use PowerShell instead of cmd.exe.
Tags: Windows Vista, PowerShell, Command Prompt, Explorer