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.

Related Content you might be interested in

Current Title:

Small book image
SQL Server 2017 Administrator's Guide
Dec, 2017 | 434 pages
Small book image
SQL Server on Azure Virtual Machines
Tim Radney | Anthony Nocentino | John Martin | Randolph West | Joey DAntoni | Louis Davidson | Allan Hirt
Jun, 2020 | 200 pages
Small book image
Introducing Microsoft SQL Server 2019
Dave Noderer | Gregory Woody | Kellyn Gorman | James RowlandJones | Mitchell Pearson | Dustin Ryan | Allan Hirt | Arun Sirpal
Apr, 2020 | 488 pages
Small book image
SQL Server on Linux
Jasmin Azemoviá
Aug, 2017 | 222 pages
Table of Contents (13 chapters)
Preface
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
Setting up SQL Server 2017
Setting up SQL Server 2017
Microsoft SQL Server 2017 technology overview
Preparing for installation
Installation process
Summary
2
Keeping Your SQL Server Environment Healthy
Keeping Your SQL Server Environment Healthy
Understanding SQL Server patching
Post-installation configuration
Creating a performance baseline
Summary
3
Backup and Recovery
Backup and Recovery
Data structures and transaction logging
Backup
Restore
Summary
4
Securing Your SQL Server
Securing Your SQL Server
SQL Server service accounts
Authentication and authorization
Encrypting SQL Server data
Summary
5
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
Log shipping
Summary
6
Indexing and Performance
Indexing and Performance
Performance monitoring overview
Tools for monitoring performance
Indexes and maintenance
Summary
7
Troubleshooting SQL Server Environment and Internals
Troubleshooting SQL Server Environment and Internals
SQL Server protocols
Performance monitoring and tuning
Summary
8
Migration and Upgrade
Migration and Upgrade
Why migration is necessary
Planning the upgrade
Performing the upgrade
Migration from other platforms
Summary
9
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
Summary
10
Always On High Availability Features
Always On High Availability Features
Installing Windows Server Failover Cluster
Always On Failover Cluster Instances
Always On Availability Groups
Summary
11
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
Summary
12
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
Summary

Microsoft SQL Server 2017 and hybrid scenarios

While the previous section showed several clear Azure deployments of SQL Server, SQL Server is traditionally hosted on-premise. As the data contention grows over time, administrators face a challenge of handling the increased storage space needed for data or for backups as well as with RTO and RPO objectives.

Migration to Azure environment is not always easy or possible at all. That's why Microsoft incorporated many enhancements to SQL Server to help DBAs to succeed when challenging mentioned situations. In the following sections, we will go through these enhancements and show how to use them. Every section contains appropriate situations for using them, and also a detailed description of the implementation.

The first described feature was introduced in SQL Server 2016, continues in SQL Server 2017, and it is called StretchDB...

Previous Section
End of Section 3
Next Section