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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
