My automated apt updates failed to update the Microsoft SQL components because they don’t accept the terms and condition in the EULA.
To resolve this I added the following line in /etc/environment that allows the EULA to be accepted by default.
ACCEPT_EULA=Y