You're reading from SQL Server 2019 Administrator's Guide A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions

Product type Paperback

Published in Sep 2020

Publisher Packt

ISBN-13 9781789954326

Length 522 pages

Edition 2nd Edition

Languages

SQL

Tools

SQL Server

Concepts

Database Administration

Authors (2):

Marek Chmel

Vladimír Mužný

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Provisioning the SQL Server Environment

2. Chapter 1: Setting Up SQL Server 2019 FREE CHAPTER

3. Chapter 2: Keeping Your SQL Server Environment Healthy

4. Section 2: Server and Database Maintenance

5. Chapter 3: Implementing Backup and Recovery

6. Chapter 4: Securing Your SQL Server

7. Chapter 5: Working with Disaster Recovery Options

8. Chapter 6: Indexing and Performance

9. Section 3: High Availability and the Cloud with SQL Server 2019

10. Chapter 7: Planning Migration and Upgrade

11. Chapter 8: Automation – Using Tools to Manage and Monitor SQL Server 2019

12. Chapter 9: Configuring Always On High Availability Features

13. Chapter 10: In-Memory OLTP – Why and How to Use it

14. Chapter 11: Combining SQL Server 2019 with Azure

15. Chapter 12: Taming Big Data with SQL Server

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

The importance of keeping up with latest version

An important reason to upgrade is to continue to obtain the latest support for SQL Server. Once the mainstream support for SQL Server ends, there will be no more service packs or cumulative updates bringing fixes and updates to your current version of SQL Server.

As you can see from the following table, just three SQL Server versions are supported as of now (summer 2020) and those are SQL Server 2016, SQL Server 2017, and the current SQL Server 2019:

Fig. 7.1 – SQL version support end dates

Although many of the older versions are not supported anymore, this does not mean they are not used in production environments. The preceding table does not list all the SQL Server versions. There are even older systems that can be used today, but those fell out of support a long time ago. Also, note that SQL Server 2008 and SQL Server 2008 R2 share an end date for mainstream support, although...