In order to follow along and explore the new features of SQL Server 2019, you need the latest version of the database engine and Management Studio version 18.0 or higher. This course also uses the WideWorldImporters and AdventureWorks sample databases that can be obtained from Microsoft’s GitHub repository.
- [Instructor] To follow along with this course, I've created a couple of SQL scripts that you can download and open up in SQL Server Management Studio or Azure Data Studio. However, this isn't strictly necessary, since everything that these scripts contain will be visible on the screen, and you can simply copy down the same code that I execute. You will need to have the latest version of SQL Server 2019 installed. I'll be using the Community Technology Preview 2.5 release, but you can use anything after that, or even the general release version if it's available by the time that you're watching this course. You'll also need SQL Server Management Studio version 18.0 or higher for full compatibility with SQL Server 2019. Finally, I'll be demonstrating some of the features using a couple of Microsoft sample databases, and you can get them from this URL. The first one I want to use is the WideWorldImporters database. I'll go ahead and scroll down here, and click on the link for SQL Server Samples. That'll take me to the GitHub repository for the project, and I can go ahead and scroll down here, click on Wide World Importers sample database version 1.0, and finally, scroll down one more time, and the file that I want is this one here, WideWorldImporters-Full.bak. Go ahead and click on this link, and it'll download the file to your computer. The other one that I want is called AdventureWorks. Let's go back here to the beginning. The AdventureWorks database can be found by scrolling down just a little bit further. Here I'm going to click on the link for AdventureWorks downloads for SQL Server 2014 and later. From here, I'll scroll down and find the link to the AdventureWorks2017.bak file. Once you've downloaded each of these sample databases, restore the backups onto your SQL Server instance, and you'll be ready to follow along and explore the new features of SQL Server 2019.
- Intelligent query processing
- Improvements to persistent memory
- Table virtualization with PolyBase
- Creating a unified data cluster
- Training and creating machine learning models
- Running SQL Server in containers
- Updates to the SQL Server Management Studio (SSMS)