Introducing Microsoft SQL Server 2012

;
Introduction;
Who Should Read This Book?;
Who Should Not Read This Book;
How Is This Book Organized?;
Conventions and Features in This Book;
Pre-Release Software;
Acknowledgments;
Errata & Book Support;
We Want to Hear from You;
Stay in Touch;
Database Administration;
Chapter 1: SQL Server 2012 Editions and Engine Enhancements;
1.1 SQL Server 2012 Enhancements for Database Administrators;
1.2 SQL Server 2012 Editions;
1.3 SQL Server 2012 Licensing Overview;
1.4 Hardware and Software Requirements;
1.5 Installation, Upgrade, and Migration Strategies;
Chapter 2: High-Availability and Disaster-Recovery Enhancements;
2.1 SQL Server AlwaysOn: A Flexible and Integrated Solution;
2.2 AlwaysOn Availability Groups;
2.3 Active Secondaries;
2.4 AlwaysOn Failover Cluster Instances;
2.5 Support for Deploying SQL Server 2012 on Windows Server Core;
2.6 Additional High-Availability and Disaster-Recovery Enhancements;
Chapter 3: Performance and Scalability;
3.1 Columnstore Index Overview;
3.2 Columnstore Index Fundamentals and Architecture;
3.3 Columnstore Index Design Considerations and Loading Data;
3.4 Creating a Columnstore Index;
3.5 Columnstore Index Observations and Best Practices;
Chapter 4: Security Enhancements;
4.1 Security Enhancements in SQL Server 2012;
4.2 Security Manageability Improvements;
4.3 Audit Enhancements;
4.4 Database Authentication Enhancements;
4.5 Additional Security Enhancements;
Chapter 5: Programmability and Beyond-Relational Enhancements;
5.1 Pain Points of Using the Beyond Relational Paradigm;
5.2 SQL Server 2012 Beyond-Relational Goals;
5.3 Rich Unstructured Data and Services Ecosystem;
5.4 Beyond-Relational Example;
5.5 FILESTREAM Enhancements;
5.6 FileTable;
5.7 Full-Text Search;
5.8 Statistical Semantic Search;
5.9 Spatial Enhancements;
5.10 Extended Events;
Business Intelligence Development;
Chapter 6: Integration Services;
6.1 Developer Experience;
6.2 Control Flow;
6.3 Data Flow;
6.4 Change Data Capture Support;
6.5 Flexible Package Design;
6.6 Deployment Models;
6.7 Parameters;
6.8 Integration Services Catalog;
6.9 Administration;
6.10 Package File Format;
Chapter 7: Data Quality Services;
7.1 Data Quality Services Architecture;
7.2 Knowledge Base Management;
7.3 Data Quality Projects;
7.4 Administration;
7.5 Integration;
Chapter 8: Master Data Services;
8.1 Getting Started;
8.2 Master Data Manager;
8.3 Model Deployment;
8.4 MDS Add-in for Excel;
8.5 Miscellaneous Changes;
Chapter 9: Analysis Services and PowerPivot;
9.1 Analysis Services;
9.2 PowerPivot for Excel;
9.3 DAX;
9.4 PowerPivot for SharePoint;
Chapter 10: Reporting Services;
10.1 New Renderers;
10.2 SharePoint Shared Service Architecture;
10.3 Power View;
10.4 Data Alerts;
About the Authors;