Microsoft SQL Server 2012 Bible

Something for you on every page If you're a database administrator or developer, this book is your complete, one-stop resource for SQL Server 2012. The authors provide in-depth coverage of core techniques, best practices, and smart workarounds, as well as plenty of examples and sample code. They also fully cover such new features as AlwwaysOn connectivity, new indexes, Power View, Master Data Services, Data Quality Services, PowerPivot for SQL Server 2012, and more. Thoroughly explore all new features in SQL Server 2012 Understand advanced T-SQL data types and querying techniques Ensure high availability for mission-critical applications Start using SQL Azure for cloud computing Master new security and compliance settings Leverage your data with tools for BI, data warehousing, and Enterprise Information Management solutions Get up to speed on the latest enhancements to the BI toolset

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

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.