SQL Server 2019: What’s New - New and Enhanced Features

Understand the key features introduced and enhanced in SQL Server 2019 and see how this release expanded the SQL Server platform.

This focused course is designed for database professionals who already understand SQL Server fundamentals and want to explore the capabilities that defined the SQL Server 2019 release.

You will examine improvements across performance, security, availability, development, administration, and Linux support, with explanations and practical demonstrations that help connect each feature with its purpose.

Explore What Changed in SQL Server 2019

Every major SQL Server release introduces new capabilities and improvements to existing functionality.

SQL Server 2019 brought important enhancements across several areas of the platform, making it useful to understand not only what changed, but why those changes mattered.

Throughout the course, you will explore feature areas such as:

• SQL Server 2019 platform enhancements.

• Intelligent Query Processing.

• Performance improvements.

• Security enhancements.

• Availability-related features.

• Database-development improvements.

• SQL Server administration topics.

• Monitoring concepts.

• SQL Server on Linux.

• Additional SQL Server 2019 features and special topics.

The goal is to give you a structured understanding of the release rather than simply presenting a list of new features.

Understand Intelligent Query Processing

Performance is one of the most important areas covered in SQL Server 2019.

A dedicated part of the course introduces Intelligent Query Processing and related performance enhancements.

You will explore how SQL Server began introducing more adaptive and intelligent behavior into query processing and why these capabilities can matter when working with real database workloads.

Understanding these features also provides useful context for how SQL Server performance technologies continued to evolve in later releases.

Explore Security, Availability, and Development Enhancements

SQL Server 2019 introduced and enhanced capabilities across several other areas of the platform.

The course examines selected features involving:

• Database security.

• High availability.

• Database development.

• Administration.

• Monitoring.

• Platform capabilities.

These lessons help you understand how SQL Server 2019 expanded beyond performance improvements and contributed to the broader evolution of the SQL Server data platform.

Explore SQL Server 2019 on Linux

SQL Server is no longer limited to Windows environments.

A dedicated section explores SQL Server 2019 on Linux, including setup and usage examples that demonstrate how SQL Server operates in a Linux-based environment.

This provides useful context for database professionals who want to understand the cross-platform direction of SQL Server and the options available beyond traditional Windows deployments.

Understand SQL Server 2019 in Context

This course is especially useful if you:

• Support SQL Server 2019 environments.

• Work with systems that were designed around SQL Server 2019 capabilities.

• Need to understand features introduced in this release.

• Are preparing for an upgrade and want to understand the starting point.

• Want to fill gaps in your SQL Server version knowledge.

• Are interested in how SQL Server features evolved over time.

Knowing what was introduced in SQL Server 2019 can also help you better understand later SQL Server releases and the technologies that built on this foundation.

Who Is This Course For?

This course is suitable for:

• SQL Server database administrators.

• Database developers.

• Data engineers.

• Database architects.

• IT professionals supporting SQL Server environments.

• Professionals maintaining SQL Server 2019 systems.

• Anyone interested in understanding the SQL Server 2019 feature set.

Basic SQL Server knowledge is recommended.

The course assumes you already understand fundamental database and SQL Server concepts and focuses specifically on the capabilities introduced or enhanced in the SQL Server 2019 generation.

About the Demonstration Environment

The demonstrations were recorded using the tools and software available during the SQL Server 2019 period, including SQL Server Management Studio 18.x and contemporary Windows and Linux environments.

Newer versions of SQL Server Management Studio, operating systems, and supporting tools may look different today, but the demonstrations remain useful for understanding the SQL Server 2019 features and concepts being discussed.

If you reproduce an example, use an environment appropriate for the SQL Server version you want to study.

Strengthen Your Understanding of SQL Server 2019

By the end of the course, you will have a clearer understanding of the main performance, security, availability, development, administration, and Linux-related capabilities associated with SQL Server 2019.

You will also have better context for understanding how SQL Server evolved from earlier releases and how later versions continued building on many of these ideas.

If you work with SQL Server 2019 or want to understand the technologies introduced during this important release, this course provides a focused and structured way to explore them.