Professional Microsoft SQL Server 2014 Administration

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.

Learn to take advantage of the opportunities offered by SQLServer 2014Microsoft's SQL Server 2014 update means big changes fordatabase administrators, and you need to get up to speed quicklybecause your methods, workflow, and favorite techniques will bedifferent from here on out. The update's enhanced support oflarge-scale enterprise databases and significant price advantagemean that SQL Server 2014 will become even more widely adoptedacross the industry. The update includes new backup and recoverytools, new AlwaysOn features, and enhanced cloud capabilities.In-memory OLTP, Buffer Pool Extensions for SSDs, and a newCardinality Estimator can improve functionality and smooth out theworkflow, but only if you understand their full capabilities.Professional Microsoft SQL Server 2014 is your comprehensiveguide to working with the new environment. Authors Adam JorgensenBradley Ball, Ross LoForte, Steven Wort, and Brian Knight are thedream team of the SQL Server community, and they put theirexpertise 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, andclustering* Learn new options for backup and recoveryProfessional Microsoft SQL Server 2014 includes acompanion website with sample code and efficient automationutilities, plus a host of tips, tricks, and workarounds that willmake your job as a DBA or database architect much easier. Stopgetting frustrated with administrative issues and start takingcontrol. Professional Microsoft SQL Server 2014 is yourroadmap to mastering the update and creating solutions thatwork.

INTRODUCTION xxxviiCHAPTER 1: SQL SERVER 2014 ARCHITECTURE 1CHAPTER 2: INSTALLING SQL SERVER 2014 BEST PRACTICES 23CHAPTER 3: UPGRADING SQL SERVER 2014 BEST PRACTICES 57CHAPTER 4: MANAGING AND TROUBLESHOOTING THE DATABASE ENGINE 79CHAPTER 5: AUTOMATING SQL SERVER 113CHAPTER 6: SERVICE BROKER IN SQL SERVER 2014 155CHAPTER 7: SQL SERVER CLR INTEGRATION 185CHAPTER 8: SECURING THE DATABASE INSTANCE 199CHAPTER 9: IN-MEMORY OLTP 215CHAPTER 10: CONFIGURING THE SERVER FOR OPTIMAL PERFORMANCE 247CHAPTER 11: OPTIMIZING SQL SERVER 2014 281CHAPTER 12: MONITORING YOUR SQL SERVER 325CHAPTER 13: PERFORMANCE TUNING T-SQL 391CHAPTER 14: INDEXING YOUR DATABASE 425CHAPTER 15: REPLICATION 449CHAPTER 16: CLUSTERING SQL SERVER 2014 491CHAPTER 17: BACKUP AND RECOVERY 535CHAPTER 18: SQL SERVER 2014 LOG SHIPPING 593CHAPTER 19: DATABASE MIRRORING 629CHAPTER 20: INTEGRATION SERVICES ADMINISTRATION AND PERFORMANCE TUNING 667CHAPTER 21: ANALYSIS SERVICES ADMINISTRATION AND PERFORMANCE TUNING 701CHAPTER 22: SQL SERVER REPORTING SERVICES ADMINISTRATION 725CHAPTER 23: SQL SERVER 2014 SHAREPOINT 2013 INTEGRATION 763CHAPTER 24: SQL DATABASE ADMINISTRATION AND CONFIGURATION 789CHAPTER 25: ALWAYSON AVAILABILITY GROUPS 813INDEX 849