Microsoft has just posted architectural guidelines on how to build a SaaS aplication on our platform. Liteware is a fictitious HR application built using .NET 3.0 and on SQL 2005 and the sample application implements single-instance multi-tenancy patterns. More here.