Efnisyfirlit

• 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
• Errata
• p2p.wrox.com
• Advertisement
• End User License Agreement