Contained Databases in SQL Server 2012 – Denali

Who is online?  117 guests and 0 members
home  »  blogs  »  Sarabpreet Anand  »  Contained Databases in SQL Server 2012 – Denali
  Rate This Blog Entry:  register  or  login

Author

sarab Sarabpreet Anand (Member since: 3/15/2011 5:38:06 AM)
SQLServer-MVP, Vice President - SQLServerGeeks.com

Sarabpreet is SQLServer MVP, DBA, Speaker, Trainer, Blogger and Community Lead. You can find him speaking at a local UG Event or a SQL Webcast. He has 8+ years of Experience and worked with Industry Leaders like Wipro, HP and HCL. He has many SQL Certifications under his belt. His core competency lies in administration of SQL Server. Always ready to help, online \offline. His life’s mantra is “Knowledge Increases by sharing so, Pass it on”. To know about his speaking engagements visit: here...

Follow Sarab on  Twitter@Sarab_SQLGeek ,  Facebook ,  LinkedIn

View Sarabpreet Anand 's profile

Comments (7)

user146939
12/16/2011 7:13:26 AM Rashmi Patankar said:

Hi Sarab...Could you please elaborate how a user can login to the database without having a login. I am bit confused on contained DB part.

by
user146939
12/16/2011 7:20:27 AM Rashmi Patankar said:

Also, can you explain me two-part name & three-part name that you've mentioned in the application model & mangement model?

by
sarab
12/16/2011 9:37:01 AM Sarabpreet Anand said:

Hi,

For your first Question: " Hi Sarab...Could you please elaborate how a user can login to the database without having a login. I am bit confused on contained DB part."

Don't worry about this, i am writing another article on "How to Create and Manage Contained Databases" and i'll explain everything regarding these users in the article.

I am busy with lots of other stuff today....will try to publish that tommorow.

 

by
sarab
12/16/2011 9:46:40 AM Sarabpreet Anand said:

Your second question: "Also, can you explain me two-part name & three-part name that you've mentioned in the application model & mangement model?"

Let's say you are connected to Sales Database and want to get some data out of Employee database, how will you get that data?

you've two options:

1. Connect to Employee DB .... query for the data you need & then connect back to Sales Database to continue working on whatever you were doing.

2. Query directly to Employee database by using three part Name i.e., select * from Employee.dbo.PersonalDetails

Note: Employee is database Name, dbo is Schema Name and PersonalDetails is Table\view Name.

The same way you can connect to some other Server or SQL Instance also to get some data by providing a four part name:

ServerName.DatabaseName.SchemaName.TableName

in some cases you may skip giving schemaName if the schema of the object is either in DBO schema or your default schema.

Hope this helped. Smile

Thanks

Sarab

by
user146939
12/16/2011 9:58:54 AM Rashmi Patankar said:

Thanks. That was a wonderful explanation. Thanks for the elaborative answer!

by
sarab
12/23/2011 4:40:51 AM Sarabpreet Anand said:

Hi,

As promised, I've submitted the article on Contained Database Implementation & Users Authentication. Here is the link:

http://www.sqlservergeeks.com/articles/sql-server-bi/82/step-by-step-guide-to-implement-contained-databases-sql-server-denali

Thanks,

Sarabpreet Singh

by
Jack
12/24/2011 9:12:58 PM Jack said:

A picture explaining everything would have explained everything better

by

Leave a comment

Name:
  *  
Email:  (your email is kept secure)
 *  
Website:

example: "http://www.SQLServerGeeks.com"

 
Type the characters:
 *
 
   

SQLServerGeeks FaceBook group

SQLServerGeeks Events

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Sarabpreet Anand's latest blog posts

Blogs RSS Feed

Latest community blog posts

  • Hi Friends, In this blog post, let’s have an insight on how Auditing can be done in SSIS packages? The basic auditing in package includes measures like How many rows were inserted, updated or de...
  • Hi SQL Geeks, Here are the blog posts by Piyush Bajaj for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at ht...
  • Hi SQL Geeks, Here are the blog posts by Ahmad Osama for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at htt...
  • Hi Friends, Are you facing any issue on SQL Server 2014 while running the same query which is running fine on previous version of SQL Server? If answer is yes then this may be due to the change in SQL...
  • I have written a SQL Server Change Data Capture GUI interface to facilitate for CDC operations. The project is hosted here https://sqlcdcapp.codeplex.com/ . Feel free to download, review and suggest c...
  • Recently I came across an interesting deadlock scenario I wasn’t aware off. I didn’t have idea that foreign key constraint can also result in deadlocks. The detailed steps to replicate the...
  • Hi Friends, In my earlier blog, I just explain about the importance of filtered indexes. Link for that blog is mention below: http://sqlservergeeks.com/blogs/princerastogi/personal/599/filtered-indexe...
  • A few words about the technology of our site. It's easy to take technology for granted, to focus on content and pay no attention to how it is being delivered. Typically we would encourage this focus. ...