Log In
Or create an account -> 
Imperial Library
  • Home
  • About
  • News
  • Upload
  • Forum
  • Help
  • Login/SignUp

Index
Cover Contents Chapter 1: SQL Server 2012 Architecture
SQL Server 2012 Ecosystem New Important Features in 2012 SQL Server Architecture Editions of SQL Server Summary
Chapter 2: Installing SQL Server 2012 Best Practices
Planning the System Installing SQL Server Installing Analysis Services Installing PowerPivot for SharePoint Burning in the System Post-Install Configuration Uninstalling SQL Server Troubleshooting a Failed Install Summary
Chapter 3: Upgrading SQL Server 2012 Best Practices
Why Upgrade to SQL Server 2012? Upgrading to SQL Server 2012 Pre-Upgrade Steps and Tools Backward Compatibility SQL Server Component Considerations Post-Upgrade Checks Summary
Chapter 4: Managing and Troubleshooting the Database Engine
Configuration and Administration Tools Troubleshooting Tools Management Studio Monitoring Processes in T-SQL Multiserver Management Trace Flags Getting Help from Support Summary
Chapter 5: Automating SQL Server
Maintenance Plans Automating SQL Server with SQL Server Agent SQL Server Agent Security Configuring SQL Server Agent Database Mail Multiserver Administration Summary
Chapter 6: Service Broker in SQL Server 2012
Asynchronous Messaging Configuring SQL Server Service Broker Using SQL Server Service Broker Summary
Chapter 7: SQL Server CLR Integration
Introduction to the CLR Creating CLR Assemblies Securing CLR Performance Monitoring Summary
Chapter 8: Securing the Database Instance
Authentication Types Authorizing Securables Row Level Security Summary
Chapter 9: Change Management
Creating Solutions and Projects Policy-Based Management DDL Trigger Syntax Trigger Views Scripting Overview Creating Change Scripts Data-Tier Applications Summary
Chapter 10: Configuring the Server for Optimal Performance
What Every DBA Needs to Know About Performance What the Developer DBA Needs to Know About Performance What the Production DBA Needs to Know About Performance CPU Memory I/O Summary
Chapter 11: Optimizing SQL Server 2012
Application Optimization The Silent Killer: I/O Problems Table and Index Partitioning Data Compression CPU Considerations Memory Considerations and Enhancements Resource Governor Summary
Chapter 12: Monitoring Your SQL Server
The Goal of Monitoring Choosing the Appropriate Monitoring Tools Performance Monitor Monitoring Events Monitoring with Dynamic Management Views and Functions Monitoring Logs Management Data Warehouse 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 Physical Query Processing Part Two: Execution Summary
Chapter 14: Indexing Your Database
Noteworthy Index-Related Features in SQL Server Partitioned Tables and Indexes Index Maintenance Improving Query Performance with Indexes Database Tuning Advisor Too Many Indexes? Summary
Chapter 15: Replication
Replication Overview Replication Models Implementing Replication Peer-to-Peer Replication Scripting Replication Monitoring Replication Summary
Chapter 16: Clustering SQL Server 2012
Clustering and Your Organization Clustering: The Big Picture Upgrading SQL Server Clustering Getting Prepared for Clustering Clustering Windows Server 2008 Clustering Microsoft Distributed Transaction Coordinator Clustering SQL Server 2012 Managing and Monitoring the Cluster Troubleshooting Cluster Problems Summary
Chapter 17: Backup and Recovery
Types of Failure Making Plans Overview of Backup and Restore Preparing for Recovery Developing and Executing a Backup Plan Managing Backups Backup and Restore Performance Performing Recovery Archiving Data Summary
Chapter 18: SQL Server 2012 LOG Shipping
Log Shipping Deployment Scenarios Log-Shipping Architecture Log Shipping Process System Requirements Deploying Log Shipping Monitoring and Troubleshooting Managing Changing Roles Database Backup Plan Integrating Log Shipping with Other High-Availability Solutions Removing Log Shipping Log-Shipping Performance Upgrading to SQL Server 2012 Log Shipping Summary
Chapter 19: Database Mirroring
Overview of Database Mirroring Operating Modes of Database Mirroring Database Mirroring In Action Database Mirroring and SQL Server 2012 Editions Database Mirroring Catalog Views Database Mirroring Role Change Database Availability Scenarios Monitoring Database Mirroring Troubleshooting Database Mirroring Preparing the Mirror Server for Failover Mirroring Multiple Databases Database Mirroring and Other High-Availability Solutions Mirroring Event Listener Setup Database Snapshots Summary
Chapter 20: Integration Services Administration and Performance Tuning
A Tour of Integration Services Administration of the Integration Services Service Administration of Integration Services Packages in Package Deployment Model Administration of Integration Services Packages in Project Deployment Model Execution and Scheduling Applying Security to Integration Services Summary
Chapter 21: Analysis Services Administration and Performance Tuning
Tour of Analysis Services Administering Analysis Services Server Administering Analysis Services Databases Analysis Services Performance Monitoring and Tuning Management of Analysis Services MOLAP Model Storage Applying Security to Analysis Services in the MOLAP Model Summary
Chapter 22: SQL Server Reporting Services Administration
SQL Server Reporting Services Configuration Manager Report Server Properties The Report Execution Log Report Builder Report Manager Summary
Chapter 23: SQL Server 2012 Sharepoint 2010 Integration
Components of Integration Data Refresh
Chapter 24: SQL Azure Administration and Configuration
Introduction to SQL Azure SQL Azure Architecture Configuring SQL Azure Administering SQL Azure Working with SQL Azure What’s Missing in SQL Azure Summary
Chapter 25: Alwayson Availability Groups
Architecture Availability Group Example Active Secondary for Secondary Read-Only Backup on the Secondary Replica AlwaysOn Group Dashboard Monitoring and Troubleshooting Summary
Introduction Advertisement
  • ← Prev
  • Back
  • Next →
  • ← Prev
  • Back
  • Next →

Chief Librarian: Las Zenow <zenow@riseup.net>
Fork the source code from gitlab
.

This is a mirror of the Tor onion service:
http://kx5thpx2olielkihfyo4jgjqfb7zx7wxr3sd4xzt26ochei4m6f7tayd.onion