December 2017
Intermediate to advanced
434 pages
10h 14m
English
In simple terms, Azure SQL database is a typical relational database which behaves to an users as a database without an SQL Server instance. It's not true, however, because actually the database is hosted in SQL Server cloud environment in the form of a partially contained database.
The database containment can be used on-premise as well. The partially contained database is a SQL Server database that has some server level properties inherited to itself. That's why such databases are also called self-contained databases. Using self-contained databases on on-premise SQL Server instances enables DBAs to create users with passwords. It bypasses traditional authentication and authorization models described in ...
Read now
Unlock full access