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.
Database Administration
Chapter 1 SQL Server 2012 Editions and Engine Enhancements
SQL Server 2012 Enhancements for Database Administrators
SQL Server 2012 Editions
SQL Server 2012 Licensing Overview
Hardware and Software Requirements
Installation, Upgrade, and Migration Strategies
Chapter 2 High-Availability and Disaster-Recovery Enhancements
SQL Server AlwaysOn: A Flexible and Integrated Solution
AlwaysOn Availability Groups
Active Secondaries
AlwaysOn Failover Cluster Instances
Support for Deploying SQL Server 2012 on Windows Server Core
Additional High-Availability and Disaster-Recovery Enhancements
Chapter 3 Performance and Scalability
Columnstore Index Overview
Columnstore Index Fundamentals and Architecture
Columnstore Index Design Considerations and Loading Data
Creating a Columnstore Index
Columnstore Index Observations and Best Practices
Chapter 4 Security Enhancements
Security Enhancements in SQL Server 2012
Security Manageability Improvements
Audit Enhancements
Database Authentication Enhancements
Additional Security Enhancements
Chapter 5 Programmability and Beyond-Relational Enhancements
Pain Points of Using the Beyond Relational Paradigm
Stacia Misner is the founder of Data Inspirations (www.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 smisner@datainspirations.com.