Book Overview & Buying
Table Of Contents
Feedback & Rating

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

Customer Reviews

3 (5)

5 star

20%

4 star

40%

3 star

2 star

1 star

40%

Setting up SQL Server 2017

Microsoft SQL Server is not just a database engine, it has become a very complex and robust technology set for data management, analysis, and visualizations over the years. As the progress of technologies incorporated with SQL Server grows, it is more complicated to decide which specific technology is actually needed, how to prepare the environment for its installation, and which configuration properties administrators should be aware of.

In this chapter, we will cover the following topics:

Microsoft SQL Server 2017 technology overview: What SQL Server technology set contains and what is the purpose of each technology
Preparing for installation: Which prerequisites and preinstallation steps are needed
Installation process: What happens during installation, which settings are the most important ones, and which post-installation steps are necessary and recommended