As your awareness, in some recent years, the software technologies has changed a lot in the very fast pace. Remembered that one or two years ago, Microsoft technologies seem to be on the top with lots of new tools introduced like: ASP.NET MVC, MEF, Silverlight, .NET Framework 4. 0, LINQ. ..
But for now, Microsoft is no longer a leader on technologies, even though I have felt that this big company is likely kind of later than others, especially open source technologies. With the birth of HTML5 and the popularity of REST, mobile development, No Sql, the software development world has changed differently for the new decade.
HTML5 is born to change our thought of front end technologies and shorten the gap between web UI and Win UI, the gap between desktop development and mobile development. HTML5 has been dominating UI and might be the killer of other technologies: WPF, Silverlight, Flex…. As you might know MS has announced to build Windows 8 on HTML5 and they did a review for this. It also led to the dead of cookie whose data-capacity limitation and always carried over HTTP requests with the new introduction of web storage: local storage and session storage.
HTML5 is ready to adopt into mobile web development as its standard continues to evolve and will become a strong alternative with native applications on mobile operating system like Android, iOS because of its very strong pro: able to be multi-platform.
Web Socket, I believe it will come to the standard soon and resolved some security problems rose from Microsoft. With Web socket, it will be easy for us to push data from server to client over one and only one open TCP connection which we cannot do it before, this only way to do is polling requests from client to server to fetch data, although comet and some other technologies were born to solve this but they are still polling mechanism.
REST has come out for long time, from thesis of Thomas Fielding on 2000, but now it is more and more popular. Remember that REST is not standard like other RPC (Remote Procedure Call) SOAP, AMF… it is just style in order to build distribution application based on HTTP and use HTTP methods. So, you are able to use any language with its pro: simple and lightweight.
REST also led to the dead of SOAP, a standard promoted by Don Box, truly SOAP is inessentially complicated and does need lots of configuration compared to REST. Most of popular services on web are REST service: Flickr, Twitter, GitHub.
For all above, SOAP service, WCF should be in consideration because it is based heavily on SOAP.
Relational database has been for long time although it is likely dominant database architecture in two decades. But now, it has changed with the new evolution of Non-relational database like: document database, json database, graph database with popular tools: Mongo, Cassandra, Redis and many others are maturing daily and play important role in software architecture. Lots of big web apps are using No SQL, Facebook, Google+, and Twitter.