I have written quite a few blogs about this release. In this blog, we would see the new options available in sys.configurations catalog view.
I would talk about enhancement in SQL Server 2019 Configuration Manager. Let us learn how to enable lock paged in memory (LPIM).
Let us learn, ISNUMERIC Function and Interesting Result. An interesting observation from my client of the Comprehensive Database Performance Health Check.
I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.