License-included model

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

A license-included licensing model bundles the software license cost into the recurring price of the provisioned cloud resource.

A license-included model bundles the SQL Server license cost into the cloud VM’s hourly rate, avoiding a separately supplied license. Using it requires a cloud provider’s SQL Server image. section 8.10

The convenient-image mistake

Creating an AWS EC2 or Azure VM from the provider’s SQL Server image seems efficient, but the default image may install every SQL Server feature and tool, including SSMS. Azure images may also configure trace flags 1117 and 1118. Treat the image as a licensing starting point, then remove unnecessary features, keep client tools off the server, and apply the desired configuration. section 8.10

Apply the model safely:

• Choose the provider image when the license-included hourly model is required. section 8.10
• Modify the image-based installation to match required features and configuration-management standards. section 8.10

Figure 8.4 Fresh EC2 instance with SQL Server AMI

Inspect the fresh AWS SQL Server image to identify the default installation footprint. section 8.10

Figure 8.5 Freshly built Azure VM with SQL Server image

Inspect the fresh Azure image to identify installed services and configured startup trace flags. section 8.10

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

How deep it goes

Explains the licensing trigger and provisioning consequences, but stops short of detailed pricing or licensing calculations.

Examples

Uses AWS EC2 SQL Server AMIs and Azure SQL Server VM images as concrete provisioning examples.

What it assumes

Assumes familiarity with cloud VMs and SQL Server licensing, while explaining the license-included mechanism directly.

What you can do after

Evaluate provider images for licensing suitability and modify their default SQL Server installation before production use.

How it connects

Connects cloud images with SQL Server installation, configuration management, SSMS, and trace flags.

liveBookmanning.com

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

Related concepts

• cloud provider sql server imageuses · A cloud provider SQL Server image is a provider-maintained virtual machine image with SQL Server preinstalled and licensing integration enabled.

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.