Book description
This book 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.
In this book, you'll find:
Table of contents
- Cover
- Title
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewers
-
Part I: Installing and Configuring SQL Server
-
Chapter 1: Planning the Deployment
- Editions and License Models
- Hardware Considerations
- Operating Systems Considerations
- Azure Options
-
Selecting Features
- Database Engine Service
- Analysis Services
- Reporting Services
- Reporting Services Add-in for SharePoint Products
- Data Quality Client
- Client Connectivity Tools
- Integration Services
- Client Tools Backward Compatibility
- Client Tools SDK
- Documentation Components
- Management Tools
- Distributed Replay Controller
- Distributed Replay Client
- SQL Client Connectivity SDK
- Master Data Services
- Summary
- Chapter 2: GUI Installation
- Chapter 3: Server Core Installation
- Chapter 4: Configuring the Instance
-
Chapter 1: Planning the Deployment
-
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: High Availability and Disaster Recovery Concepts
- Chapter 12: Implementing Clustering
- Chapter 13: Implementing AlwaysOn Availability Groups
- Chapter 14: Implementing Log Shipping
- Chapter 15: Backups and Restores
- 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 Maintenance Routines
- Chapter 22: Policy-Based Management
- Chapter 23: Resource Governor
- Chapter 24: Triggers
- Part V: Managing a Hybrid Cloud Environment
- Index
Product information
- Title: Pro SQL Server Administration
- Author(s):
- Release date: October 2015
- Publisher(s): Apress
- ISBN: 9781484207109
You might also like
book
Professional Microsoft SQL Server 2014 Administration
Learn to take advantage of the opportunities offered by SQL Server 2014 Microsoft's SQL Server 2014 …
book
Securing SQL Server, 3rd Edition
SQL server is the most widely-used database platform in the world, and a large percentage of …
book
SQL Server DMVs in Action
SQL Server DMVs in Action is a practical guide that shows you how to obtain, interpret, …
book
SQL Server AlwaysOn Revealed
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. …