Linux

As explained in 100 SQL Server Mistakes and How to Avoid Them

An open-source Unix-like operating-system family that can host SQL Server.

Mistake #34: using Windows indiscriminately. Linux is a viable host for SQL Server, and choosing it can align the database platform with application skills, operating-system choices, and licensing constraints. section 8.2

MagicChoc chooses the wrong platform

MagicChoc's new Go application runs on Ubuntu virtual machines. Its database team chose Windows Server 2022 because they knew SQL Server rather than MySQL, but this forced Linux-based developers toward Windows and added Windows Server licensing costs. Hosting SQL Server on Linux would have lowered that barrier while preserving SQL Server features such as AlwaysOn, HIERARCHYID, and windowing functions. section 8.2

Use these checks before selecting Linux for a SQL Server deployment:

• Match the database host to the application environment when developer familiarity, operational consistency, or license cost matters. section 8.2
• Confirm the distribution and SQL Server version: SQL Server 2022 is supported on Red Hat, SUSE, and Ubuntu. section 8.11
• Consider Linux containers for suitable deployments, and store database files in a Docker volume so removing the container does not remove the data. section 8.11

Figure 8.1 Windows vs. Linux decision tree

Use the Windows-versus-Linux decision tree to structure the platform choice instead of treating Windows as the automatic default. section 8.2

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes

Explains supported distributions, team fit, licensing, and containers, but stops short of installation procedures or Linux administration.

Examples

Uses MagicChoc's Go application on Ubuntu VMs and a Windows-versus-Linux decision tree as concrete deployment examples.

What you can do after

Evaluate a SQL Server host choice against developer familiarity, supported distributions, licensing, and container persistence.

How it connects

Connects Linux with SQL Server, Ubuntu, Red Hat, SUSE, Docker containers, Windows Server, and application-platform selection.

liveBookmanning.com

Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Also explained in

• 

  liveBookmanning.com
  AI for Everyday ITLinux is an open-source family of Unix-like operating-system kernels and distributions used to run servers, desktops, and embedded systems.

Compare how 2 books explain Linux →

Related concepts

• operating systemkind of · An operating system is system software that manages computer hardware and provides services and interfaces for application programs.
• eBPFused by · eBPF is a Linux kernel technology that safely executes verified, sandboxed programs in response to kernel, networking, system, or application events.
• shell scriptuses · Bash is a Unix command-line shell and scripting language for executing commands interactively and through scripts.
• cgrouphas part · A cgroup is a Linux kernel mechanism that groups processes to control, limit, isolate, and account for their resource usage.

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.