Daniel: Thank you for this article. I particularly appreciate that you took the time to explain the methods used prior to 2012 for transferring logins. For those of us who are not likely to actually see 2012 for many a year, that was a nice inclusion.
I wanted to read your article even though I do not have access to 2012 and likely will not for some time, because I am very interested in learning about the new features. While you did a great job of explaining what contained databases are as a concept, I would have wanted to learn more about the options. For example, why "= partial"? Only partial? What are we missing?
Also, is this feature only available with t-sql or is there a user-interface/check box option somewhere? If available in the SSMS GUI, I would have liked to have seen a picture in the article of how it looks. I do a lot of my work in code, but for the initial creating of a database, I usually just do that using the GUI. Even if I didn't create databases that way, it seems like knowing whether a database is "contained" or not would be something someone would want to be able to quickly look up - (actually, both in the GUI and by code).
Just some feedback. I was pleased with the article and appreciate you writing it.