This is a 2-part blog post, the first in the series can be found on the Microsoft SQL Server blog here. The recently released SQL Server 2019 on Linux includes several updated features, including replication, support for Microsoft Distributed Transaction Coordinator, and Change Data Capture (CDC) support. If you’re running SQL Server 2017 on Linux, these are great reasons to upgrade to SQL Server 2019 to take advantage of these updates. Microsoft SQL Server 2019 was subjected to significant testing and supported to run on several Linux distribution platforms: Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and…
-
-
So you want to run mssql-cli on Ubuntu Linux, but you received a number of errors and even if you got through some errors, you’re still stuck? I’m here to try to help you get through them and hopefully I’ve captured them all. Trust me, the Oracle DBAs have been here- our databases and tools failed for a very long time until Linux administrators came to know what we needed and started to build us the images with the correct libraries and versions we needed, so we feel your pain! The easiest scenario for many to deploy SQL Server 2019…
-
Azure Directory is available with Linux SQL Server 2019 in Preview and as I was setting it up in my Azure environment on a Linux Red Hat 7.3 VM, I was, as many are, happy that they list the commands for the Azure CLI to set up authentication with Azure Directory, but was concerned, that with so many new to Linux, that they didn’t describe in the steps WHY we were running certain commands or setting best practices around Linux database server design. The setup expects that you already have a Linux VM and SQL 2019 already up and running.…