Book description
Conquer SQL Server 2017 administration—from the inside out
Dive into SQL Server 2017 administration—and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery.
• Install, customize, and use SQL Server 2017’s key administration and development tools
• Manage memory, storage, clustering, virtualization, and other components
• Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations
• Provision SQL Server and Azure SQL databases
• Secure SQL Server via encryption, row-level security, and data masking
• Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing
• Establish SQL Server IaaS network security groups and user-defined routes
• Administer SQL Server user security and permissions
• Efficiently design tables using keys, data types, columns, partitioning, and views
• Utilize BLOBs and external, temporal, and memory-optimized tables
• Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans
• Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments
For Experienced SQL Server Administrators and Other Database Professionals
• Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert
• Prerequisites: Basic understanding of database administration procedures
Table of contents
- Cover Page
- Title Page
- Copyright Page
- Dedication
- Table of Contents
- Foreword
- Introduction
- Chapter 1 Getting started with SQL Server tools
- Chapter 2 Introducing database server components
- Chapter 3 Designing and implementing a database infrastructure
- Chapter 4 Provisioning databases
- Chapter 5 Provisioning Azure SQL Database
- Chapter 6 Administering security and permissions
- Chapter 7 Securing the server and its data
- Chapter 8 Understanding and designing tables
- Chapter 9 Performance tuning SQL Server
- Chapter 10 Understanding and designing indexes
- Chapter 11 Developing, deploying, and managing data recovery
- Chapter 12 Implementing high availability and disaster recovery
-
Chapter 13 Managing and monitoring SQL Server
- Detecting database corruption
- Maintaining indexes and statistics
- Maintaining database file sizes
- Monitoring databases by using DMVs
- Reintroducing extended events
- Capturing Windows performance metrics with DMVs and data collectors
- Protecting important workloads using Resource Governor
- Understanding the new servicing model
- Chapter 14 Automating SQL Server administration
- Index
- About the authors
- About the Foreword author
- Code Snippets
Product information
- Title: SQL Server 2017 Administration Inside Out, First Edition
- Author(s):
- Release date: February 2018
- Publisher(s): Microsoft Press
- ISBN: 9781509305230
You might also like
video
SQL Server 2017 Administration Inside Out
8+ Hours of Video Instruction A comprehensive guide to provisioning, managing, and securing SQL Server 2017 …
book
SQL Server 2019 Administration Inside Out
Conquer SQL Server 2019 administration–from the inside out Dive into SQL Server 2019 administration–and really put …
book
SQL Server 2022 Administration Inside Out
Conquer SQL Server 2022 and Azure SQL administration from the inside out! Dive into SQL Server …
book
SQL Server 2019 Administrator's Guide - Second Edition
Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is …