(Glenn’s Technical Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server).
It also can just be technically related items that I find interesting.
SQL Server 2019 Release Candidate
On August 21, 2019, Microsoft announced the availability of the first public release candidate of SQL Server 2019. I find it interesting that Microsoft just called this “SQL Server 2019 Release Candidate” rather than Release Candidate 1 like they have done with previous versions of SQL Server. That sort of implies that there won’t be any more public release candidates before GA.
The looming question is when SQL Server 2019 will actually go GA. The conventional wisdom is that it will happen during the first week of November, while Microsoft Ignite (and PASS Summit 2019) are happening. It will probably be Wednesday, November 6, 2019, during the Day 1 Keynote Session at the PASS Summit. That is my guess.
Regardless of that, I think SQL Server 2019 is going to be a worthwhile release that should help convince more organizations to finally upgrade from their legacy versions of SQL Server.
Figure 1: Top Ten Reasons to Choose SQL Server 2019
August 2019 Release of Azure Data Studio
On August 15, 2019, Microsoft released the August 2019 version of Azure Data Studio, which is version 1.10. Microsoft continues to maintain a monthly release cycle for Azure Data Studio. In my mind, this probably means that you should start using Azure Data Studio at least enough so that you are familiar with it.
I think it is going to be a tough “ask” for Microsoft to get veteran DBAs to completely switch to Azure Data Studio rather than using SSMS for most of their daily work. They would probably deny that is even their intent. At the same time, if SSMS is only updated every several months, and if Azure Data Studio continues to get new features to the point where it is seen as more useful than SSMS, then it may eventually become inevitable.
Don’t get me wrong, I am not hostile to Azure Data Studio. In fact, I plan on using it to present Dr. DMV’s Troubleshooting Toolkit at the PASS Summit 2019. I plan on building a SQL Notebook for that.
Figure 2: Azure Data Studio