(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)
Today I want to show you a very quick blog posting how easy it is to upgrade SQL Server on Linux. As you know from my previous blog posting I’m currently running in my Home Lab a Linux Ubuntu Virtual Machine, where I have installed SQL Server 2019 CTP 2.3.
Last week Microsoft has released the next CTP version of SQL Server 2019 – CTP 2.4. Therefore, my task today was to upgrade that Virtual Machine to the newer CTP version. And to be honest, upgrading SQL Server on Linux is as simple as ABC: You just have to run the following 2 commands:
sudo apt-get update
sudo apt-get install mssql-server
After the installation was done successfully, I have connected with Azure Data Studio to the SQL Server instance and checked the version:
Total amount of work time required for the upgrade: 2 – 3 minutes! WOW!
If you want to learn more about SQL Server on Linux, Docker, and Kubernetes, I highly suggest my upcoming Live Online Training on May 13 and May 14, where I will do a more technical deep-dive about all these exiting new technologies that will change our life as SQL Server Developers and DBAs over the next years.
Thanks for your time,
-Klaus