Synopses & Reviews
Introducing Microsoft SQL Server 2012l 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.
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.
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;