The express edition is free for any application. The pro version does cost money, but a lot of people can get by without it.

Also, there's the Bizspark program, which means a startup can get pretty much every Microsoft tool they need for free, for 3 years.