The wait is over. Microsoft has just announced SQL Server 2019 Preview in the Ignite conference. Lots of people were wondering if there is going to be any SQL Server 2018. The answer is Microsoft is going to skip this year as a release for SQL Server and will release SQL Server 2019 early next year.
Here are some of the important links which you want to keep bookmarked.
- What’s New in SQL Server 2019 (Link)
- SQL Server 2019 preview release notes (Link)
- SQL Server Management Studio (SSMS) 18.0 (Link)
- Azure Data Studio (Link)
If you are an early adopter, I strongly suggest that you to try out SQL Server 2019. I am going to install this on my VM very soon.
If you are SQL Server Performance Tuning expert you may not be too much excited. I looked at the various documents and here are the updates in SQL Server Engine parts.
- Intelligent Query Processing
- Row Mode Memory Grant Feedback
- Approximate Count Distinct
- Batch Mode on Rowstore
- Table Variable Deferred Compilation
- Resumable Online Index
- Clustered Columnstore Online operation
Honestly, that’s it. I really wished Microsoft has come up with some enhancements in the area of SQL Server Performance Tuning. I am particularly not so excited about SQL Server Performance Tuning area, but I am very delighted with whatever the version has to offer to users.
To use SQL Server 2019, you have to change the compatibility level to 150
ALTER DATABASE DBName SET COMPATIBILITY_LEVEL = 150;
I will share more information as I learn about the latest version of SQL Server.
Reference: Pinal Dave (http://blog.SQLAuthority.com)