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.
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: R...