O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required