Pro SQL Server Administration

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 AlwaysOn 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 AlwaysOn and in-memory support

• Comprehensive coverage of key skills, such as monitoring, maintenance and indexing

Auteur
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.

Contenu

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 AlwaysOn Availability 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 EventsChapter 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