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

In this overview, we will talk about what will you learn in this section.

In this lecture, we will discuss about how SQL Server has been evolved over the years, and what major features have been added in the last versions.

In this lecture, we will talk about the system requirements for SQL Server 2019 and see in action how we can download it and install it on a demo Windows VM, along with discussing about the best practices.

In this lecture, we will talk about the system requirements for SQL Server Management Studio (SSMS) 18.0 and see in action how we can download it and install it on the same demo Windows VM, where we installed SQL Server 2019.

This is a summary of what you’ve learned in this section.

In this overview, we will talk about what will you learn in this section.

In this lecture, we will talk about the major performance enhancements in SQL Server 2019.

This is a summary of what you’ve learned in this section.

In this overview, we will talk about what will you learn in this section.

In this lecture, we will talk about the major security and compliance enhancements in SQL Server 2019.

This is a summary of what you’ve learned in this section.

In this overview, we will talk about what will you learn in this section.

In this lecture, we will talk about the major high availability enhancements in SQL Server 2019.

This is a summary of what you’ve learned in this section.

In this overview, we will talk about what will you learn in this section.

In this lecture, we will talk about the major development-related enhancements in SQL Server 2019.

This is a summary of what you’ve learned in this section.

In this overview, we will talk about what will you learn in this section.

In this lecture, we will talk about other significant enhancements in SQL Server 2019 such as additional support for Linux, Big Data and more.

This is a summary of what you’ve learned in this section.

Learn more information about this section.

In this lecture and demo, we will see step by step, how we can install SQL Server 2019 CTP 3.0 on Ubuntu Linux 19.04.

In this lecture and demo, we will see how we can install the SQL Server command-line tools (sqlcmd and bcp) on Ubuntu Linux.

In this lecture and demo, we will see how we can access SQL Server 2019 on Ubuntu Linux, using Azure Data Studio.

In this lecture and demo, you will learn how to perform an offline installation of SQL Server 2019 (CTP 3.1) on Ubuntu Linux 19.04.

In this lecture and demo, we are going to see how to install SQL Server 2019 on CentOS Linux version 8.

This is a summary of what you’ve learned in this section.

This lecture, introduces the new section in this course, titled “Special Topics”.

This lecture talks about the new Dynamic Management Function (DMF) sys.dm_exec_query_plan_stats in SQL Server 2019 and further explains it via a live demonstratrion.

This lecture talks about the new capability in SQL Server 2019, that allows to manually suspend and resume the TDE scan process.

This lecture talks about the new default truncation message in SQL Server 2019.

In this special topic, we will talk about Stretch Database in SQL Server 2019 and via a comprehensive live demonstration, we will see how it is possible via the Stretch Database technology, to store a database table on Azure SQL Database, while being able to access it from your on-premises SQL Server 2019 database.

SQL Server provides many data protection features, as well as security and compliance features. Dynamic Data Masking is available since SQL Server 2016, but I considered it useful, to dedicate a special topic to this great feature and see a live demonstration in SQL Server 2019.

Temporal tables, is a great feature in SQL Server, that allows keeping a full history of data changes (based on UTC time) in database tables, by using a pair of current and historical tables. Temporal tables have become available since SQL Server 2016, but I considered it useful, to dedicate a special topic to this great feature and see a live demonstration in SQL Server 2019.

In this lecture, we'll be discussing more about the integration between Active Directory and SQL Server 2019 on Linux via OpenLDAP support.

Learn about useful DMVs in SQL Server 2019 that can help you effectively monitor query performance and system resources of your database server.

In this lecture, we’ll review clustered and non-clustered indexes as our foundation, then expand into columnstore, filtered, and full-text indexes to understand their specialized uses.

Learn about the key cloud deployment options, with a focus on Microsoft Azure, and how to make the right choice based on your needs.

In this session, we’re diving into one of the most modern and flexible ways to deploy SQL Server — using containers.

This lecture, is a recap of what you’ve learned in this course.