Free SQL Server Training Webinars

We provide an array of sessions for those needing introduction, mid-level and even expert topics. Over 300 SQL Server data platform topics are covered including topics great for DBA’s and BI/Analytics professionals.   

Enhance your SQL Skills with Pragmatic Works 2 times a week.

 

Speaker Description
Sharon Dooley Sharon Dooley

What on earth is a contained database?

Book Cover

Instructor: Sharon Dooley

Date/Time: 3/12/2013 11:00 AM

Anyone who has ever needed to move a database from one server to another has experienced the pain of dealing with mismatched SQL Server authentication logins. In this session, I will describe what a contained database is and how this new 2012 feature can ease your pain. I'll look at some of the advantages and disadvantages of this feature and talk about the new SQL Users with Passwords and Windows users. I'll demonstrate how to create a contained database and how to connect to it. Then I will demonstrate the process of making an existing database contained. If time permits, I'll also talk about the way contained databases handle differences in collation between the contained database and tempdb.

Copyright 2014 by Pragmatic Works