sql-distributions-loadbalancer.yml

apiVersion: v1
kind: Service
metadata:
  name: sql-distributions-0
  labels:
    app: sql-distribution
spec:
  type: LoadBalancer
  ports:
  - port: 1433
    name: sql
  selector:
    statefulset.kubernetes.io/pod-name: sql-distributions-0
---
apiVersion: v1
kind: Service
metadata:
  name: sql-distributions-1
  labels:
    app: sql-distribution
spec:
  type: LoadBalancer
  ports:
  - port: 1433
    name: sql
  selector:
    statefulset.kubernetes.io/pod-name: sql-distributions-1
---
apiVersion: v1
kind: Service
metadata:
  name: sql-distributions-2
  labels:
    app: sql-distribution
spec:
  type: LoadBalancer
  ports:
  - port: 1433
    name: sql
  selector:
    statefulset.kubernetes.io/pod-name: sql-distributions-2
---
apiVersion: v1
kind: Service
metadata:
  name: sql-distributions-3
  labels:
    app: sql-distribution
spec:
  type: LoadBalancer
  ports:
  - port: 1433
    name: sql
  selector:
    statefulset.kubernetes.io/pod-name: sql-distributions-3
---
apiVersion: v1
kind: Service
metadata:
  name: sql-distributions-4
  labels:
    app: sql-distribution
spec:
  type: LoadBalancer
  ports:
  - port: 1433
    name: sql
  selector:
    statefulset.kubernetes.io/pod-name: sql-distributions-4

sql-distributions-statefulset.yml

apiVersion: apps/v1
kind: StatefulSet
metadata:
   name: sql-distributions
   labels:
     app: sql-distribution
spec:
   serviceName: sql-distributions
   replicas: 1
   selector:
     matchLabels:
       app: sql-distribution
   template:
     metadata:
       labels:
         app: sql-distribution
     spec:
       containers:
       - name: sql-server-data
         image: mcr.microsoft.com/mssql/server:2019-latest
         env:
         - name: ACCEPT_EULA
           value: "Y"
         - name: SA_PASSWORD
           value: "!pass@word1"
         ports:
         - containerPort: 1433
           name: sql
         volumeMounts:
         - name: sql-data
           mountPath: /var/opt/mssql
       initContainers:
       - name: init-sql-chmod
         image: busybox:latest
         command: ['/bin/chown', '10001:0', '/var/opt/mssql']
         volumeMounts:
         - name: sql-data
           mountPath: /var/opt/mssql
   volumeClaimTemplates:
   - metadata:
       name: sql-data
     spec:
       accessModes:
       - ReadWriteOnce
       storageClassName: default
       resources:
         requests:
           storage: 20Gi