Dmitri's got a cool introduction to contained databases in his article; Partially Contained Databases in SQL Server 2012 http://blog.discountasp.net/partially-contained-databases-in-sql-server-2012/
