SQL Server 2022 Standard on Ubuntu 22.04

## SQL Server 2022 Standard on Ubuntu 22.04 by cloudimg

Microsoft SQL Server 2022 Standard Edition on Ubuntu 22.04 LTS, purpose built for Microsoft Azure and maintained by cloudimg. SQL Server 2022 is the only SQL Server release with an APT repo for Ubuntu 22.04 jammy, and the Standard Edition is the workhorse tier for production OLTP and small-to-mid data warehouses.

Why Choose cloudimg?

* 24/7 Expert Support with guaranteed 24 hour response for all requests and one hour average for critical issues. Contact support@cloudimg.co.uk

* Production Ready from Launch Pre configured, security patched, and validated before publication

* Azure Native Integration Built with Azure Linux Agent, cloud init, and Gen2 Hyper V support

* Per VM SA + cloudimg Credentials A fresh strong password is generated for the SA and cloudimg logins at first boot and written to /stage/scripts/mssql-credentials.log (mode 0600 root only). No two virtual machines ever share credentials.

What is Included

* SQL Server 2022 Standard Edition (latest CU at build time, 16.0.4250.1 / KB5083252) from the official packages.microsoft.com APT repo

* mssql-tools18 with sqlcmd and bcp at /opt/mssql-tools18/bin

* mssql-firstboot.service that generates per VM SA + cloudimg passwords, creates the cloudimg database and login, and writes credentials to /stage/scripts/mssql-credentials.log

* mssql-server.service auto-starting on boot

* TCP listener on port 1433 (SQL Server default)

* Memory cap of 2048 MB applied during build for the Standard_B2s build VM; firstboot lifts the cap on customer's production-sized VM

* Ubuntu 22.04 LTS base with latest security patches applied at build time

* Azure Linux Agent for seamless cloud integration and SSH key injection

* 24/7 cloudimg support with guaranteed 24 hour response SLA

Standard Edition Capabilities and Limits

* Up to 24 cores, 128 GB buffer pool RAM, 524 PB max database size

* Always On Basic availability groups (single replica failover)

* Distributed transactions, Service Broker, partitioning

* Backup compression, Resource Governor (workload management)

* Standard Edition does NOT include: in-memory OLTP, multi-replica Always On AGs, Transparent Data Encryption (TDE)

Licensing — BYOL

The image ships SQL Server 2022 Standard Edition binaries activated under evaluation licensing for a 180 day grace period. Apply your Standard product key with `sudo /opt/mssql/bin/mssql-conf setpid` to activate the perpetual license from your Microsoft Volume Licensing agreement. The cloudimg charge ($0.08 per vCPU/hour) covers packaging, security patching, image maintenance, and 24/7 expert support; the SQL Server license itself is YOUR Volume Licensing entitlement.

Recommended Virtual Machine Sizes

* Standard_D4s_v5 (4 vCPU, 16 GB RAM) — small production OLTP workloads

* Standard_D8s_v5 (8 vCPU, 32 GB RAM) — mid-size OLTP, reporting workloads

* Standard_E16s_v5 (16 vCPU, 128 GB RAM) — buffer-pool-bound workloads (matches Standard's 128 GB cap)