--- title: "\uFEFFThe benefits of running Microsoft SQL Server on Ubuntu Pro" description: Running Microsoft SQL Server on Ubuntu Pro is the preferred configuration to run SQL Server on Linux in Azure. Check this article to know more. url: https://canonical.com/blog/microsoft-sql-server-on-ubuntu?format=md --- 1. [Blog](https://canonical.com/blog) 2. Article --- [Mohamed Wadie Nsiri](https://canonical.com/blog/author/mwnsiri "More about Mohamed Wadie Nsiri") 28 September 2022 # The benefits of running Microsoft SQL Server on Ubuntu Pro [RDBMS](https://canonical.com/blog/tag/rdbms) [SQL Server](https://canonical.com/blog/tag/sql-server) --- Share the article Since November 2021, [Canonical](https://ubuntu.com/blog/ubuntu-pro-microsoft-sql-server-for-azure) and [Microsoft](https://techcommunity.microsoft.com/t5/sql-server-blog/announcing-sql-server-on-ubuntu-pro-in-azure-virtual-machines/ba-p/2914331) have been offering a jointly supported Microsoft SQL Server on Ubuntu Pro solution. With this [offering](https://ubuntu.com/tutorials/provision-an-ubuntu-virtual-machine-running-sql-server-in-azure#2-launch-an-ubuntu-vm-with-sql-server-installed), 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](https://www.ibm.com/security/data-breach), 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](https://www.economist.com/leaders/2017/05/06/the-worlds-most-valuable-resource-is-no-longer-oil-but-data). Microsoft SQL Serveris one of the most secure databases ever. The following [graph](https://cloudblogs.microsoft.com/uploads/prod/sites/32/2019/11/NSIT-graph.png) 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](https://www.cvedetails.com/vulnerabilities-by-types.php), 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](https://en.wikipedia.org/wiki/Arbitrary_code_execution) 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 Prowidens 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](https://ubuntu.com/security/esm) 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](https://ubuntu.com/tutorials/comply-with-cis-or-disa-stig-on-ubuntu#2-installing-the-ua-client) 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](https://ubuntu.com/security/certifications/docs). With zero-day exploits nearly [doubling in 2021](https://www.technologyreview.com/2021/09/23/1036140/2021-record-zero-day-hacks-reasons/) and with [80% of public exploits](https://unit42.paloaltonetworks.com/state-of-exploit-development/) being published before their CVEs, it’s becoming critical to patch vulnerabilities as soon as they are known. Through kernel [live patch](https://ubuntu.com/security/livepatch), 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](https://ubuntu.com/engage/SQLServerWebinarPart1) 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](https://azuremarketplace.microsoft.com/en-us/marketplace/apps/microsoftsqlserver.sql2019-ubuntupro2004?tab=Overview). Please check the related [blog](https://techcommunity.microsoft.com/t5/sql-server-blog/microsoft-sql-server-on-ubuntu-pro-the-preferred-choice-for/ba-p/3639818) published by Microsoft on the same topic. [Get in touch Interested in running Ubuntu in your organization?](https://ubuntu.com/about/contact-us/form) ## Sign up for our newsletter Get the latest Canonical news and updates in your inbox. Work email: \*I agree to receive information about Canonical's products and services. By submitting this form, I confirm that I have read and agree to [Canonical's Privacy Policy](https://canonical.com/legal/dataprivacy). Sign up ## Share on --- ## Related posts [### SQL Server 2025 is generally available on Ubuntu 24.04 LTS](https://canonical.com/blog/sql-server-2025-ubuntu-24-04-lts) Microsoft has announced the General Availability of SQL Server 2025 on Ubuntu 24.04 LTS. Learn about the new CU1 features, including OS-level observability, Contained... [Jehudi](https://canonical.com/blog/author/jota-ce) 6 February 2026 [### AI meets SQL Server 2025 on Ubuntu](https://canonical.com/blog/sql-server-2025-on-ubuntu) Partnership between Microsoft and Canonical Since 2016, when Microsoft announced its intention to make Linux a first class citizen in its ecosystem, Canonical and Microsoft... [Mohamed Wadie Nsiri](https://canonical.com/blog/author/mwnsiri) 4 February 2026 [### Charmed MySQL enters General Availability](https://canonical.com/blog/charmed-mysql-release) Nov 6th, 2024: Today Canonical announced the release of Charmed MySQL, an enterprise solution that helps you secure and automate the deployment, maintenance and upgrades of... [Mohamed Wadie Nsiri](https://canonical.com/blog/author/mwnsiri) 6 November 2024 [### Still running SQL Server on Ubuntu 16.04 LTS or 18.04 LTS ?](https://canonical.com/blog/sql-server-on-ubuntu) Running SQL Server on Ubuntu 16.04 LTS or 18.04 LTS? If so, this blog is for you to evaluate options to avoid compromising the security of your data Houston, we have a problem... [Mohamed Wadie Nsiri](https://canonical.com/blog/author/mwnsiri) 19 December 2023