Thank you for sharing such a detailed and well-explained solution.

Quick question: At the time did you evaluate SQL Server Master Data Services (MDS) as an option for your Reference Data...

If your compensation as a programmer or a DBA is aligned to a certain vendor / stack then you should be hoping that the salesperson is competent and very well...

The SQL Server Modeling technologies, presently in CTP, aim to provide significant productivity gains across the lifecycle of .NET applications by enabling developers, architects, and IT professionals to work together...

Houston is the starting point for a Silverlight version of SQL Management Studio (which you can still use on your SQL Azure instances).