SQLServerCentral Editorial

SQL Server 2019 CTP 3.0 is Moving Right Along

,

I don't know how close, but SQL Server 2019 must be almost done. If you have been paying attention, you will notice that CTP 3.0 was released this past week. There are a few changes, but this note is the big one for me: "For customers in the Early Adoption Program, CTP 3.0 is the first release where you’re able to run SQL Server 2019 in production." This is reflected in the release notes as well. The notes also reflect that in-place upgrades of SQL Server 2012-207 are now supported. No upgrades from other CTPs, but that's expected.

It seems a lot of work has been done, and some problems have been fixed. Notably, a new compiler was used with CTP 2.1 that had some issues with conversion scenarios. Those appear to have been cleaned up. There are limitations with UTF-8, as well as some issues with Secure Enclaves. I can't imagine the platform will RTM without Secure Enclaves, but what do I know. SQL Server 2005 was released without Database Mirroring working, with the issues ironed out in SP1 shortly after release.

There are some other enhancements that are a bit surprising for me. I expect that Big Data Clusters are evolving, and I see some people testing them. One item that caught my eye in the blog was this: "Database administrators can register new external language extensions on any OS platform supported by SQL Server." Apparently dotnet core, Go, and other languages are somehow being supported. I haven't dug into what this means, and it provides some flexibility, but it also worries me people will try and get things like JavaScript or Ruby modules running inside SQL Server. Perhaps that's just an unnecessary fear, as I've seen relatively little use of the CLR in SQL Server since it was released in 2005.

The relatively few items mentioned as changes would indicate to me that much of the feature work is done and now tuning and bug fixes are under way. I wouldn't be surprised to see another CTP or two, but I do think that we may see a final RTM sometime this summer. I've seen a lot of guesses in the forum about the release date and some of them seem better today than they did last month. My own guess, with no inside information, is that we will get 3.1 and 3.2 as CTPs before an RTM in August.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating