Microsoft SQL Server 2012 Bible (Paperback)

Introduction    xxix

Part I: Laying the Foundations 1

Chapter 1: The World of SQL Server    3

Chapter 2: Data Architecture     15

Chapter 3: Installing SQL Server     31

Chapter 4: Client Connectivity       71

Chapter 5: SQL Server Management and Development Tools     81

Part II: Building Databases and Working with Data 109

Chapter 6: Introducing Basic Query Flow    111

Chapter 7: Relational Database Design and Creating the Physical Database Schema      143

Chapter 8: Data Types, Expressions, and Scalar Functions      173

Chapter 9: Merging Data with Joins, Subqueries, and CTEs     213

Chapter 10: Aggregating, Windowing, and Ranking Data    249

Chapter 11: Projecting Data Through Views     271

Chapter 12: Modifying Data In SQL Server      291

Part III: Advanced T-SQL Data Types and Querying Techniques 323

Chapter 13: Working with Hierarchies      325

Chapter 14: Using XML Data       339

Chapter 15: Executing Distributed Queries      367

Part IV: Programming with T-SQL 387

Chapter 16: Programming with T-SQL       389

Chapter 17: Developing Stored Procedures     431

Chapter 18: Building User-Defi ned Functions    453

Part V: Enterprise Data Management 467

Chapter 19: Confi guring SQL Server     469

Chapter 20: Policy Based Management     531

Chapter 21: Backup and Recovery Planning     547

Chapter 22: Maintaining the Database     585

Chapter 23: Transferring Databases     615

Chapter 24: Database Snapshots      635

Chapter 25: Asynchronous Messaging with Service Broker      647

Chapter 26: Log Shipping      661

Chapter 27: Database Mirroring     685

Chapter 28: Replicating Data       727

Chapter 29: Clustering      745

Chapter 30: Confi guring and Managing SQL Server with PowerShell  769

Chapter 31: Managing Data in Windows Azure SQL Database   801

Part VI: Securing Your SQL Server 831

Chapter 32: Authentication Types in SQL Server     833

Chapter 33: Authorizing Securables     841

Chapter 34: Data Encryption       853

Chapter 35: Row-Level Security     861

Part VII: Monitoring and Auditing 877

Chapter 36: Creating Triggers      879

Chapter 37: Performance Monitor and PAL     909

Chapter 38: Using Profi ler and SQL Trace    919

Chapter 39: Wait States    931

Chapter 40: Extended Events       937

Chapter 41: Data Change Tracking and Capture     945

Chapter 42: SQL Audit      967

Chapter 43: Management Data Warehouse     977

Part VIII: Performance Tuning and Optimization 993

Chapter 44: Interpreting Query Execution Plans     995

Chapter 45: Indexing Strategies   1005

Chapter 46: Maximizing Query Plan Reuse     1041

Chapter 47: Managing Transactions, Locking, and Blocking    1047

Chapter 48: Data Compression    1097

Chapter 49: Partitioning      1109

Chapter 50: Resource Governor    1131

Part IX: Business Intelligence 1141

Chapter 51: Business Intelligence Database Design    1143

Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services      1155

Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX   1195

Chapter 54: Confi guring and Administering Analysis Services     1223

Chapter 55: Authoring Reports in Reporting Services   1233

Chapter 56: Configuring and Administering Reporting Services    1261

Chapter 57: Data Mining with Analysis Services    1281

Chapter 58: Creating and Deploying BI Semantic Models      1299

Chapter 59: Creating and Deploying Power View Reports      1327

Index      1347