mssql docker

docker-compose.yml

version: "3"
services:
  db:
    image: mcr.microsoft.com/mssql/server:2019-CU5-ubuntu-16.04
    restart: always
    ports:
      - "1433:1433"
    environment:
      - "ACCEPT_EULA=Y"
      - "SA_PASSWORD=Demo#1234"
      - "MSSQL_COLLATION=Danish_Norwegian_CI_AS"
      - "MSSQL_AGENT_ENABLED=True"
    volumes:
      - "db-data:/var/opt/mssql"
      - "./backups:/backups"

volumes:
  db-data:
  
# tips on in-memory db: https://github.com/microsoft/mssql-docker/issues/110#issuecomment-310969848