SQL Server v.Next (Denali) : More on contained databases and "contained users"

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Fri, 10 Dec 2010 12:34:00 GMT Indexed on 2010/12/10 22:21 UTC
Read the original article Hit count: 514

Filed under:

Contained databases

|

database portability

|

Denali

|

management studio

|

security

|

SQL 11

|

SQL Server 11

|

SQL Server 2011

|

SSMS

One of the reasons for contained databases (see my previous post ) is to allow for a more seamless transition when moving a database from one server to another. One of the biggest complications in doing so is making sure that all of the logins are in place on the new server. Contained databases help solve this issue by creating a new type of user: a database-level user with a password. I want to stress that this is not the same concept as a user without a login , which serves a completely different...(read more)

© SQL Blog or respective owner

Related posts about Contained databases

SQL Server v.Next (Denali) : More on contained databases and "contained users"

as seen on SQL Blog - Search for 'SQL Blog'
One of the reasons for contained databases (see my previous post ) is to allow for a more seamless transition when moving a database from one server to another. One of the biggest complications in doing so is making sure that all of the logins are in place on the new server. Contained databases help… >>> More
Big Data – Operational Databases Supporting Big Data – Key-Value Pair Databases and Document Databases – Day 13 of 21

as seen on SQL Authority - Search for 'SQL Authority'
In yesterday’s blog post we learned the importance of the Relational Database and NoSQL database in the Big Data Story. In this article we will understand the role of Key-Value Pair Databases and Document Databases Supporting Big Data Story. Now we will see a few of the examples of the operational… >>> More
mysql show databases not showing databases that are in /opt/bitnami/mysql/data directory

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
and thank you for taking the time to look at my question. I have an ebs-backed ec2 ubuntu server which is running but unreachable. ** There are very stupidly no recent backups ** I made a snapshot of the block, created a volume, spun up a new instance, attached the new volume. I see all the data… >>> More
Designing a social network with CQRS, graph databases and relational databases in mind

as seen on Programmers - Search for 'Programmers'
I have done quite an amount of research on the topic so far, but i couldn't come up with a conclusion to make up my mind. I am designing a social network and during my research i stumbled upon graph databases, i found neo4j pretty interesting for user relations and traversing through nodes. I also… >>> More
Let MySQL users create databases, but allow access to only their own databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to have multiple a MySQL users to be able to issue commands like CREATE DATABASE dbTest; But I also want each of these users to be able to see and access only their own databases. All I could find was how to either create the databases by a DBA and grant the privileges on this database… >>> More

Related posts about database portability

SQL SERVER Retrieve and Explore Database Backup without Restoring Database Idera virtual database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I recently downloaded Ideras SQL virtual database, and tested it. There are a few things about this tool which caught my attention.My ScenarioIt is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database… >>> More
Portability among mobile platforms

as seen on Stack Overflow - Search for 'Stack Overflow'
Do any libraries or other development resources exist that can help reduce the effort involved in porting applications between various mobile platforms? In particular, I am interested in supporting iPhone, Android, and Windows Mobile. Some areas of concern include UI, client-server communication… >>> More
Native Client and Web Portability

as seen on Google Code - Search for 'Google Code'
One of the most important principles of the web is portability: a web page renders and behaves the same way, regardless of the browser’s operating system or the... >>> More
cPickle ImportError: No module named multiarray

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm using cPickle to save my Database into file. The code looks like that: def Save_DataBase(): import cPickle from scipy import * from numpy import * a=Results.VersionName #filename='D:/results/'+a[a.find('/')+1:-a.find('/')-2]+Results.AssType[:3]+str(random.randint(0,100))+Results.Distribution+"… >>> More
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

as seen on SQL Authority - Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More