Microsoft SQL Server 2012 Bible

Introduction xxixPart I: Laying the Foundations 1Chapter 1: The World of SQL Server 3Chapter 2: Data Architecture 15Chapter 3: Installing SQL Server 31Chapter 4: Client Connectivity 71Chapter 5: SQL Server Management and Development Tools 81Part II: Building Databases and Working with Data 109Chapter 6: Introducing Basic Query Flow 111Chapter 7: Relational Database Design and Creating the Physical Database Schema 143Chapter 8: Data Types, Expressions, and Scalar Functions 173Chapter 9: Merging Data with Joins, Subqueries, and CTEs 213Chapter 10: Aggregating, Windowing, and Ranking Data 249Chapter 11: Projecting Data Through Views 271Chapter 12: Modifying Data In SQL Server 291Part III: Advanced T-SQL Data Types and Querying Techniques 323Chapter 13: Working with Hierarchies 325Chapter 14: Using XML Data 339Chapter 15: Executing Distributed Queries 367Part IV: Programming with T-SQL 387Chapter 16: Programming with T-SQL 389Chapter 17: Developing Stored Procedures 431Chapter 18: Building User-Defi ned Functions 453Part V: Enterprise Data Management 467Chapter 19: Confi guring SQL Server 469Chapter 20: Policy Based Management 531Chapter 21: Backup and Recovery Planning 547Chapter 22: Maintaining the Database 585Chapter 23: Transferring Databases 615Chapter 24: Database Snapshots 635Chapter 25: Asynchronous Messaging with Service Broker 647Chapter 26: Log Shipping 661Chapter 27: Database Mirroring 685Chapter 28: Replicating Data 727Chapter 29: Clustering 745Chapter 30: Confi guring and Managing SQL Server with PowerShell 769Chapter 31: Managing Data in Windows Azure SQL Database 801Part VI: Securing Your SQL Server 831Chapter 32: Authentication Types in SQL Server 833Chapter 33: Authorizing Securables 841Chapter 34: Data Encryption 853Chapter 35: Row-Level Security 861Part VII: Monitoring and Auditing 877Chapter 36: Creating Triggers 879Chapter 37: Performance Monitor and PAL 909Chapter 38: Using Profi ler and SQL Trace 919Chapter 39: Wait States 931Chapter 40: Extended

Adam Jorgensen is the President of Pragmatic Works Consulting, a Director for the Professional Association of SQL Server (PASS), a SQL Server MVP, and a well-known speaker, author, and executive mentor. His focus is on helping companies realize their full potential using their data in ways they have not previously imagined. Adam is very involved in the community, delivering more than 75 community sessions per year. Based in Jacksonville, FL, Adam has written and contributed to five previous books on SQL Server, analytics, and SharePoint. Coauthors Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson are well-known experts on SQL Server and Business Intelligence.