Get up to speed on SQL Server Contained Databases with these valuable tips, tutorials, how-to’s, scripts, and more perfect for SQL Server DBAs.
Recently in one of our HR projects we implemented the contained SQL Server database concept. We implemented the policy that going forward we will create Contained SQL Server Users without login in contained databases which will ease the process of migrati
I know SQL Server 2012 added a feature where you can use contained databases. I also have heard that these databases can have users which can be authenticated by the SQL Server. However, the users don't appear in the standard sys.sql_logins or sys.server_
Often times we are tasked with moving databases from the production environment to a lower level environment such as QA or DEV. One typical struggle is getting the logins correct and aligned with users within the database. Often after a restore you are l
While looking through the new features and improvements in SQL Server Denali, we found a potentially interesting feature called Contained Databases. A contained database basically includes all database settings and the metadata within itself thereby resul