Pro SQL Server Administration
- 12h 26m
- Peter A Carter
- Apress
- 2015
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
About the Author
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.
In this Book
-
Planning the Deployment
-
GUI Installation
-
Server Core Installation
-
Configuring the Instance
-
Files and Filegroups
-
Configuring Tables
-
Indexes and Statistics
-
Database Consistency
-
SQL Server Security Model
-
Encryption
-
High Availability and Disaster Recovery Concepts
-
Implementing Clustering
-
Implementing AlwaysOn Availability Groups
-
Implementing Log Shipping
-
Backups and Restores
-
Scaling Workloads
-
SQL Server Metadata
-
Locking and Blocking
-
Extended Events
-
Distributed Replay
-
Automating Maintenance Routines
-
Policy-Based Management
-
Resource Governor
-
Triggers
-
Cloud Backups and Restores
-
SQL Data Files in Windows Azure
-
Migrating to the Cloud
