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

Performing the upgrade

Once you have finished the planning phase and all preparations it's time to perform the upgrade/migration of your SQL Server environment. For the scenario used in this chapter, we'll upgrade an existing SQL Server 2016 to SQL Server 2017. One thing you also need to carefully consider is the edition upgrade path, which you need to follow.

We will be upgrading Enterprise Edition and the Edition will stay the same after the upgrade. You can, however, upgrade between editions. You can find the whole edition and version upgrade matrix on Microsoft's website at https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades where you can see what versions and editions can be upgraded.

In the next steps, we will consider the in-place upgrade of the SQL Server first. Once we have started the SQL Server...

Previous Section
End of Section 4
Next Section