Welcome to this Microsoft solutions workshop on SQL Server 2019 on OpenShift.
Red Hat OpenShift Container Platform is based on Kubernetes and provides an API to manage these services. The OpenShift Container Platform allows you to create and manage containers. From a perspective of SQL Server, OpenShift provides:
- A scalable architecture to deploy containerized applications and data platforms such as SQL Server
- Persistent storage for stateful containers like SQL Server
- Built-in load balancers to abstract application connections to SQL Server
- Built-in high availability for stateful containers like SQL Server
In this course you will learn the basics of deployment, connection, query execution, performance, and high availability in SQL Server 2019 with OpenShift.
You will interact with an OpenShift cluster using the OpenShift CLI program oc and use the concepts of projects, deployments, pods, labels, PersistentVolumeClaims, and LoadBalancer services as you deploy and use SQL Server on OpenShift.
This README.MD file explains how the workshop is structured, what you will learn, and the technologies you will use in this solution.
The workshop is currently built to support SQL Server on OpenShift 4 and uses the latest SQL Server 2019 Red Hat containers.
NOTE: You're able to complete this workshop without having a prior knowledge of OpenShift, but if you would like to learn more about its features, architecture and management, these materials are available:
- Getting Started with OpenShift
- The OpenShift Architecture
- Try OpenShift for Free with OpenShift Online
When you complete this course, you will be able to:
- Understand the basics of deploying SQL Server on an OpenShift cluster.
- Connect and run queries against SQL Server deployed on OpenShift.
- Understand performance capabilities of SQL Server deployed on OpenShift
- Implement High Availability capabilities of SQL Server deployed on OpenShift
- Developers looking to deploy a database container for their applications on OpenShift
- Database Administrators looking to understand how to deploy database platforms like SQL Server in a Kubernetes cluster using OpenShift.
| Technology | Description |
|---|---|
| SQL Server | Database Platform produced by Microsoft |
| SQL Server 2019 | Most current release of SQL Server currently in preview |
| Intelligent Query Processing | Automated query processing enhancements in SQL Server 2019 |
| Always On Availability Group | SQL Server High Availability Disaster Recovery capabilities based on replicas |
| Linux | Operating system used in Containers and Container Orchestration |
| Docker | Engine for running and manage containers |
| Kubernetes | Orchestration and Management platform for Containers |
| OpenShift | Family of containerization software developed by Red Hat |
| OpenShift Platform | Kubernetes-based platform for containers |
| oc | OpenShift CLI program. (Similar to the kubectl command) |
| project | Equivalent to Kubernetes namespace |
| Azure Data Studio | Graphical User Interface to execute T-SQL queries and manage SQL Server |
| SQL Server Command Line Tools | Utilities to connect and query SQL Server such as sqlcmd |
To complete this workshop you will need the following:
- A client computer connected to the Internet that has a Linux shell and can run SQL Server command line tools.
- Access to a OpenShift 4 cluster. All the examples in this workshop were built using Azure Red Hat Openshift (ARO). Learn more about ARO at https://docs.microsoft.com/azure/openshift/intro-openshift.
- Access to all the scripts provided from this workshop from the GitHub repo.
The Prerequisites module in this workshop provides all the details of tools and software required to take this workshop.
You might be taking this workshop from an instructor who will provide access to an OpenShift cluster and possibly a client workstation with all the tools and files installed.
A complete Prerequisites document exists as part of this workshop. You will be guided to go through Prerequisites in the Next Steps at the bottom of this page.
Microsoft and any contributors grant you a license to the Microsoft documentation and other content in this repository under the Creative Commons Attribution 4.0 International Public License, see the LICENSE file, and grant you a license to any code in the repository under the MIT License, see the LICENSE-CODE file. All license files are found in the LICENSES directory.
This workshop uses OpenShift, SQL Server 2019, Azure Data Studio, SQL Command Line Tools, and the OpenShift CLI (oc).
| Primary Audience: | Administrators looking to learn how to deploy, use, and manage SQL Server on OpenShift |
| Secondary Audience: | Developers, Architects, and IT Pros |
| Level: | 300 |
| Type: | Self-Paced or In-Person |
| Length: | 2 hours (self-paced) 4 hours (In-Person) |
This is a modular workshop, and in each section, you'll learn concepts, technologies, and processes to help you complete the solution.
Proceed to Next Steps below to start the workhop.
| Module | Topics |
| 01 - Deploy SQL Server on OpenShift | Learn the fundamentals of deploying SQL Server container on OpenShift |
| 02 - Connect and Query SQL Server | Learn the basics of connecting and running queries to a SQL Server container on OpenShift |
| 03 - Performance Capabilities of SQL Server | Learn how to boost query performance and take advantage of intelligent query processing |
| 04 - High Availability of SQL Server on OpenShift | Learn the fundamentals of high availability for SQL Server on OpenShift |
Next Steps