Book Overview & Buying
Table Of Contents

SQL Server 2017 Administrator's Guide

3 (5)

Buy this Book

SQL Server 2017 Administrator's Guide

3 (5)

Buy this Book

Overview of this book

Take advantage of the real power of SQL Server 2017 with all its new features, in addition to covering core database administration tasks. This book will give you a competitive advantage by helping you quickly learn how to design, manage, and secure your database solution. You will learn how to set up your SQL Server and configure new (and existing) environments for optimal use. After covering the designing aspect, the book delves into performance-tuning aspects by teaching you how to effectively use indexes. The book will also teach you about certain choices that need to be made about backups and how to implement a rock-solid security policy and keep your environment healthy. Finally, you will learn about the techniques you should use when things go wrong, and other important topics, such as migration, upgrading, and consolidation, are covered in detail. Integration with Azure is also covered in depth. Whether you are an administrator or thinking about entering the field, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2017.

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

Setting up SQL Server 2017

Microsoft SQL Server 2017 technology overview

Preparing for installation

Installation process

Summary

Keeping Your SQL Server Environment Healthy

Understanding SQL Server patching

Post-installation configuration

Creating a performance baseline

Summary

Backup and Recovery

Data structures and transaction logging

Backup

Restore

Summary

Securing Your SQL Server

SQL Server service accounts

Authentication and authorization

Encrypting SQL Server data

Summary

Disaster Recovery Options

Disaster recovery basics

SQL Server options for high availability and disaster recovery

Configuring replication on SQL Server

Database mirroring

Log shipping

Summary

Indexing and Performance

Performance monitoring overview

Tools for monitoring performance

Indexes and maintenance

Summary

Troubleshooting SQL Server Environment and Internals

SQL Server protocols

Performance monitoring and tuning

Summary

Migration and Upgrade

Why migration is necessary

Planning the upgrade

Performing the upgrade

Migration from other platforms

Summary

Automation - Using Tools to Manage and Monitor SQL Server 2017

Using SQL Server Agent

Maintenance plans

SQL Server Agent objects

Summary

Always On High Availability Features

Installing Windows Server Failover Cluster

Always On Failover Cluster Instances

Always On Availability Groups

Summary

In-Memory OLTP - Why and How to Use it

In-Memory OLTP architecture

Creating In-Memory tables and natively compiled stored procedures

In-Memory OLTP usage scenarios

Summary

Combining SQL Server 2017 with Azure

Overview of data related technologies in Microsoft Azure

Microsoft SQL Server 2017 and hybrid scenarios

Summary

Securing Your SQL Server

Securing SQL Server is a crucial task, as SQL Server usually holds very important and sensitive information in your environment. You need to apply many principles in order to properly secure your databases. Fortunately, SQL Server offers you many options in order to help you with securing your data stored on the SQL Server. Securing a SQL Server is quite a complex task; you need to consider that SQL Server is a client application running on the Windows server, which is accessible via a network. In order to fully secure the environment, you need to secure the Windows OS too and put proper security measures on the network as well.

In this chapter, we will be covering the following topics: