Golden image

Q: How deeply does 100 SQL Server Mistakes and How to Avoid Them cover golden image?

Defines the approach and weighs its consistency against edition, workload, and maintenance trade-offs.

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

A gold image is a preconfigured operating-system or software image used as a standardized basis for creating deployed systems.

A golden image is a preconfigured Windows Server image with SQL Server already installed, used as a standardized basis for creating instances. section 8.8

The approach improves consistency, but can standardize unsuitable choices: every instance may receive Enterprise edition and OLTP settings, even when data warehouses need different configurations. section 8.8

Use golden images cautiously:

Maintain multiple images for materially different editions or workloads, accepting the update burden. section 8.8
Prefer a parameterized PowerShell installation script when deployments need both consistency and flexibility. section 8.8

The rushed-build mistake

A team standardizes on one image and later discovers that its Enterprise, OLTP-oriented defaults do not fit a data warehouse. Changing the image creates additional update work. section 8.8

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

Cover of 100 SQL Server Mistakes and How to Avoid Them

liveBook manning.com

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

Also explained in

liveBook manning.com

Learn Docker in a Month of Lunches, Second EditionA golden image is an organization-maintained container image derived from an approved base image with standardized custom configuration.

Compare how 2 books explain golden image →

Related concepts

Packerproduced by · Packer is an open-source tool for creating machine images from declarative configurations across multiple platforms.
deployment pipelineused by · A sequence of automated or manual stages that builds, tests or validates, packages, and delivers software or models toward deployment.
software supply chain securityproduces · Software supply chain security is the protection and verification of software source code, dependencies, build processes, artifacts, and delivery mechanisms against compromise or unauthorized modification.
base imagekind of · A base image is a container image that supplies the initial filesystem and environment from which another container image is built.

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.