December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
What’s New in Creating and Managing Databases
SQL Server 2012 offers several new features that provide improved security and manageability at the database level. Contained databases are the biggest change in 2012. Contained databases are isolated from other databases and the SQL Server instance that the database is running on. They can be easily moved from one server to another without authentication issues and the like that make non-contained database migrations more difficult.
FILESTREAM has been improved in SQL Server 2012. FILESTREAM was introduced in SQL Server 2008, and it provides a means for storing unstructured data in the file system. These files are still an integral part of the database, including transactional consistency. In SQL ...