Skip to main content

Your submission was sent successfully! Close

Thank you for signing up for our newsletter!
In these regular emails you will find the latest updates from Canonical and upcoming events where you can meet our team.Close

Thank you for contacting us. A member of our team will be in touch shortly. Close

  1. Blog
  2. Article

Mohamed Wadie Nsiri
on 28 September 2022

The benefits of running Microsoft SQL Server on Ubuntu Pro


Since November 2021, Canonical and Microsoft have been offering a jointly supported Microsoft SQL Server on Ubuntu Pro solution. With this offering, you can set up an optimised configuration of SQL Server on Ubuntu in a few steps.

As database professionals, we should ensure the highest possible standards for database security and availability. In this blog, we will detail how the combination of SQL Server and Ubuntu Pro can help you achieve those goals.

Improved security and easier certification path

According to IBM’s 2022 report, a single breach costs around 4.35 million dollars. Equally worrying, the same report outlines an average of 277 days to discover and contain a data breach. Therefore, it’s becoming increasingly urgent for organisations to secure their most valuable asset.

Microsoft SQL Server is one of the most secure databases ever. The following graph shows the number of vulnerabilities found in different database engines over a 9-year period. Microsoft SQL Server clearly holds the crown of the least vulnerable database:

However, having a secure database is not enough to ensure the security of the whole deployment. Once a malicious user gains root access to the database-hosting operating system, it’s only a question of time before they gain high privileges to the database itself.

According to the CVE details database, the most common type of vulnerabilities is code execution, representing around 25% of the total reported ones. This vulnerability type allows the attacker to execute arbitrary code on the target machine or process. 

Ubuntu Pro helps you improve the security of your whole deployment by enhancing your security posture on different fronts.

First, Ubuntu Pro widens your patch coverage to more than 25,000 packages (up from 2,300 packages in Ubuntu LTS). Second, it provides you with Expanded Security Maintenance for an additional 5 years (so 10 in total). Therefore, Ubuntu Pro helps organizations reduce their surface attacks and gives them the freedom to choose when to upgrade.

Ubuntu Pro offers tools to harden your OS following the most stringent compliance regimes and security standards like ISO 27k, PCI, CIS, DISA-STIG and FedRAMP. If your company is running database workloads in regulated environments, then using Ubuntu Pro will help you pass the relevant audits and acquire the needed certifications.

With zero-day exploits nearly doubling in 2021 and with 80% of public exploits being published before their CVEs, it’s becoming critical to patch vulnerabilities as soon as they are known. Through kernel live patch, Ubuntu Pro ensures a timely roll-out of critical patches without needing a reboot that might impact your database availability.

Besides improving security and compliance, Microsoft SQL Server deployments on Ubuntu Pro offer support and availability enhancements.

Improved support and availability

Together, Canonical and Microsoft provide supported configurations to run a highly available Microsoft SQL Server on Ubuntu Pro. Both companies commit to providing 24/7 support for those configurations.

You can use the same flow when opening support tickets in Azure to get help. Behind the scenes, Microsoft and Canonical coordinate to promptly provide you with the needed support.

When running Microsoft SQL Server on Ubuntu LTS, you will need to seek support from the community without SLAs on resolution time.

Conclusion 

In summary, if you are running a production workload using Microsoft SQL Server on Ubuntu then you should definitely consider using Ubuntu Pro. If you are running a regulated workload then Ubuntu Pro is a great fit.

The good news is that you can start using SQL Server on Ubuntu Pro with just a few clicks.

Please check the related blog published by Microsoft on the same topic.

Related posts


robgibbon
10 November 2021

SQL Server on Ubuntu Pro: bringing it all back home

Cloud and server Article

Not going to lie, the Microsoft SQL Server is my all-time favourite Microsoft product. For a long time, SQL Server was only available for Windows, but not much is really sacred. So now Microsoft, in collaboration with Canonical, are distributing and supporting several flavours of SQL Server on Ubuntu Pro for Azure. I’m going to ...


Canonical
1 November 2021

Ubuntu Pro-based Microsoft SQL Server Instances available for Azure

Ubuntu Article

1st November 2021: Today, Canonical announced support with Microsoft for Microsoft SQL Server with Ubuntu Pro on Microsoft Azure. Canonical has worked with Microsoft to bring a highly performant and fully supported solution for SQL Server to market, based around the Ubuntu Pro 20.04 LTS operating system. Customers on Microsoft Azure can l ...


Canonical
16 November 2016

Microsoft loves Linux. SQL Server Public Preview available on Ubuntu

Canonical announcements Article

Microsoft has just announced its public preview of the next release of SQL Server, and Canonical is delighted to announce that this preview is available for Ubuntu. SQL Server on Ubuntu now provides freedom of choice for developers and organisations alike whether you use on premises or in the cloud. SQL Server enables choice of ...