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 Always On 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 Lo Forte, 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.
Inhaltsverzeichnis
INTRODUCTION xxxvii
CHAPTER 1: SQL SERVER 2014 ARCHITECTURE 1
CHAPTER 2: INSTALLING SQL SERVER 2014 BEST PRACTICES 23
CHAPTER 3: UPGRADING SQL SERVER 2014 BEST PRACTICES 57
CHAPTER 4: MANAGING AND TROUBLESHOOTING THE DATABASE ENGINE 79
CHAPTER 5: AUTOMATING SQL SERVER 113
CHAPTER 6: SERVICE BROKER IN SQL SERVER 2014 155
CHAPTER 7: SQL SERVER CLR INTEGRATION 185
CHAPTER 8: SECURING THE DATABASE INSTANCE 199
CHAPTER 9: IN-MEMORY OLTP 215
CHAPTER 10: CONFIGURING THE SERVER FOR OPTIMAL PERFORMANCE 247
CHAPTER 11: OPTIMIZING SQL SERVER 2014 281
CHAPTER 12: MONITORING YOUR SQL SERVER 325
CHAPTER 13: PERFORMANCE TUNING T-SQL 391
CHAPTER 14: INDEXING YOUR DATABASE 425
CHAPTER 15: REPLICATION 449
CHAPTER 16: CLUSTERING SQL SERVER 2014 491
CHAPTER 17: BACKUP AND RECOVERY 535
CHAPTER 18: SQL SERVER 2014 LOG SHIPPING 593
CHAPTER 19: DATABASE MIRRORING 629
CHAPTER 20: INTEGRATION SERVICES ADMINISTRATION AND PERFORMANCE TUNING 667
CHAPTER 21: ANALYSIS SERVICES ADMINISTRATION AND PERFORMANCE TUNING 701
CHAPTER 22: SQL SERVER REPORTING SERVICES ADMINISTRATION 725
CHAPTER 23: SQL SERVER 2014 SHAREPOINT 2013 INTEGRATION 763
CHAPTER 24: SQL DATABASE ADMINISTRATION AND CONFIGURATION 789
CHAPTER 25: ALWAYSON AVAILABILITY GROUPS 813
INDEX 849
Über den Autor
Adam Jorgensen is the President of Pragmatic Works and
the Executive Vice President of PASS with more than 15 years
experience.
Bradley Ball is a MCITP 2005, 2008, and 2012 MCSE DBA
with more than a decade of experience who is currently the Data
Platform Management Lead with Pragmatic Works specializing in Data
Platform solutions.
Steven Wort has been working with SQL Server since 1993,
who joined Microsoft in 2000, and now works as an Architect in the
CRM Service Engineering team.
Ross Lo Forte is a Technology Architect at the Microsoft
Technology Center Chicago focused on Microsoft SQL Server
solutions, with more than 20 years of business development, project
management, and SQL experience.
Brian Knight is the founder of Pragmatic Works and
co-founder of SQLServer Central.com and Jump Start TV.com
Wrox Professional guides are planned and written by
working programmers to meet the real-world needs of programmers,
developers, and IT professionals. Focused and relevant, they
address the issues technology professionals face every day. They
provide examples, practical solutions, and expert education in new
technologies, all designed to help programmers do a better job.
Ebooks vom selben Autor / Herausgeber
16.516 Ebooks in dieser Kategorie
