Chapter 3. Configuring SQL Server 2012 Components

Exam objectives in this chapter:

  • Configure additional SQL Server components.

  • Manage and configure databases.

Microsoft SQL Server 2012 database administrators (DBAs) must be able to deploy not only the Database Engine but also Analysis Services and Reporting Services in either Native or SharePoint integrated mode. In this chapter, you learn about the new FileTable feature and configuring Integration Services security and support for FILESTREAM. As a DBA, you must also know how to create full-text indexes, design filegroups, partition tables and indexes, and how to configure transparent data encryption and data compression.

Lessons in this chapter:

Get Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases 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.