Book Image

SQL Server 2017 Administrator's Guide

4 (1)

Book Image

SQL Server 2017 Administrator's Guide

4 (1)

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

Reader feedback

Customer support

Free Chapter

Setting up SQL Server 2017

Setting up SQL Server 2017

Microsoft SQL Server 2017 technology overview

Preparing for installation

Installation process

Keeping Your SQL Server Environment Healthy

Keeping Your SQL Server Environment Healthy

Understanding SQL Server patching

Post-installation configuration

Creating a performance baseline

Backup and Recovery

Backup and Recovery

Data structures and transaction logging

Securing Your SQL Server

Securing Your SQL Server

SQL Server service accounts

Authentication and authorization

Encrypting SQL Server data

Disaster Recovery Options

Disaster Recovery Options

Disaster recovery basics

SQL Server options for high availability and disaster recovery

Configuring replication on SQL Server

Database mirroring

Indexing and Performance

Indexing and Performance

Performance monitoring overview

Tools for monitoring performance

Indexes and maintenance

Troubleshooting SQL Server Environment and Internals

Troubleshooting SQL Server Environment and Internals

SQL Server protocols

Performance monitoring and tuning

Migration and Upgrade

Migration and Upgrade

Why migration is necessary

Planning the upgrade

Performing the upgrade

Migration from other platforms

Automation - Using Tools to Manage and Monitor SQL Server 2017

Automation - Using Tools to Manage and Monitor SQL Server 2017

Using SQL Server Agent

Maintenance plans

SQL Server Agent objects

Always On High Availability Features

Always On High Availability Features

Installing Windows Server Failover Cluster

Always On Failover Cluster Instances

Always On Availability Groups

In-Memory OLTP - Why and How to Use it

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

Combining SQL Server 2017 with Azure

Combining SQL Server 2017 with Azure

Overview of data related technologies in Microsoft Azure

Microsoft SQL Server 2017 and hybrid scenarios

Customer Reviews

4 (1)

5 star

0

4 star

100%

3 star

0

2 star

0

1 star

0

Summary

In this chapter, we have seen how to build a healthy SQL Server environment and how to configure not only the SQL Server, but also a Windows Server for stable and secure SQL Server workload. Keeping your server up to date, secure, and monitored is extremely crucial for the stability of the applications and your ability to perform any troubleshooting at the SQL Server level.

In the next chapter, we will build on our healthy SQL Server and introduce backup and recovery procedures so that you will understand how to keep your server safe and how to recover from failures.