Sunday, May 19, 2024

Installing SQL Server on Linux: 5 Tips

While SQL Server is a Microsoft product which is usually run in conjunction with a Windows ecosystem, it is also possible to get it up and running in alternative OS environments.

Whether you are more comfortable with Linux or this represents the best choice for your particular needs, you will need to jump through a few hoops to install SQL Server on this type of system. Here are a few handy hints to make things a little less complex.

Image Source: Pixabay

Make sure the Linux platform is supported

It might seem obvious, but unless Microsoft officially offers support for the version of Linux that you are planning to use, it will be much harder to install SQL Server smoothly and seamlessly.

Thankfully there are actually a number of common Linux iterations for which genuine support is offered, including Red Hat Enterprise Linux, SUSE Enterprise Linux Server and Ubuntu.

Furthermore you can run this database solution via Docker Engine, whether this is based in Linux or indeed on a Windows or Apple-originated machine.

Check that your hardware is up to scratch

It is not just necessary to ensure software compatibility in this context, but also to assess the hardware of your server and compare this to the minimum system requirements.

The most recent versions of SQL Server are recommended for use with systems boasting at least 1GB of memory and a CPU that is clocked at 2.0GHz. However, it makes sense to equip your server with far beefier specs if you want to get the best experience.

Lots of elements can impact SQL Server performance, such as blocking issues outlined in this guide, but having solid foundations of the right CPU, memory and storage combination will help to minimize hardware bottlenecks.

Repository configuration is required

In order to install SQL Server on hardware running Linux, setting up the repository from which the database engine package will be retrieved is a necessary step to take.

A quintet of repositories are available, each of which deals with updates in a different way. The standard 2019 repository is a cumulative update repository, which features not only the basic release of SQL server but also subsequent patches and improvements that have been added after the fact to fix bugs and improve security. Meanwhile the GDR repository is only equipped with critical updates, which may be more appealing depending on your needs.

Downgrading is an option

If you install SQL Server on Linux successfully but find that it is not performing as you would like it to be, then it is also possible to downgrade to an earlier edition of the database software to find the sweet spot for your specific setup.

The only restriction is that this downgrade path must be within the version of SQL Server that you are running; this means you cannot downgrade from SQL Server 2017 to much older annual editions, for example.

Updates & upgrades are available

Microsoft has proven itself to be thorough in its support of Linux ever since it began offering SQL Server for this OS family in 2016.

Different Linux releases will require the use of different package update commands, and you will need to make sure that you point your server at the right repository to make any changes of this kind.

As mentioned above, rolling back any updates that you implement is possible and indeed might be desirable if you start encountering issues with SQL Server following the installation of a whole new version or even a minor patch.

If in doubt, check the official documentation from Microsoft to avoid common mistakes when installing SQL Server on Linux.


Latest articles

Norway Recommends Replacing SSLVPN/WebVPN to Stop Cyber Attacks

A very important message from the Norwegian National Cyber Security Centre (NCSC) says that...

New Linux Backdoor Attacking Linux Users Via Installation Packages

Linux is widely used in numerous servers, cloud infrastructure, and Internet of Things devices,...

ViperSoftX Malware Uses Deep Learning Model To Execute Commands

ViperSoftX malware, known for stealing cryptocurrency information, now leverages Tesseract, an open-source OCR engine,...

Santander Data Breach: Hackers Accessed Company Database

Santander has confirmed that there was a major data breach that affected its workers...

U.S. Govt Announces Rewards up to $5 Million for North Korean IT Workers

The U.S. government has offered a prize of up to $5 million for information...

Russian APT Hackers Attacking Critical Infrastructure

Russia leverages a mix of state-backed Advanced Persistent Threat (APT) groups and financially motivated...

Millions Of IoT Devices Vulnerable To Attacks Leads To Full Takeover

Researchers discovered four significant vulnerabilities in the ThroughTek Kalay Platform, which powers 100 million...

Free Webinar

Live API Attack Simulation

94% of organizations experience security problems in production APIs, and one in five suffers a data breach. As a result, cyber-attacks on APIs increased from 35% in 2022 to 46% in 2023, and this trend continues to rise.
Key takeaways include:

  • An exploit of OWASP API Top 10 vulnerability
  • A brute force ATO (Account Takeover) attack on API
  • A DDoS attack on an API
  • Positive security model automation to prevent API attacks

Related Articles