Book Overview & Buying
Table Of Contents

SQL Server 2017 Administrator's Guide

By : Marek Chmel

3 (5)

Buy this Book

SQL Server 2017 Administrator's Guide

3 (5)

By: Marek Chmel

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

Creating a performance baseline

Once you have deployed and configured your SQL Server, you can create a performance baseline. This baseline is very important for you for numerous reasons and they are as follows:

When you start troubleshooting the server, you need to know how your server will behave to something odd
You can proactively tune the system if you find a weak spot in the baseline
When you plan to upgrade your server, you know how the load was increasing over time, so you can plan properly

Creating a performance baseline and capturing performance information for your server is hence a very crucial task and should be deployed to each of your servers. There are numerous sources that you can use to collect useful information about your SQL Server and these include the following: