Jim P. (5/22/2013)
My question is still how to scale out SQL. It never seemed that MS designed the system for multiple access to a DB. So while you can scale up the web servers or number of clients, you are restricted by the controlling instance. I admit I've been out of touch with mainline general production support as I have been supporting my companies SW product which doesn't do well with advanced SQL options.
It has to do with architecture. SQL Server was never built to scale out, with a few exceptions. Distributed Partitioned Views can scale out, but not with redundancy. AlwaysOn is a start as well, though with a single write area.
Some of the Azure technologies are looking at scaling out, essentially by putting multiple databases to work for an application.