Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014.
You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as Always On to make your instance highly available. Also covered is the use of SQL Server features to scale out read-only workloads. Pro SQL Server Administration is an all-new book taking up-to-date and modern approach that you’ll want and need to further your career as a SQL Server database administrator.
- Extensive coverage of hybrid cloud environments involving Azure SQL Database
- Detailed discussions on all new, key features, including Always On and in-memory support
- Comprehensive coverage of key skills, such as monitoring, maintenance and indexing
Daftar Isi
Part I: Installing and Configuring SQL Server.- Chapter 1: Planning the Deployment.- Chapter 2: GUI Installation.- Chapter 3: Server Core Installation.- Chapter 4: Configuring the Instance.- Part II: Database Administration.- Chapter 5: Files and Filegroups.- Chapter 6: Configuring Tables.- Chapter 7: Indexes and Statistics.- Chapter 8: Database Consistency.- Part III: Security, Resilience, and Scaling.- Chapter 9: SQL Server Security Model.- Chapter 10: Encryption.- Chapter 11: HA and DR Concepts.- Chapter 12: Implementing Clustering.- Chapter 13: Implementing Always On Availabi
lity Groups.- Chapter 14: Implementing Log Shipping.- Chapter 15: Backups and Restore.- Chapter 16: Scaling Workloads.-Part IV: Monitoring and Maintenance.- Chapter 17: SQL Server Metadata.- Chapter 18: Locking and Blocking.- Chapter 19: Extended Events.- Chapter 20: Distributed Replay.- Chapter 21: Automating Routine Maintenance.- Chapter 22: Policy-Based Management.- Chapter 23: Resource Governor.- Chapter 24: Triggers.-
Part V: Managing a Hybrid Cloud Environment.- Chapter 25: Cloud Backups and Restores.- Chapter 26: Storing Data Files in Windows Azure.- Chapter 27: Migrating to the Cloud
Tentang Penulis
Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, to sit alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005, onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.
Ebook lainnya dari penulis yang sama / Editor
16,642 Ebooks dalam kategori ini
