I haven't used any windows web tech as yet, I like to stay agnostic with web tech as the server you run on may not be under your full controll and could be a windows or unix/linux OS.
For that reason I stick to PHP.
My goals are to develop RESTful apis in PHP with html/js client side single page applications, a pretty clean stack. You can use any js framework/library to help here.
For generating and migrating db's etc, frameworks like yii can do all that too and also have built in code generators for MVC and CRUD etc, very slick.
Another good alternative is Ruby On Rails, it is built just for this type of development and is very powerful and well supported, I would probably use this if Ruby was as 'standard' as PHP. Most shared hosting might not have it or let you install it, mine for instance has it but it's a very old version and they won't update it (cPanel). I will most likely move to a VPS soon but if you develop for others they might not have the same flexibility.
The hardest part which I'm working on now is authentication/authorisation, it's not so simple with an SPA. For instance, say you want to port your html/js app to a mobile app using PhoneGap, you don't get a page reload (start session, create csrf tokens etc ) at start up as it's not being published and sent from the server. Very tricky and there's a mess of stuff to weed through to find a good, safe solution.
You learn some good practices and architectures in web dev, very useful for all dev work as separation of concerns, design patterns and test driven development is petty much enforced on you early else you end up in a mess real quick.