Having said this, I find the Microsoft platform dead simple, the tools best of breed, and the new MVC framework to have opened up the platform considerably.
Yeah, the thing people also don't realize on this topic is you can use MS SQL Express - which is free - to avoid paying/licensing issues.
The limits are almost entirely around ui, ease of use type features, not performance or scalability. Aka, you don't get the fancy VisualStudio-esq UI so you can't do diagramming, or things that you want generally when you are developing. But you still get a barebones management tool that's better than most of the mySql variants I've played with.
For use on a webserver, yeah it's a solid option esp if you are already having to use MS SQL because of other business requirements by your client/company.
.Net might just attract personality types that are more risk averse, aka programmers more interested in a steady paycheck than the ups/downs/stress of the startup life.