SQL Server 2022 Enterprise on Ubuntu 22.04

## SQL Server 2022 Enterprise on Ubuntu 22.04 by cloudimg

Microsoft SQL Server 2022 Enterprise Edition on Ubuntu 22.04 LTS (Jammy Jellyfish), purpose built for Microsoft Azure and maintained by cloudimg. Enterprise features on a production hardened Ubuntu LTS base, pre configured and ready to accept connections within minutes of deployment.

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 Credential Generation Unique SA and cloudimg passwords generated at first boot and written to /stage/scripts/mssql-credentials.log. No shared credentials baked into the image

What is Included

* Microsoft SQL Server 2022 Enterprise Core Edition installed from the official Microsoft APT repository pinned to Ubuntu 22.04 jammy for timely security patches

* mssql-tools18 command line utilities including sqlcmd and bcp for database administration

* mssql-firstboot.service systemd oneshot that rotates the SA password, creates the cloudimg default database, provisions a cloudimg SQL login, and removes the build time memory cap on first customer boot

* mssql-server.service systemd unit started automatically on boot after firstboot completes

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

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

Bring Your Own License

This image ships with SQL Server 2022 Enterprise Core Edition binaries. The Enterprise software license is NOT included. Customers apply their own Enterprise product key on first login:

sudo /opt/mssql/bin/mssql-conf setpid YOUR_PRODUCT_KEY

sudo systemctl restart mssql-server

Without a product key applied, Enterprise features run in evaluation mode for 180 days. After the evaluation period expires a valid Enterprise license must be applied to keep the service operational.

SQL Server 2022 Highlights

* Azure Arc enabled by default with built in connectivity to Microsoft Defender for Cloud, Azure Monitor, and Azure Purview

* Query store on by default with improved plan stability and secondary replica support

* Intelligent query processing enhancements including approximate percentile and cardinality estimation feedback

* Contained Availability Groups and Link feature for Azure SQL Managed Instance replication

* Ledger tables for tamper evident audit trails

* Accelerated database recovery on all editions for fast crash recovery and transaction rollback

Use Cases

* Mission critical OLTP workloads that require Enterprise Edition scale and availability features

* Enterprise data warehouses using columnstore indexes with unlimited compute and memory

* Always On Availability Group secondaries for high availability and disaster recovery

* Analytics workloads that benefit from in memory OLTP and columnstore acceleration

* Ledger backed audit stores for compliance heavy industries

* Migration of existing on premise SQL Server 2022 Enterprise workloads to Azure

Technical Specifications

* Operating System: Ubuntu 22.04 LTS (Jammy Jellyfish)

* SQL Server Version: 2022 Enterprise Core Edition (official packages.microsoft.com APT repo)

* Default Database: cloudimg

* SQL Port: 1433

* Default User: azureuser (sudo enabled)

* Service Management: systemd (mssql-server.service, mssql-firstboot.service)

* Recommended Size: Standard_D4s_v5 or larger (Enterprise features scale with cores and memory)

* VM Generation: Hyper V Gen2 with UEFI boot

Support

cloudimg provides 24/7/365 expert technical support. Guaranteed response within 24 hours, one hour average for critical issues. Contact support@cloudimg.co.uk or visit www.cloudimg.co.uk for the latest documentation and deployment guides.