Since November 2021, Canonical and Microsoft have been providing a collectively supported Microsoft SQL Server on Ubuntu Professional resolution. With this providing, you may arrange an optimised configuration of SQL Server on Ubuntu in a number of steps.
As database professionals, we must always guarantee the best potential requirements for database safety and availability. On this weblog, we are going to element how the mix of SQL Server and Ubuntu Professional may help you obtain these targets.
Improved safety and simpler certification path
In keeping with IBM’s 2022 report, a single breach prices round 4.35 million {dollars}. Equally worrying, the identical report outlines a median of 277 days to find and comprise a knowledge breach. Subsequently, it’s changing into more and more pressing for organisations to safe their Most worthy asset.
Microsoft SQL Server is without doubt one of the most safe databases ever. The next graph reveals the variety of vulnerabilities discovered in several database engines over a 9-year interval. Microsoft SQL Server clearly holds the crown of the least weak database:
Nonetheless, having a safe database will not be sufficient to make sure the safety of the entire deployment. As soon as a malicious person features root entry to the database-hosting working system, it’s solely a query of time earlier than they acquire excessive privileges to the database itself.
In keeping with the CVE particulars database, the commonest sort of vulnerabilities is code execution, representing round 25% of the overall reported ones. This vulnerability sort permits the attacker to execute arbitrary code on the goal machine or course of.
Ubuntu Professional helps you enhance the safety of your complete deployment by enhancing your safety posture on totally different fronts.
First, Ubuntu Professional widens your patch protection to greater than 25,000 packages (up from 2,300 packages in Ubuntu LTS). Second, it supplies you with Expanded Safety Upkeep for an extra 5 years (so 10 in complete). Subsequently, Ubuntu Professional helps organizations scale back their floor assaults and provides them the liberty to decide on when to improve.
Ubuntu Professional affords instruments to harden your OS following probably the most stringent compliance regimes and safety requirements like ISO 27k, PCI, CIS, DISA-STIG and FedRAMP. If your organization is working database workloads in regulated environments, then utilizing Ubuntu Professional will enable you to cross the related audits and purchase the wanted certifications.
With zero-day exploits practically doubling in 2021 and with 80% of public exploits being printed earlier than their CVEs, it’s changing into vital to patch vulnerabilities as quickly as they’re recognized. By kernel dwell patch, Ubuntu Professional ensures a well timed roll-out of vital patches while not having a reboot which may influence your database availability.
In addition to bettering safety and compliance, Microsoft SQL Server deployments on Ubuntu Professional provide help and availability enhancements.
Improved help and availability
Collectively, Canonical and Microsoft present supported configurations to run a extremely out there Microsoft SQL Server on Ubuntu Professional. Each corporations decide to offering 24/7 help for these configurations.
You should use the identical stream when opening help tickets in Azure to get assist. Behind the scenes, Microsoft and Canonical coordinate to promptly give you the wanted help.
When working Microsoft SQL Server on Ubuntu LTS, you have to to hunt help from the group with out SLAs on decision time.
Conclusion
In abstract, in case you are working a manufacturing workload utilizing Microsoft SQL Server on Ubuntu then you need to undoubtedly think about using Ubuntu Professional. If you’re working a regulated workload then Ubuntu Professional is a superb match.
The excellent news is which you could begin utilizing SQL Server on Ubuntu Professional with only a few clicks.
