Microsoft SQL Server 2012 Bible

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.

Harness the powerful new SQL Server 2012Microsoft SQL Server 2012 is the most significant update to thisproduct since 2005, and it may change how database administratorsand developers perform many aspects of their jobs. If you're adatabase administrator or developer, Microsoft SQL Server 2012Bible teaches you everything you need to take full advantage ofthis major release. This detailed guide not only covers all the newfeatures of SQL Server 2012, it also shows you step by step how todevelop top-notch SQL Server databases and new data connections andkeep your databases performing at peak.The book is crammed with specific examples, sample code, and ahost of tips, workarounds, and best practices. In additiondownloadable code is available from the book's companion web sitewhich you can use to jumpstart your own projects.* Serves as an authoritative guide to Microsoft's SQL Server 2012for database administrators and developers* Covers all the software's new features and capabilitiesincluding SQL Azure for cloud computing, enhancements to clientconnectivity, and new functionality that ensures high-availabilityof mission-critical applications* Explains major new changes to the SQL Server BusinessIntelligence tools, such as Integration, Reporting, and AnalysisServices* Demonstrates tasks both graphically and in SQL code to enhanceyour learning* Provides source code from the companion web site, which you canuse as a basis for your own projects* Explores tips, smart workarounds, and best practices to helpyou on the jobGet thoroughly up to speed on SQL Server 2012 with MicrosoftSQL Server 2012 Bible.

I Laying the Foundations1 The World of SQL Server2 Data Architecture3 Installing SQL Server4 Client Connectivity5 SQL Server Management and Development ToolsII Building Databases and Working with Data6 Introducing Basic Query Flow7 Relational Database Design and Creating the Physical Database Schema8 Data Types, Expressions, and Scalar Functions9 Merging Data with Joins, Subqueries, and CTE's10 Aggregating, Windowing and Ranking Data11 Projecting Data Through Views12 Modifying Data in SQL ServerIII Advanced T-SQL Data Types and Querying Techniques13 Working with Hierarchies14 Using XML Data15 Executing Distributed QueriesIV Programming with T-SQL16 Programming with T-SQL17 Developing Stored Procedures18 Building User-Defined FunctionsV Enterprise Data Management19 Configuring SQL Server20 Policy Based Management21 Backup and Recovery Planning22 Maintaining the Database23 Transferring Databases24 Database Snapshots25 Asynchronous Messaging with Service Broker26 Log Shipping27 Database Mirroring28 Replicating Data29 Clustering30 Configuring and Managing SQL Server with PowerShell31 Managing Data in SQL Server AzureVI Securing Your SQL Server32 Authentication Types in SQL Server33 Authorizing Securables34 Data Encryption35 Row Level SecurityVII Monitoring and Auditing36 Creating Triggers37 Performance Monitor and PAL38 Using Profiler and SQL Trace39 Wait States40 Extended Events41 Data Change Tracking and Capture42 SQL Audit43 Management Data WarehouseVIII Performance Tuning and Optimization44 Interpreting Query Execution Plans45 Indexing Strategies46 Maximizing Query Plan Reuse47 Managing Transactions, Locking, and Blocking48 Data Compression49 Partitioning50 Resource GovernorIX Business Intelligence51 Business Intelligence Database Design52 Building, Deploying and Managing ETL Workflows in Integration Services53 Building MultiDimensional Cubes in Analysis Services with MDX54 Configuring and Administering Analysis Services55 Authoring Reports in Reporting Services56 Configuring and Administering Reporting Services57 Data Mining with Analysis Services58 Creating and Deploying BI Semantic Models59 Creating and Deploying Power View Reports