Microsoft SQL Server Microsoft SQL Server

Enterprise relational database

Microsoft SQL Server 2025 - AI-ready enterprise relational database with best-in-class performance and security

TODO: Implement health checks to monitor SQL Server availability TODO: Set resource limits (CPU and memory) appropriate for workload TODO: Implement automated backup strategy TODO: Integrate with monitoring solutions (Prometheus, Grafana) for performance metrics

References

name: mssql-server
services:
  mssql-server-init:
    image: busybox:1.38.0@sha256:fd7dc98638c8e305f4dc34e979f1c0fdfdcaeb0fbf8fcff77ae834b6da3d7e6e
    container_name: mssql-server-init
    command: ["sh", "-c", "chown -R 10001:10001 /var/opt/mssql"]
    volumes:
      - ${DOCKER_VOLUMES}/mssql-server/data:/var/opt/mssql

  mssql-server:
    image: mcr.microsoft.com/mssql/server:2025-latest
    container_name: mssql-server
    hostname: mssql
    restart: unless-stopped
    # kics-scan ignore-block
    environment:
      TZ: ${TIMEZONE}
      ACCEPT_EULA: Y
      MSSQL_PID: Developer
      MSSQL_SA_PASSWORD: ${MSSQL_SA_PASSWORD:?MSSQL SA password must be set}
      MSSQL_COLLATION: ${MSSQL_COLLATION:-SQL_Latin1_General_CP1_CI_AS}
    ports:
      - "1433:1433"
    volumes:
      - ${DOCKER_VOLUMES}/mssql-server/data:/var/opt/mssql
    depends_on:
      mssql-server-init:
        condition: service_completed_successfully
    labels:
      traefik.enable: false
      homepage.group: Storage
      homepage.name: Microsoft SQL Server
      homepage.icon: microsoft-sql-server.png
      homepage.href: mssql://${LOCAL_NODE_IP:-127.0.0.1}:1433
      homepage.description: Enterprise relational database