Learn to take advantage of the opportunities offered by SQL Server 2014Microsoft'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.
Chapter 1: SQL Server 2014 Architecture
SQL SERVER 2014 ECOSYSTEM
NEW IMPORTANT FEATURES IN 2014
SQL SERVER ARCHITECTURE
EDITIONS OF SQL SERVER
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
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
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
Chapter 5: Automating SQL Server
MAINTENANCE PLANS
AUTOMATING SQL SERVER WITH SQL SERVER AGENT
SQL SERVER AGENT SECURITY
CONFIGURING SQL SERVER AGENT
MULTISERVER ADMINISTRATION
Chapter 6: Service Broker in SQL Server 2014
ASYNCHRONOUS MESSAGING
CONFIGURING SQL SERVER SERVICE BROKER
USING SQL SERVER SERVICE BROKER
Chapter 7: SQL Server CLR Integration
INTRODUCTION TO CLR
CREATING CLR ASSEMBLIES
CLR INTEGRATION SECURITY
PERFORMANCE MONITORING
Chapter 8: Securing the Database Instance
AUTHENTICATION TYPES
LOGINS AND USERS
AUTHORIZING SECURABLES
ROW-LEVEL SECURITY
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
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
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
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
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
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
Chapter 15: Replication
REPLICATION OVERVIEW
REPLICATION MODELS
IMPLEMENTING REPLICATION
PEER-TO-PEER REPLICATION
SCRIPTING REPLICATION
MONITORING REPLICATION
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
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
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
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
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
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
Chapter 22: SQL Server Reporting Services Administration
SQL SERVER REPORTING SERVICES CONFIGURATION MANAGER
THE REPORT EXECUTION LOG
REPORT MANAGER
Chapter 23: SQL Server 2014 SharePoint 2013 Integration
COMPONENTS OF INTEGRATION
DATA REFRESH
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
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
SQL SERVER 2014 ECOSYSTEM
NEW IMPORTANT FEATURES IN 2014
SQL SERVER ARCHITECTURE
EDITIONS OF SQL SERVER
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
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
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
Chapter 5: Automating SQL Server
MAINTENANCE PLANS
AUTOMATING SQL SERVER WITH SQL SERVER AGENT
SQL SERVER AGENT SECURITY
CONFIGURING SQL SERVER AGENT
MULTISERVER ADMINISTRATION
Chapter 6: Service Broker in SQL Server 2014
ASYNCHRONOUS MESSAGING
CONFIGURING SQL SERVER SERVICE BROKER
USING SQL SERVER SERVICE BROKER
Chapter 7: SQL Server CLR Integration
INTRODUCTION TO CLR
CREATING CLR ASSEMBLIES
CLR INTEGRATION SECURITY
PERFORMANCE MONITORING
Chapter 8: Securing the Database Instance
AUTHENTICATION TYPES
LOGINS AND USERS
AUTHORIZING SECURABLES
ROW-LEVEL SECURITY
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
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
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
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
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
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
Chapter 15: Replication
REPLICATION OVERVIEW
REPLICATION MODELS
IMPLEMENTING REPLICATION
PEER-TO-PEER REPLICATION
SCRIPTING REPLICATION
MONITORING REPLICATION
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
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
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
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
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
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
Chapter 22: SQL Server Reporting Services Administration
SQL SERVER REPORTING SERVICES CONFIGURATION MANAGER
THE REPORT EXECUTION LOG
REPORT MANAGER
Chapter 23: SQL Server 2014 SharePoint 2013 Integration
COMPONENTS OF INTEGRATION
DATA REFRESH
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
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
No comments:
Post a Comment