Professional: Microsoft® SQL Server® 2012 Administration -- About The Authors -- About The Technical Editors -- Credits -- Acknowledgments -- Contents -- Introduction -- Who This Book Is For -- How This Book Is Structured -- What You Need To Use This Book -- Conventions -- Source Code -- Errata -- P2P.wrox.com -- Chapter 1: SQL Server 2012 Architecture -- SQL Server 2012 Ecosystem -- New Important Features in 2012 -- Production DBA -- Development DBA -- Business Intelligence DBA and Developer -- SQL Server Architecture -- Database Files and Transaction Log -- SQL Native Client -- Standard System Databases -- Schemas -- Synonyms -- Dynamic Management Objects -- SQL Server 2012 Data Types -- Editions of SQL Server -- Edition Overview -- Licensing -- Summary -- Chapter 2: Installing SQL Server 2012 Best Practices -- Planning the System -- Hardware Options -- Software and Install Options -- Installing SQL Server -- New Installs -- Side-by-Side Installs -- Upgrades -- Unattended Installs -- Attended Installations -- Installing Analysis Services -- Multidimensional and Data Mining Mode (UDM Mode) -- Tabular Mode -- Installing PowerPivot for SharePoint -- Burning in the System -- Post-Install Configuration -- Configuring SQL Server Settings for Performance -- tempdb -- Configuring SQL Server Setting for Security -- Best Practices Analyzer (BPA) -- SQL Server Configuration Manager -- Back It Up -- Uninstalling SQL Server -- Uninstalling Reporting Services -- Uninstalling Analysis Services -- Uninstalling the SQL Server Database Engine -- Troubleshooting a Failed Install -- Summary -- Chapter 3: Upgrading SQL Server 2012 Best Practices -- Why Upgrade to SQL Server 2012? -- Risk Mitigation - the Microsoft Contribution -- Independent Software Vendors and SQL Community Contributions -- Upgrading to SQL Server 2012 -- In-Place Upgrading.

Side-by-Side Upgrade -- In-Place Upgrade versus Side-By-Side Upgrade Considerations -- Pre-Upgrade Steps and Tools -- Pre-Upgrade Steps -- Pre-Upgrade Tools -- Backward Compatibility -- Unsupported and Discontinued Features in SQL Server 2012 -- SQL Server 2012 Deprecated Database Features -- Other SQL Server 2012 Changes Affecting Behavior -- SQL Server Component Considerations -- Upgrading Full-Text Catalog -- Upgrading Reporting Services -- Upgrading to 64-Bit -- Post-Upgrade Checks -- Poor Query Performance After Upgrade -- Summary -- Chapter 4: Managing And Troubleshooting The Database Engine -- Configuration and Administration Tools -- SQL Server Configuration Manager -- Startup Parameters -- Startup Stored Procedures -- Partially Contained Databases -- Troubleshooting Tools -- Dedicated Administrator Connection -- Rebuilding the System Databases -- Management Studio -- Reports -- Configuring SQL Server in Management Studio -- Filtering Objects -- Error Logs -- Activity Monitor -- Monitoring Processes in T-SQL -- sp_who and sp_who2 -- sys.dm_exec_connections -- sys.dm_exec_sql_text -- Multiserver Management -- Central Management Servers and Server Groups -- SQL Server Utility -- Trace Flags -- Getting Help from Support -- SQLDumper.exe -- SQLDiag.exe -- Summary -- Chapter 5: Automating SQL Server -- Maintenance Plans -- Maintenance Plan Wizard -- Maintenance Plan Designer -- Automating SQL Server with SQL Server Agent -- Jobs -- Schedules -- Operators -- Alerts -- SQL Server Agent Security -- Service Account -- Access to SQL Agent -- SQL Server Agent Proxies -- Configuring SQL Server Agent -- General Properties -- Advanced Properties -- Alert System Properties -- Job System Properties -- Connection Properties -- History Properties -- Database Mail -- Architecture -- Security -- Configuration -- Archiving -- Multiserver Administration.

Using Token Replacement -- Event Forwarding -- Using WMI -- Multiserver Administration - Using Master and Target Servers -- Summary -- Chapter 6: Service Broker in SQL Server 2012 -- Asynchronous Messaging -- SQL Service Broker Overview -- SQL Server Service Broker Versus Other Message Queues -- Configuring SQL Server Service Broker -- Enabling -- Message Types -- Contracts -- Queues -- Services -- Routes -- Priorities -- Conversation Groups -- Using SQL Server Service Broker -- Sending Messages -- Receiving Messages -- Sending Messages Between Databases -- Sending Messages Between Instances -- External Activation -- Summary -- Chapter 7: SQL Server CLR Integration -- Introduction to the CLR -- SQL Server as a .NET Runtime Host -- Application Domains -- T-SQL versus CLR -- Enabling CLR Integration -- Creating CLR Assemblies -- The Non-Visual Studio Way -- Using Microsoft SQL Server Data Tools -- Securing CLR -- Performance Monitoring -- Windows System Monitor -- SQL Profiler -- Dynamic Management Views (DMVs) -- CLR Integration Design Goals -- Summary -- Chapter 8: Securing the Database Instance -- Authentication Types -- SQL Authentication -- Windows Authentication -- SQL Versus Windows Authentication -- Authorizing Securables -- Server Securables -- Database Securables -- Permission Chains -- Cross Database Permission Chains -- Row Level Security -- Summary -- Chapter 9: Change Management -- Creating Solutions and Projects -- Creating a Connection -- Creating a Project Query -- Policy-Based Management -- Policy-Based Management Overview -- Policy-Based Management Step by Step -- Scripting Policy-Based Management -- Policy-Based Management Implementation -- DDL Trigger Syntax -- Database Triggers -- Server Triggers -- Trigger Views -- Scripting Overview -- sqlcmd -- PowerShell -- Creating Change Scripts -- Data-Tier Applications.

SQL Server Data Tools -- Version Tables -- Summary -- Chapter 10: Configuring the Server For Optimal Performance -- What Every DBA Needs to Know About Performance -- The Performance Tuning Cycle -- Defining Good Performance -- Focus on What's Most Important -- What the Developer DBA Needs to Know About Performance -- Users -- SQL Statements -- Data Usage Patterns -- Robust Schema -- What the Production DBA Needs to Know About Performance -- Optimizing the Server -- Hardware Management -- CPU -- x64 -- Cache -- Hyper-threading -- Multicore -- System Architecture -- Memory -- Physical Memory -- Physical Address Space -- Virtual Memory Manager -- The Page File -- Page Faults -- I/O -- Network -- Disks -- Storage Considerations -- Designing a Storage System -- Large Storage System Considerations: SAN Systems -- Server Configuration -- Fragmentation -- Summary -- Chapter 11: Optimizing SQL Server 2012 -- Application Optimization -- Defining a Workload -- System Harmony Is the Goal -- The Silent Killer: I/O Problems -- SQL Server I/O Process Model -- Database File Placement -- tempdb Considerations -- Table and Index Partitioning -- Why Consider Partitioning? -- Creating a Partition Function -- Creating Filegroups -- Creating a Partition Scheme -- Creating Tables and Indexes -- Data Compression -- Row Compression -- Page Compression -- Estimating Space Savings -- Monitoring Data Compression -- Data Compression Considerations -- CPU Considerations -- Cache Coherency -- Affinity Mask -- Max Degree of Parallelism (MAXDOP) -- Affinity I/O Mask -- Memory Considerations and Enhancements -- Tuning SQL Server Memory -- 64-bit Versions of SQL Server 2012 -- Data Locality -- Max Server Memory -- Index Creation Memory Option -- Minimum Memory per Query -- Resource Governor -- The Basic Elements of Resource Governor.

Using Resource Governor from SQL Server 2012 Management Studio -- Monitoring Resource Governor -- Summary -- Chapter 12: Monitoring Your SQL Server -- The Goal of Monitoring -- Determining Your Monitoring Objectives -- Establishing a Baseline -- Comparing Current Metrics to the Baseline -- Choosing the Appropriate Monitoring Tools -- Performance Monitor -- CPU Resource Counters -- Disk Activity -- Memory Usage -- Performance Monitoring Tools -- Monitoring Events -- The Default Trace -- system_health Session -- SQL Trace -- Event Notifications -- SQL Server Extended Events -- Monitoring with Dynamic Management Views and Functions -- What's Going on Inside SQL Server? -- Viewing the Locking Information -- Viewing Blocking Information -- Index Usage in a Database -- Indexes Not Used in a Database -- View Queries Waiting for Memory Grants -- Connected User Information -- Filegroup Free Space -- Query Plan and Query Text for Currently Running Queries -- Memory Usage -- Buffer Pool Memory Usage -- Monitoring Logs -- Monitoring the SQL Server Error Log -- Monitoring the Windows Event Logs -- Management Data Warehouse -- System Data Collection Sets -- Viewing Data Collected by the System Data Collection Sets -- Creating Your Own Data Collection Set -- Examining the Data You Collected -- SQL Server Standard Reports -- System Center Management Pack -- SQL Server Best Practice Analyzer -- System Center Advisor -- Summary -- Chapter 13: Performance Tuning T-SQL -- Physical Query Processing Part One: Compilation and Recompilation -- Compilation -- Recompilation -- Tools and Commands for Recompilation Scenarios -- Parser and Algebrizer -- Optimization -- Physical Query Processing Part Two: Execution -- Database I/O Information -- Working with the Query Plan -- Estimated Execution Plan -- Actual Execution Plan -- Index Access Methods -- Fragmentation -- Statistics.

Join Algorithms.