The thing I'm most looking forward to with contained DBs is mirroring. I'm worried that we'll hit a failover and a SQL job will have been updated on one server but not the other. I'm not as concerned about users since all requests should go through the DBA team and we can sync the SIDs but we have vendors and app owners that maintain their own jobs.