What SQL Server doesn't do well (or at all) is true active-active clustering for the purpose of load balancing. I think the lack of a solution there is leading people to look at Oracle or (gasp!) Cassandra as better database solutions.