Windows

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

Windows is a family of Microsoft operating systems that can host SQL Server.

Windows is a Microsoft operating-system family that can host SQL Server. Treating it as the automatic choice is a mistake: SQL Server also supports Ubuntu, SUSE, Red Hat, and Docker from version 2017 onward. section 8.2

Mistake #34: using Windows indiscriminately creates practical trade-offs.

• MagicChoc’s Go application ran on Ubuntu, so requiring Linux-based developers to switch to Windows increased the barrier to entry. section 8.2
• Choosing Windows Server 2022 also retained a server-license cost that an Ubuntu deployment could have avoided. section 8.2
• SQL Server features such as AlwaysOn, HIERARCHYID, and windowing functions may still be requirements, even when Windows is not the best host. section 8.2

MagicChoc’s platform decision

MagicChoc selected SQL Server on Windows Server 2022 because its DBAs lacked MySQL experience and wanted advanced SQL Server capabilities. For an Ubuntu-based application, that choice raised developer and licensing concerns. section 8.2

Figure 8.1 Windows vs. Linux decision tree

Use the decision tree to compare Windows and Linux hosting factors before choosing a SQL Server platform. section 8.2

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

How deep it goes

Compares Windows with supported Linux alternatives through a named scenario, but stops short of detailed configuration guidance.

Examples

Uses MagicChoc’s Go application on Ubuntu and its proposed SQL Server deployment on Windows Server 2022.

What you can do after

Evaluate SQL Server hosting choices against team skills, application platform, licensing cost, and required features.

How it connects

Connects Windows with SQL Server, Linux, Docker, Windows Server, AlwaysOn, and MySQL.

liveBookmanning.com

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

Related concepts

• operating systemkind of · An operating system is system software that manages computer hardware and provides services and interfaces for application programs.
• PowerShelluses · PowerShell is Microsoft's cross-platform command shell and scripting language for administering computer systems and automating tasks.
• .NET CLIcontrasts with · .NET CLI is the command-line toolset for creating, building, running, testing, publishing, and managing .NET applications and projects.
• Task Schedulerhas part · Task Scheduler is a Windows system service and management utility that runs programs or scripts automatically according to schedules, triggers, or events.
• LocalDBcontrasts with · LocalDB is a lightweight SQL Server deployment mode intended for local application development, testing, and installed-user applications.

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.