# Using Kubernetes Deployments for Updating SQL Server

DevFeed: [Using Kubernetes Deployments for Updating SQL Server](<https://devfeed.tech/articles/using-kubernetes-deployments-for-updating-sql-server-17508.md>)

Original publisher: [Read original article](<https://www.nocentino.com/posts/2019-03-11-kubernetes-deployments-for-sql-server/>)

Author: Anthony Nocentino

Published: 2019-03-12T02:41:16Z

Content type: tutorial

Language: en

Sources: [Kubernetes on Anthony Nocentino's Blog](<https://devfeed.tech/sources/kubernetes-on-anthony-nocentino-s-blog.md>)

Topics: [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Deployment](<https://devfeed.tech/topics/deployment.md>), [YAML](<https://devfeed.tech/topics/yaml.md>)

Tags: [deployment](<https://devfeed.tech/tags/deployment.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [linux](<https://devfeed.tech/tags/linux.md>), [rollback](<https://devfeed.tech/tags/rollback.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>), [yaml](<https://devfeed.tech/tags/yaml.md>)

## AI overview

A tutorial on using Kubernetes Deployment Controllers to deploy SQL Server, manage its application state, upgrade the SQL Server container image, and roll back upgrades. It includes a YAML manifest with persistent storage and a NodePort Service.

## Source excerpt

In Kubernetes we can leverage Controllers to help manage our application state, keeping them in the desired state. In this blog post, we're going to look at how to use a Deployment Controller to manage the application state of SQL Server in Kubernetes. We'll look at deploying SQL Server in a Deployment and using that deployment to upgrade SQL Server and rollback our upgrade. Deploying SQL Server in a Deployment Let's start off with deploying SQL Server in Kubernetes. We can do that with the following YAML file to describe our Deployment.