Containers

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.

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="NewImage" 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>

Pre-conference Workshop at SQLSaturday Baton Rouge

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

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

    <a href="https://www.eventbrite.com/e/kubernetes-zero-to-hero-by-anthony-nocentino-tickets-61845012096"><img loading="lazy" style="display: block; margin-left: auto; margin-right: auto;" title="NewImage.png" src="/images/2019/01/Availability-Group-StatusNewImage-1.png" alt="NewImage" width="129" height="126" border="0" /></a>

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

  <blockquote>

      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.

  </blockquote>

Session Objectives

Speaking at SQLSaturday Atlanta!

  I’m proud to announce that I will be speaking at <a href="https://www.sqlsaturday.com/845">SQL Saturday Atlanta</a> on May 17th 2018! This one won’t let you down! <a href="https://www.sqlsaturday.com/845/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/845/RegisterNow.aspx">Sign up now</a>!

  My presentation is **“<a href="https://www.sqlsaturday.com/845/Sessions/Details.aspx?sid=87539">Containers – You Better Get on Board!</a>” **

  <a href="https://www.sqlsaturday.com/845/EventHome.aspx"><img style="display: block; margin-left: auto; margin-right: auto;" src="https://sqlsaturdayfiles.blob.core.windows.net/845/sqlsat845_header.png" alt="SQLSaturday #845 - Atlanta 2019" /></a>

  Here’s the abstract for the talk

<blockquote>

    Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get you started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

    In this session we’ll look at<br />Container Fundamentals with Docker<br />Common Container Scenarios<br />Automation with Kubernetes

    Prerequisites: Operating system concepts such as command line use and basic networking skills.

</blockquote>

When working with SQL Server in containers and Kubernetes storage is a key concept. In this post, we’re going to walk through how to deploy SQL Server in Kubernetes with Persistent Volumes for the system and user databases.

One of the key principals of Kubernetes is the ephemerality of Pods. No Pod is every redeployed, a completely new Pod is created. If a Pod dies, for whatever reason, a new Pod is created in its place there is no continuity in the state of that Pod. The newly created Pod will go back to the initial state of the container image defined in the Pod’s spec. This is very valuable for stateless workloads, not so much for stateful workloads like SQL Server.

The vision for PowerShell Core is to be able to run PowerShell anywhere. In this article, I’m going to discuss how you can use Docker Containers to enable just that. We’ll look at running PowerShell in a container, running cmdlets, running different versions of PowerShell at the same time, and also how to build our own “serverless” computing platform.

Let’s address a few reasons why you would want to run PowerShell in a container.

Speaking at SQLSaturday Nashville – 815!

I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 12th 2019! And wow, 815 SQL Saturdays! This one won’t let you down. Check out the amazing schedule!

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! Sign up now!

Speaking at SQLSaturday Cambridge!

  I’m proud to announce that I will be speaking at <a href="http://www.sqlsaturday.com/748/EventHome.aspx">SQL Saturday Cambridge</a> on September 8th 2018! And wow, 748 SQL Saturdays! This one won’t let you down. <a href="http://www.sqlsaturday.com/748/Sessions/Schedule.aspx">Check out the amazing schedule</a> of International Experts and Microsoft MVPs!

  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/748/registernow.aspx">Sign up now</a>!

  <a href="http://www.sqlsaturday.com/748/EventHome.aspx"><img style="display: block; margin-left: auto; margin-right: auto;" src="http://www.sqlsaturday.com/images/sqlsat748_header.png" alt="SQLSaturday #748 - Cambridge 2018" /></a>

  **This year I have TWO sessions!**

  **1. **<a href="http://www.sqlsaturday.com/748/Sessions/Details.aspx?sid=78607">**Monitoring Linux Performance for the SQL Server Admin**</a>

<blockquote>

    So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we'll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, and Memory and monitoring techniques for each.

</blockquote>

  **2. **<a href="http://www.sqlsaturday.com/757/Sessions/Details.aspx?sid=78317">**Containers – You Better Get on Board**</a>

<blockquote>

    Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get your started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes. In this session we’ll look at Container Fundamentals with Docker Common Container Scenarios Automation with Kubernetes.

</blockquote>