When working with SQL Server running containers the Error Log is written to standard out. Kubernetes will expose that information to you via kubectl. Let’s check out how it works.

If we start up a Pod running SQL Server and grab the Pod name

kubectl get pods
NAME                                READY   STATUS    RESTARTS   AGE
mssql-deployment-56d8dbb7b7-hrqwj   1/1     Running   0          22m

We can usefollow flag and that will continuously write the error log to your console, similar to using tail with the -f option. If you remove the follow flag it will write the current log to your console. This can be useful in debugging failed startups or in the case below, monitoring the status of a database restore. When finished you can use CTRL+C to break out and return back to your prompt.

      My new course **“Managing Kubernetes Controllers and Deployments”** in now available on Pluralsight <a href="https://www.pluralsight.com/courses/managing-kubernetes-controllers-deployments">here</a>! Check out the trailer <a href="https://www.pluralsight.com/player?name=82f986e5-de18-4897-a461-f1215db691ae&mode=live&clip=0&course=managing-kubernetes-controllers-deployments&author=anthony-nocentino">here</a> or if you want to dive right in go <a href="https://www.pluralsight.com/courses/managing-kubernetes-controllers-deployments">here</a>! This course offers practical tips from my experiences managing Kubernetes Clusters and workloads for Centino Systems clients.

      This course targets IT professionals that design and maintain Kubernetes and container based solutions.The course can be used by both the IT pro learning new skills and the system administrator or developer preparing for using Kubernetes both on premises and in the Cloud.

      Let’s take your Kubernetes administration and configuration skills to the next level and get you started <a href="https://www.pluralsight.com/courses/managing-kubernetes-controllers-deployments">now</a>!

      The modules of the course are:

    <ul>
      <li>
        **Using Controllers to Deploy Applications and Deployment Basics** – In this module we dive into what Controllers are and how they can be used to deploy applications in Kubernetes. We’ll introduce several core controller types and look at the fundamentals of using the `Deployment` Controller to deploy applications and take a deep dive into the Controller operations of `ReplicaSets`.
      </li>
      <li>
        **Maintaining Applications with Deployments** – In this demo-heavy module, we look closer at `Deployments` and learn how we can maintain our container based applications. We look at updating Deployments, controlling rollouts and using `u``pdateStrategy` and `readinessProbes` to ensure successful rollouts. We’ll also cover what to do when things go wrong and learn how to pause and rollback rollouts.
      </li>
      <li>
        **<a href="https://www.pluralsight.com/courses/managing-kubernetes-controllers-deployments">Deploying and Maintaining Applications with DaemonSets and Jobs</a>** – In this module, we introduce the `DaemonSet` controller and how it’s used to deploy applications to all Nodes or a subset of Nodes in our cluster, we’ll also cover `DaemonSet` operations such as updating and controlling rollouts. We wrap up the course with a look at how we can use `Jobs` and `CronJobs` to ensure work completes in our cluster.
      </li>
    </ul>

      <img loading="lazy" style="display: block; margin-left: auto; margin-right: auto;" title="NewImage.png" src="/images/2019/01/Availability-Group-StatusNewImage-3.png" alt="Pluralsight logo" width="565" height="128" border="0" />

      <a href="https://www.pluralsight.com/courses/managing-kubernetes-controllers-deployments">Check out the course at Pluralsight!</a>

Pre-conference Workshop at SQLSaturday Denver

I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Denver on October 11th 2019! This one won’t let you down!

The workshop is **“Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment” **

    **Here’s the abstract for the workshop**

      Modern application deployment needs to be fast and consistent to keep up with business objectives and Kubernetes is quickly becoming the standard for deploying container-based applications, fast. In this day-long session, we will start with an architectural overview of a Kubernetes cluster and how it manages application state. Then we will learn how to build a production-ready cluster. With our cluster up and running, we will learn how to interact with our cluster, common administrative tasks, then wrap up with how to deploy applications and SQL Server. At the end of the session, you will know how to set up a Kubernetes cluster, manage a cluster, deploy applications and databases, and how to keep everything up and running.

Session Objectives

So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL Server process running inside a docker container and my primary tool for this is <a href="http://man7.org/linux/man-pages/man1/strace.1.html">strace</a>, well how do you run strace against processes running in a container? I hadn’t done this before and needed to figure this out…so let’s go through how I pulled this off.

A quick post about pulling docker containers (this applies to docker run too)…when specifying the container image, the container image name and tag are case sensitive. We’re not going to discuss how much time troubleshooting it too me to figure this out…but let’s just say it’s more than I care to admit publicly.

In this code you can see I’m specifying the following image and tag server:2019-rc1-ubuntu (notice the lowercase rc in the tag)

In the first two posts in this series we discussed the need for data persistency in containers then we discussed where the data actually lives on our systems. Now let’s look at specifying the location of the data on the underlying file system of the base OS.

This is the third post in a three part series on Persisting SQL Server Data in Docker Containers. The first post introducing Docker Volumes is here. The second post on where Docker actually stores your data is here.

So in my previous post, we discussed Docker Volumes and how they have a lifecycle independent of the container enabling us to service the container image independent of the data inside the container. Now let’s dig into Volumes a little bit more and learn where Docker actually stores that data on the underlying operating system.

This is the second post in a three part series on Persisting SQL Server Data in Docker Containers. The first post introducing Docker Volumes is here. And the third post on mapping base OS directories directly into containers is here.

What’s the number one thing a data professional wants to do with their data…keep it around. Let’s talk about running SQL Server in Containers using Docker Volumes on a Mac

This is the first post in a three part series on Persisting SQL Server Data in Docker Containers. The second post on where Docker actually stores your data is here. And the third post on mapping base OS directories directly into containers is here.

Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and I’m humbled to be included in this group of exceptional data professionals. I really look forward to continuing to work with everyone in the MVP community and continuing to contribute to our unmatched Data Platform Community!

****

Speaking at SQLSaturday Dallas!

  I’m proud to announce that I will be speaking at <a href="https://www.sqlsaturday.com/841/eventhome.aspx">SQL Saturday Dallas</a> on May 17th 2018! This one won’t let you down! <a href="https://www.sqlsaturday.com/841/Sessions/Schedule.aspx">Check out the amazing schedule</a>!

  If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost!

  If you haven’t been to a SQLSaturday, what are you waiting for! <a href="https://www.sqlsaturday.com/841/registernow.aspx">Sign up now</a>!

  My presentation is **“<a href="https://www.sqlsaturday.com/841/Sessions/Details.aspx?sid=92433">Practical Container Scenarios in Azure</a>” **

  <a href="https://www.sqlsaturday.com/841/EventHome.aspx"><img loading="lazy" style="display: block; margin-left: auto; margin-right: auto;" title="NewImage.png" src="/images/2019/05/SQLSATDALLASNewImage.png" alt="SQLSaturday Dallas logo" width="127" height="20" border="0" /></a>

  Here’s the abstract for the talk

<blockquote>

    You’ve heard the buzz about containers and Kubernetes, now let’s start your journey towards rapidly deploying and scaling your container-based applications in Azure. In this session, we will introduce containers and the container orchestrator Kubernetes. Then we’ll dive into how to build a container image, push it into our Azure Container Registry and deploy it our Azure Kubernetes Services cluster. Once deployed, we’ll learn how to keep our applications available and how to scale them using Kubernetes.

    Key topics introduced<br />Building Container based applications<br />Publishing containers to Azure Container Registry<br />Deploying Azure Kubernetes Services Clusters<br />Scaling our container-based applications in Azure Kubernetes Services

</blockquote>