Earlier quoted context omitted.
>"On the other hand, if you build your apps around a horizontally scalable storage solution" I'm assuming you're talking specifically about Sql Server because there is no technical reason you can't use MS tech with Node, Mongo or MySql. What about Sql Server doesn't scale horizontally? Sql Server was scaling horizontally in the enterprise space since 2005. And also, all the fancy middleware ( memcache, lucene, whatev…
SQL databases in general don't scale well once they've maxed out a single machine, cross server joins are never going to be pretty and there's a pretty good reason why denormalising data and the adoption of NoSQL solutions with baked in clustering is taking off in a big way. Re NoSQL solutions on windows, theoretically possible, sure, but which NoSQL solution targets windows as its primary platform rather than an aft…
RavenDb.