Introducing Microsoft SQL Server 2012

by Ross Mistry, Stacia Misner

Overview

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.

Product Details

ISBN-13:	9780735671416
Publisher:	Microsoft Press
Publication date:	03/27/2012
Sold by:	Barnes & Noble
Format:	eBook
Pages:	290
Sales rank:	355,444
File size:	28 MB
Note:	This product may take a few minutes to download.

About the Author

Ross Mistry is a best-selling author, community champion and seasoned architect. He has a tremendous amount of experience designing and deploying technology solutions for internet startups and Fortune 100 organizations located in the Silicon Valley. He is known in the world-wide community for his expertise in SQL Server, Windows, Exchange, Virtualization and Private Cloud. Ross frequently speaks at technology conferences around the world and has published many books, whitepapers, and magazine articles. His recent books include; Introducing SQL Server 2012, Windows Server 2008 R2 Unleashed, and SQL Server 2008 Management and Administration. Ross is currently a Principal Enterprise Architect with Microsoft working out of the Microsoft Technology Center in Silicon Valley.

Stacia Misner is the founder of Data Inspirations (datainspirations.com), which delivers global business intelligence (BI) consulting and education services. As a consultant, educator, mentor, and author specializing in business intelligence and performance management solutions that use Microsoft technologies, she has more than 25 years of experience in information technology and has focused exclusively on Microsoft BI technologies since 2000. She is the author of multiple books related to Microsoft SQL Server®, and most recently coauthored "Introducing Microsoft SQL Server 2008 R2" and "Building Integrated Business Solutions with SQL Server 2008 R2 and Office 2010." Stacia is also a Microsoft Certified IT Professional-BI and a Microsoft Certified Technology Specialist-BI. She currently lives in Las Vegas, Nevada, with her husband, Gerry, where you can contact her via e-mail at [e-mail].

Table of Contents

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