Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application developers, and technical decision makers.

1. Database Administration

   1. Chapter 1 SQL Server 2012 Editions and Engine Enhancements

      1. SQL Server 2012 Enhancements for Database Administrators
      2. SQL Server 2012 Editions
      3. SQL Server 2012 Licensing Overview
      4. Hardware and Software Requirements
      5. Installation, Upgrade, and Migration Strategies

   2. Chapter 2 High-Availability and Disaster-Recovery Enhancements

      1. SQL Server AlwaysOn: A Flexible and Integrated Solution
      2. AlwaysOn Availability Groups
      3. Active Secondaries
      4. AlwaysOn Failover Cluster Instances
      5. Support for Deploying SQL Server 2012 on Windows Server Core
      6. Additional High-Availability and Disaster-Recovery Enhancements

   3. Chapter 3 Performance and Scalability

      1. Columnstore Index Overview
      2. Columnstore Index Fundamentals and Architecture
      3. Columnstore Index Design Considerations and Loading Data
      4. Creating a Columnstore Index
      5. Columnstore Index Observations and Best Practices

   4. Chapter 4 Security Enhancements

      1. Security Enhancements in SQL Server 2012
      2. Security Manageability Improvements
      3. Audit Enhancements
      4. Database Authentication Enhancements
      5. Additional Security Enhancements

   5. Chapter 5 Programmability and Beyond-Relational Enhancements

      1. Pain Points of Using the Beyond Relational Paradigm
      2. SQL Server 2012 Beyond-Relational Goals
      3. Rich Unstructured Data and Services Ecosystem
      4. Beyond-Relational Example
      5. FILESTREAM Enhancements
      6. FileTable
      7. Full-Text Search
      8. Statistical Semantic Search
      9. Spatial Enhancements
      10. Extended Events

2. Business Intelligence Development

   1. Chapter 6 Integration Services

      1. Developer Experience
      2. Control Flow
      3. Data Flow
      4. Change Data Capture Support
      5. Flexible Package Design
      6. Deployment Models
      7. Parameters
      8. Integration Services Catalog
      9. Administration
      10. Package File Format

   2. Chapter 7 Data Quality Services

      1. Data Quality Services Architecture
      2. Knowledge Base Management
      3. Data Quality Projects
      4. Administration
      5. Integration

   3. Chapter 8 Master Data Services

      1. Getting Started
      2. Master Data Manager
      3. Model Deployment
      4. MDS Add-in for Excel
      5. Miscellaneous Changes

   4. Chapter 9 Analysis Services and PowerPivot

      1. Analysis Services
      2. PowerPivot for Excel
      3. DAX
      4. PowerPivot for SharePoint

   5. Chapter 10 Reporting Services

      1. New Renderers
      2. SharePoint Shared Service Architecture
      3. Power View
      4. Data Alerts

1. Appendix About the Authors