What is new with SQL Server 2019
In this lab, you will learn how to use the built-in capabilities of Intelligent Query Processing in SQL Server 2019 simply by changing the database compatibility of WideWorldImporters to version 150 with no application changes.
In this lab, you will learn how to use SQL Server Management Studio (SSMS) and T-SQL to classify columns of tables in a database. You will use the WideWorldImporters sample database to classify specific columns in tables of that database.
In this hands-on lab, you will see how Accelerated Database Recovery affects log truncation and the speed of rollback as well as recovery including transaction log truncation and long running transactions.