Database Containment - Benefits

hi experts

i am Reading about: Benefits of Database Containment:
Initial Database Development
and
Database Administration. But i do not understand.
Can you give me an example.

Initial Database Development
Because a developer may not know where a new database will be deployed, limiting the deployed environmental impacts on the database lessens the work and concern for the developer. In the non-contained model, the developer must consider possible environmental impacts on the new database and program accordingly. However, by using partially contained databases, developers can detect instance-level impacts on the database and instance-level concerns for the developer.

Database Administration
Maintaining database settings in the database, instead of in the master database, lets each database owner have more control over their database, without giving the database owner sysadmin permission.
enrique_aeoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
can you give me an example about: extra validations for the environment
Means that developers don't need to check if the database is in DEV, TEST or PROD environment since usually the logins are different from these environments. With a Contained Database the users doesn't have a respective login so their credentials are included in the database and this will save the work of the developers because they won't need to validate the environment but only the database users no matter in each environment the Contained Database is installed.
0
 
Jason clarkDBA FreelancerCommented:
Go through Containment Paragraph of the following link:
https://technet.microsoft.com/en-us/library/ff929071%28v=sql.110%29.aspx
0
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
Contained Databases were introduced in MSSQL 2012 and basically are more portable since allows you to copy/move the database to another SQL Server instance without the need of transferring logins (that exists in master database).
The logins are contained in the database and when connecting for this kind of database you'll always need to provide the login and database name.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
enrique_aeoAuthor Commented:
Vitor,
Your explanation is for
Initial Database Development
or
Database Administration.
0
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
They are related.
For a Database Administration point of view the database users doesn't have a Login associated so one need to manage permissions.
For a Development point of view there's no need for the developers to make extra validations for the environment since the users are contained in the database. They don't need for example higher permissions level because the database users doesn't have logins associated.
0
 
enrique_aeoConnect With a Mentor Author Commented:
please

can you give me an example about: extra validations for the environment
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.