Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak.
The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's companion web site, which you can use to jumpstart your own projects.
- Serves as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers
- Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications
- Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services
- Demonstrates tasks both graphically and in SQL code to enhance your learning
- Provides source code from the companion web site, which you can use as a basis for your own projects
- Explores tips, smart workarounds, and best practices to help you on the job
Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.
Table of Contents:
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
