Microsoft SQL Server 2012 Bible

Harness the powerful new SQL Server 2012

Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you’re a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak.

The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book’s companion web site, which you can use to jumpstart your own projects.

• Serves as an authoritative guide to Microsoft’s SQL Server 2012 for database administrators and developers
• Covers all the software’s new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications
• Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services
• Demonstrates tasks both graphically and in SQL code to enhance your learning
• Provides source code from the companion web site, which you can use as a basis for your own projects
• Explores tips, smart workarounds, and best practices to help you on the job

Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.

Table of Contents

Part I: Laying the Foundations
Chapter 1: The World of SQL Server
Chapter 2: Data Architecture
Chapter 3: Installing SQL Server
Chapter 4: Client Connectivity
Chapter 5: SQL Server Management and Development Tools

Part II: Building Databases and Working with Data
Chapter 6: Introducing Basic Query Flow
Chapter 7: Relational Database Design and Creating the Physical Database Schema
Chapter 8: Data Types, Expressions, and Scalar Functions
Chapter 9: Merging Data with Joins, Subqueries, and CTEs
Chapter 10: Aggregating, Windowing, and Ranking Data
Chapter 11: Projecting Data Through Views
Chapter 12: Modifying Data In SQL Server

Part III: Advanced T-SQL Data Types and Querying Techniques
Chapter 13: Working with Hierarchies
Chapter 14: Using XML Data
Chapter 15: Executing Distributed Queries

Part IV: Programming with T-SQL
Chapter 16: Programming with T-SQL
Chapter 17: Developing Stored Procedures
Chapter 18: Building User-Defined Functions

Part V: Enterprise Data Management
Chapter 19: Configuring SQL Server
Chapter 20: Policy Based Management
Chapter 21: Backup and Recovery Planning
Chapter 22: Maintaining the Database
Chapter 23: Transferring Databases
Chapter 24: Database Snapshots
Chapter 25: Asynchronous Messaging with Service Broker
Chapter 26: Log Shipping
Chapter 27: Database Mirroring
Chapter 28: Replicating Data
Chapter 29: Clustering
Chapter 30: Configuring and Managing SQL Server with PowerShell
Chapter 31: Managing Data in Windows Azure SQL Database

Part VI: Securing Your SQL Server
Chapter 32: Authentication Types in SQL Server
Chapter 33: Authorizing Securables
Chapter 34: Data Encryption
Chapter 35: Row-Level Security

Part VII: Monitoring and Auditing
Chapter 36: Creating Triggers
Chapter 37: Performance Monitor and PAL
Chapter 38: Using Profiler and SQL Trace
Chapter 39: Wait States
Chapter 40: Extended Events
Chapter 41: Data Change Tracking and Capture
Chapter 42: SQL Audit
Chapter 43: Management Data Warehouse

Part VIII: Performance Tuning and Optimization
Chapter 44: Interpreting Query Execution Plans
Chapter 45: Indexing Strategies
Chapter 46: Maximizing Query Plan Reuse
Chapter 47: Managing Transactions, Locking, and Blocking
Chapter 48: Data Compression
Chapter 49: Partitioning
Chapter 50: Resource Governor

Part IX: Business Intelligence
Chapter 51: Business Intelligence Database Design
Chapter 52: Building, Deploying, and Managing ETL Workflows in Integration Services
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
Chapter 54: Configuring and Administering Analysis Services
Chapter 55: Authoring Reports in Reporting Services
Chapter 56: Configuring and Administering Reporting Services
Chapter 57: Data Mining with Analysis Services
Chapter 58: Creating and Deploying BI Semantic Models
Chapter 59: Creating and Deploying Power View Reports