Microsoft® SQL Server® 2012 Bible -- Contents -- Part I: Laying the Foundations -- Chapter 1: The World of SQL Server -- SQL Server History -- SQL Server in the Database Market -- SQL Server Components -- Editions of SQL Server 2012 -- Notable SQL Server 2012 Enhancements -- Summary -- Chapter 2: Data Architecture -- Information Architecture Principle -- Database Objectives -- Smart Database Design -- Summary -- Chapter 3: Installing SQL Server -- Preparing the Server -- Selecting the Edition -- The Installation Process -- Summary -- Chapter 4: Client Connectivity -- Enabling Server Connectivity -- SQL Server Native Client Features -- Summary -- Chapter 5: SQL Server Management and Development Tools -- Organizing the Interface -- Registered Servers -- Object Explorer -- Using the Query Editor -- Using the Solution Explorer -- Getting a Jumpstart on Code with Templates and Code Snippets -- Summary -- Part II: Building Databases and Working with Data -- Chapter 6: Introducing Basic Query Flow -- Understanding Query Flow -- FROM Clause Data Sources -- WHERE Conditions -- (0 row(s) affected)Columns, Stars, Aliases, and Expressions -- Ordering the Result Set -- Select Distinct -- TOP () -- Summary -- Chapter 7: Relational Database Design and Creating the Physical Database Schema -- Database Basics -- Data Design Patterns -- Normal Forms -- Strategy Considerations -- Summary -- Chapter 8: Data Types, Expressions, and Scalar Functions -- Data Types -- Building Expressions -- Scalar Functions -- String Functions -- Soundex Functions -- Data-Type Conversion Functions -- Server Environment Information -- Summary -- Chapter 9: Merging Data with Joins, Subqueries, and CTEs -- Using Joins -- Set Difference Queries -- Using Unions -- Subqueries -- Summary.

Chapter 10: Aggregating, Windowing, and Ranking Data -- Aggregating Data -- Grouping Within a Result Set -- Windowing and Ranking -- Ranking Functions -- Summary -- Chapter 11: Projecting Data Through Views -- Why Use Views? -- The Basic View -- A Broader Point of View -- Locking Down the View -- Using SQL Synonyms -- Summary -- Chapter 12: Modifying Data In SQL Server -- Inserting Data -- Updating Data -- Deleting Data -- Merging Data -- Returning Modified Data -- Summary -- Part III: Advanced T-SQL Data Types and Querying Techniques -- Chapter 13: Working with Hierarchies -- HierarchyID -- HierarchyID Methods -- Indexing Strategies -- Hierarchical Data Alternatives -- Summary -- Chapter 14: Using XML Data -- The XML Data Type -- XML Data Type Methods -- FOR XML -- XQuery and FLWOR Operations -- Summary -- Chapter 15: Executing Distributed Queries -- Distributed Query Overview -- Developing Distributed Queries -- Performance Consideration -- Summary -- Part IV: Programming with T-SQL -- Chapter 16: Programming with T-SQL -- Transact-SQL Fundamentals -- Working with Variables -- Procedural Flow -- Examining SQL Server with Code -- Temporary Tables and Table Variables -- What's New in T-SQL for 2012 -- Error Handling -- Bulk Operations -- Summary -- Chapter 17: Developing Stored Procedures -- Managing Stored Procedures -- Passing Data to Stored Procedures -- Returning Data from Stored Procedures -- Summary -- Chapter 18: Building User-Defined Functions -- Scalar Functions -- Inline Table-Valued Functions -- Multistatement Table-Valued Functions -- Best Practices with User-Defined Functions -- Summary -- Part V: Enterprise Data Management -- Chapter 19: Configuring SQL Server -- Setting the Options -- Configuration Options -- Summary -- Chapter 20: Policy Based Management -- Defining Policies -- Evaluating Policies -- Summary.

Chapter 21: Backup and Recovery Planning -- Recovery Concepts -- Recovery Models -- Backing Up the Database -- Working with the Transaction Log -- Recovery Operations -- System Databases Recovery -- Performing a Complete Recovery -- Summary -- Chapter 22: Maintaining the Database -- DBCC Commands -- Managing Database Maintenance -- Summary -- Chapter 23: Transferring Databases -- Copy Database Wizard -- Working with SQL Script -- Detaching and Attaching -- Import and Export Wizard -- Data-Tier Application (DAC) -- Summary -- Chapter 24: Database Snapshots -- How Do Database Snapshots Work? -- Using Database Snapshots -- Summary -- Chapter 25: Asynchronous Messaging with Service Broker -- Configuring a Message Queue -- Working with Dialogs -- What's New in Service Broker for SQL Server 2012? -- Monitoring and Troubleshooting Service Broker -- Summary -- Chapter 26: Log Shipping -- Availability Testing -- Warm Standby Availability -- Defining Log Shipping -- Checking Log Shipping Configuration -- Monitoring Log Shipping -- Modifying or Removing Log Shipping -- Switching Roles -- Summary -- Chapter 27: Database Mirroring -- Database Mirroring Overview -- Defining and Configuring Database Mirroring -- Checking Database Mirroring Configuration -- Monitoring Database Mirroring -- Pausing or Removing Database Mirroring -- Role Switching -- High Availability/AlwaysOn -- Summary -- Chapter 28: Replicating Data -- Moving Data Between Servers -- Replication Concepts -- Configuring Replication -- Summary -- Chapter 29: Clustering -- What Does Clustering Do? -- Configuring Clustering -- Summary -- Chapter 30: Configuring and Managing SQL Server with PowerShell -- Why Use PowerShell? -- Basic PowerShell -- SQL Server PowerShell Extensions -- Communicating with SQL Server via SMO -- Scripting SQL Server Tasks -- Summary.

Chapter 31: Managing Data in Windows Azure SQL Database -- Overview of Azure SQL Database -- Managing Windows Azure SQL Database -- High Availability and Scalability -- Migrating Data to SQL Database -- Summary -- Part VI: Securing Your SQL Server -- Chapter 32: Authentication Types in SQL Server -- Windows Authentication -- SQL Authentication -- Differences Between SQL and Windows Authentication -- Kerberos and Windows Authentication Delegation -- Summary -- Chapter 33: Authorizing Securables -- Permission Chains -- Object Ownership -- Securables Permissions -- Object Security -- A Sample Security Model -- Views and Security -- Summary -- Chapter 34: Data Encryption -- Introducing Data Encryption -- Summary -- Chapter 35: Row-Level Security -- The Security Table -- Assigning Permissions -- Checking Permissions -- Summary -- Part VII: Monitoring and Auditing -- Chapter 36: Creating Triggers -- Trigger Basics -- Working with the Transaction -- Multiple-Trigger Interaction -- Transaction-Aggregation Handling -- DDL Triggers -- Managing DDL Triggers -- Developing DDL Triggers -- Summary -- Chapter 37: Performance Monitor and PAL -- Using PerfMon -- Summary -- Chapter 38: Using Profiler and SQL Trace -- Features of SQL Server Profiler -- Running Profiler -- Using SQL Trace -- Summary -- Chapter 39: Wait States -- The SQL Server OS -- Examining Wait Statistics -- Common Red-Flag Wait Types -- Other Ways to Gather Wait data -- Summary -- Chapter 40: Extended Events -- The Extended Events Object Model -- The system_health Session -- The Extended Events Profiler -- Summary -- Chapter 41: Data Change Tracking and Capture -- Configuring Change Tracking -- Querying Change Tracking -- Removing Change Tracking -- Change Data Capture -- New in SQL Server 2012 -- Enabling CDC -- Working with Change Data Capture.

Removing Change Data Capture -- Summary -- Chapter 42: SQL Audit -- SQL Audit Technology Overview -- Creating an Audit -- Server Audit Specifications -- Database Audit Specifications -- Viewing the Audit Trail -- Summary -- Chapter 43: Management Data Warehouse -- Using the Management Data Warehouse -- Configuring MDW -- Setting Up Data Collection -- Viewing MDW Reports -- Creating Custom Data Collector Sets -- Summary -- Part VIII: Performance Tuning and Optimization -- Chapter 44: Interpreting Query Execution Plans -- Viewing Query Execution Plans -- Understanding Execution Plan Operators -- Summary -- Chapter 45: Indexing Strategies -- Zen and the Art of Indexing -- Indexing Basics -- The Path of the Query -- A Comprehensive Indexing Strategy -- Specialty Indexes -- Summary -- Chapter 46: Maximizing Query Plan Reuse -- Query Compiling -- Query Recompiles -- Summary -- Chapter 47: Managing Transactions, Locking, and Blocking -- The ACID Properties -- Programming Transactions -- Default Locking and Blocking Behavior -- Monitoring Locking and Blocking -- Dealing with Deadlocks -- Understanding SQL Server Locking -- Transaction Isolation Levels -- Application Locks -- Application Locking Design -- Transaction-Log Architecture -- Transaction Performance Strategies -- Summary -- Chapter 48: Data Compression -- Understanding Data Compression -- Applying Data Compression -- Summary -- Chapter 49: Partitioning -- Partitioning Strategies -- Partitioned Views -- Partitioned Tables and Indexes -- Summary -- Chapter 50: Resource Governor -- Exploring Fundamentals of Resource Governor -- Performance Monitoring of Resource Governor -- Views and Limitations -- Summary -- Part IX: Business Intelligence -- Chapter 51: Business Intelligence Database Design -- Data Warehousing.

Designing a Data Warehouse Using a Star Schema.