Home > Workload Solutions > SQL Server > White Papers > Solution Insight: SQL Server 2022 Data Analytics on Dell PowerEdge with AMD EPYC 7473X Processors and Dell ECS > Deployment steps
Dell solutions engineering carefully set up and fine-tuned the data analytics process with SQL Server 2022 and Dell ECS. The figures in this section show the deployment steps with OpenShift and VMware.
Figure 4 outlines the deployment steps for the OpenShift setup.
Figure 4. OpenShift deployment steps
Figure 5 outlines the deployment steps with VMware option.
Figure 5. VMware deployment steps
One requirement for deploying SQL Server 2022 is to have a root certificate created for the TLS communication between the SQL Server instance and S3-compatible object storage. When running SQL Server container image on OpenShift, one way to pass the certificate is by using a ConfigMap. For more information about ConfigMap, see the Kubernetes website.
Figure 6. ConfigMap file
A new container image was created for SQL Server with Polybase installed because Polybase is not enabled by default in the published container image mcr.microsoft.com/mssql/server:2022-latest.
The following screenshot shows an example of the code for building a custom SQL Server 2022 container image with Polybase installed.
Figure 7. Sample code for building SQL Server 2022 container image
Figure 8 provides an example of a YAML file that can be used to deploy the custom SQL Server container image with persistent volume on PowerStore and Dell ECS storage certificate using ConfigMap.
Figure 8. Sample YAML file