Solved

Database Containment - Benefits

Posted on 2016-11-19
6
35 Views
Last Modified: 2016-11-23
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.
0
Comment
Question by:enrique_aeo
  • 3
  • 2
6 Comments
 
LVL 7

Expert Comment

by:Jason clark
ID: 41895333
Go through Containment Paragraph of the following link:
https://technet.microsoft.com/en-us/library/ff929071%28v=sql.110%29.aspx
0
 
LVL 46

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
ID: 41895487
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
 

Author Comment

by:enrique_aeo
ID: 41896593
Vitor,
Your explanation is for
Initial Database Development
or
Database Administration.
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 46

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
ID: 41897097
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
 

Assisted Solution

by:enrique_aeo
enrique_aeo earned 0 total points
ID: 41897732
please

can you give me an example about: extra validations for the environment
0
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41898669
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now