Professional Microsoft SQL Server 2014 Administration (+code)КНИГИ » ОС И БД
Название: Professional Microsoft SQL Server 2014 Administration Издательство: WROX Автор: Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen Год: 2014 Количество страниц:935 Язык: English Формат:True PDF +code Размер:50 Mb Learn to take advantage of the opportunities offered by SQL Server 2014
Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes.
Improve oversight with better management and monitoring
Protect your work with enhanced security features
Upgrade performance tuning, scaling, replication, and clustering
Learn new options for backup and recovery
Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier. Stop getting frustrated with administrative issues and start taking control. Professional Microsoft SQL Server 2014 is your roadmap to mastering the update and creating solutions that work. Table of Contents
Cover Chapter 1: SQL Server 2014 Architecture SQL SERVER 2014 ECOSYSTEM NEW IMPORTANT FEATURES IN 2014 SQL SERVER ARCHITECTURE EDITIONS OF SQL SERVER SUMMARY Chapter 2: Installing SQL Server 2014 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 2014 Best Practices WHY UPGRADE TO SQL SERVER 2014? UPGRADING TO SQL SERVER 2014 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 SQL SERVER 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 MULTISERVER ADMINISTRATION SUMMARY Chapter 6: Service Broker in SQL Server 2014 ASYNCHRONOUS MESSAGING CONFIGURING SQL SERVER SERVICE BROKER USING SQL SERVER SERVICE BROKER SUMMARY Chapter 7: SQL Server CLR Integration INTRODUCTION TO CLR CREATING CLR ASSEMBLIES CLR INTEGRATION SECURITY PERFORMANCE MONITORING SUMMARY Chapter 8: Securing the Database Instance AUTHENTICATION TYPES LOGINS AND USERS AUTHORIZING SECURABLES ROW-LEVEL SECURITY SUMMARY Chapter 9: In-Memory OLTP USING AND IMPLEMENTING IN-MEMORY OLTP CREATING NATIVELY COMPILED STORED PROCEDURES OVERVIEW OF THE ANALYZE, MIGRATE, AND REPORT (ARM) TOOL 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 2014 APPLICATION OPTIMIZATION THE SILENT KILLER: I/O PROBLEMS SQL SERVER INTERNALS AND FILE ALLOCATIONS TABLE AND INDEX PARTITIONING DATA COMPRESSION UNDERSTANDING SQL SERVER AND CPUs 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 SQL SERVER STANDARD REPORTS SYSTEM CENTER ADVISOR SUMMARY Chapter 13: Performance Tuning T-SQL OVERVIEW OF QUERY PROCESSING IDENTIFYING SQL QUERY PERFORMANCE TUNING ISSUES DATA ACCESS OPERATORS IN QUERY PLANS JOIN OPERATORS DATA MODIFICATION QUERY PLAN ANALYZING QUERY PERFORMANCE IN A PRODUCTION ENVIRONMENT PUTTING IT ALL TOGETHER SUMMARY Chapter 14: Indexing Your Database WHAT'S NEW FOR INDEXES IN SQL SERVER 2014 ABOUT INDEXES AND PARTITIONED TABLES INDEX MAINTENANCE IMPROVING QUERY PERFORMANCE WITH INDEXES DATABASE TUNING ADVISOR SUMMARY Chapter 15: Replication REPLICATION OVERVIEW REPLICATION MODELS IMPLEMENTING REPLICATION PEER-TO-PEER REPLICATION SCRIPTING REPLICATION MONITORING REPLICATION SUMMARY Chapter 16: Clustering SQL Server 2014 CLUSTERING AND YOUR ORGANIZATION CLUSTERING: THE BIG PICTURE UPGRADING SQL SERVER CLUSTERING GETTING PREPARED FOR CLUSTERING CLUSTERING WINDOWS SERVER 2012 R2 CLUSTERING MICROSOFT DISTRIBUTED TRANSACTION COORDINATOR CLUSTERING SQL SERVER 2014 MANAGING AND MONITORING THE CLUSTER TROUBLESHOOTING CLUSTER PROBLEMS SUMMARY Chapter 17: Backup and Recovery BACKUP AND RESTORE ENHANCEMENTS 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 2014 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 2014 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 2014 EDITIONS DATABASE MIRRORING ROLE CHANGE MONITORING USING DATABASE MIRRORING MONITOR PREPARING THE MIRROR SERVER FOR FAILOVER DATABASE MIRRORING AND OTHER HIGH-AVAILABILITY SOLUTIONS 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 SUMMARY Chapter 22: SQL Server Reporting Services Administration SQL SERVER REPORTING SERVICES CONFIGURATION MANAGER THE REPORT EXECUTION LOG REPORT MANAGER SUMMARY Chapter 23: SQL Server 2014 SharePoint 2013 Integration COMPONENTS OF INTEGRATION DATA REFRESH SUMMARY Chapter 24: SQL Database Administration and Configuration GETTING TO KNOW WINDOWS AZURE SQL DATABASE SQL DATABASE ARCHITECTURE CONFIGURING SQL DATABASE ADMINISTERING SQL DATABASE WORKING WITH SQL DATABASE WHAT'S MISSING IN SQL DATABASE 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 Who This Book Is For How This Book Is Structured What You Need to Use This Book Conventions Source Code Advertisement End User License Agreement
Навигация
Вход на сайт
Реклама
Professional Microsoft SQL Server 2014 Administration (+code) 
