Read more
Introduces the skills required to administer SQL server 2014, including security, performance optimization, monitoring, backups, AlwaysOn availability groups, and the cardinality estimator, with real-world case examples and solutions.
List of contents
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
Report
"If you want a good, wide ranging, general SQL Server 2014 administration book, I can certainly recommend this book" (I Programmer, October 2014)
