New Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress

My new course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here!
 
In this course you will learn Kubernetes cluster networking fundamentals and configuring and accessing applications in a Kubernetes Cluster with Services and Ingress.  

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. 

New Pluralsight Course – Designing a Site Recovery Strategy on Microsoft Azure

My new course “Designing a Site Recovery Strategy on Microsoft Azure” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here
 
This course targets IT professionals that design and maintain business continuity and disaster recovery solution, on premises or in the cloud.The course can be used by both the IT pro learning new skills and the system administrator or architect preparing for Microsoft Azure Architect Design (AZ-301) and upcoming AZ-304 certifications.

Let’s take your Microsoft Azure Design and implementations skills to the next level and get you started now!

Speaking at PSConf EU 2020

I’m proud to announce that I will be speaking at PSConf EU 2020 in Hannover, Germany. The conference runs from 2 June 2020 to 5 June 2020 and brings together some of the titans of the PowerShell community and members of the PowerShell team from Microsoft. 

<p>
  This is an incredible event packed with fantastic, deep dive content. <a href="https://psconf.eu/schedule">Check out the amazing schedule</a>! Head on over to the site and <a href="https://psconf.eu/"><strong>register now</strong></a>!
</p>

<p>
  This year I have two sessions!
</p>

<p>
  On Thursday<strong>, 2 June at 13:00</strong> &#8211; I’m presenting “<strong>Linux OS Fundamentals for the PowerShell Pro</strong>”
</p>

<p>
  Here’s the abstract
</p>

<blockquote>
  <p>
    PowerShell and SQL Server are now available on Linux and management wants you to leverage this shift in technology to more effectively manage your systems, but you’re a Windows admin, 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 how to interact with and manage a Linux system. By the end of this session, you’ll be ready to go back to the office and get started working with Linux.
  </p>
  
  <p>
    In this session, we’ll cover the following <br /> &#8211; Service control<br /> &#8211; Package installation<br /> &#8211; System resource management (CPU, disk and memory)<br /> &#8211; Using PowerShell to interact with Linux systems 
  </p>
</blockquote>

<p>
  On Friday<strong>, 3 June at 11:00</strong> &#8211; I’m presenting “<strong>Using PowerShell Core Remoting in Cross-Platform Environments</strong>”
</p>

<p>
  Here’s the abstract
</p>

<blockquote>
  <p>
    PowerShell Core is about choice and the transport layer for Remoting is one of those choices. In this session, we’ll look at Remoting in cross-platform environments, installing and configuring OpenSSH and how we can leverage Remoting to really scale up our administrative capabilities.
  </p>
  
  <p>
    In this session, we’ll cover the following<br /> &#8211; Cross-platform Remoting use cases<br /> &#8211; Configuring SSH based Remoting<br /> &#8211; Troubleshooting Remoting
  </p>
</blockquote>

<p>
   <a href="https://psconf.eu/"><img style="display: block; margin-left: auto; margin-right: auto;" src="https://psconf.eu/assets/svg/psconfeu-logo-blue.svg" alt="PS Conf EU logo" width="150" /></a>
</p>

Speaking at Data Grillen 2020

I’m proud to announce that I will be speaking at Data Grillen 2020 the conference runs from 28 May 2020 through 29 May 2020.

This is an incredible event packed with fantastic content, speakers, bratwurst and Beer! 

**Check out the amazing schedule (**and when I say check out the amazing schedule, I really mean it. Some of the world’s best Data Platform speakers are going to be there)

On Thursday**, May 28th at 15:00** – I’m presenting “Containers –  Day 2” in the Handschuh room.

Speaking at PowerShell Summit 2020!

I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2020 the conference runs from April 27th through April 30. This is an incredible event packed with fantastic content and speakers. Check out the amazing schedule! All the data you need on going is in this excellent brochure right here!

<p>
  This year I have two sessions!
</p>

<p>
  On Wednesday<strong>, April 29th at 09:00AM</strong> &#8211; I’m presenting “<a href="https://sessions.eventraft.com/PowerShell2020"><strong>Inside Kubernetes &#8211; An Architectural Deep Dive</strong></a>”
</p>

<p>
  Here’s the abstract
</p>

<blockquote>
  <p>
    In this session we will introduce Kubernetes, we’ll deep dive into cluster architecture and higher-level abstractions such as Services, Controllers, and Deployments and how they can be used to ensure the desired state of an application deployed in Kubernetes. In this session we will introduce Kubernetes, we’ll deep dive into each component and its responsibility in a cluster. We will also look at and demonstrate higher-level abstractions such as Services, Controllers, Deployments and Jobs and how they can be used to ensure the desired state of an application deployed in Kubernetes. By the end of this session, you will understand what’s needed to put your applications in production in a Kubernetes cluster
  </p>
  
  <p>
    Session Objectives
  </p>
  
  <ul>
    <li>
      Understand Kubernetes cluster architecture
    </li>
    <li>
      Understand Services, Controllers, and Deployments
    </li>
    <li>
      Designing Production-Ready Kubernetes Clusters
    </li>
    <li>
      Learn to run PowerShell in Kubernetes Jobs.
    </li>
  </ul>
</blockquote>

Speaking at SQLBits 2020

I’m proud to announce that I will be speaking at SQLBits! I had the absolute pleasure of speaking at SQLBits last year for the first time and saw first hand how great this event is and cannot wait to get back and speak again! And this year, I have two sessions!!! One on building and deploying container based applications in Kubernetes and the other on deploying SQL Server in Kubernetes

If you haven’t been to SQLBits before, what are you waiting for! Sign up now!

Speaking at SQLIntersection Orlando 2020

I’m very pleased to announce that I will be speaking at SQL Intersection April 2020!  This is my first time speaking at SQL Intersection and I’m very excited to be doing so!

<p>
  Speaking at SQL Intersection means so much to me because in 2014 I got my first exposure to the SQL Server community via <a href="https://www.sqlskills.com/">SQLskills</a> and their training. Then to follow up on their training workshops I attended my very first IT conference, SQL Intersection and now I get to come back as a speaker. Let’s just say, I’m a little excited!!!
</p>

<p>
  Now as for the sessions…lots of content here on SQL Server on Linux, Containers and Kubernetes…check them out! <a href="https://www.sqlintersection.com/#!/?track=sql">Click here to register!</a>
</p>

<p>
  <strong>Full Day Workshop</strong>
</p>

<p>
  <a href="https://www.sqlintersection.com/#!/workshop/Kubernetes%20Zero%20to%20Hero:%20Installation,%20Configuration,%20and%20Application%20Deployment/4175"><strong>Kubernetes Zero to Here: Installation, Configuration and Application Deployment</strong></a>
</p>

<blockquote>
  <p>
    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, 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.
  </p>
  
  <p>
    Workshop Objectives:
  </p>
  
  <ul>
    <li>
      Introduce Kuberentes Cluster Components
    </li>
    <li>
      Introduce Kubernetes API Objects and Controllers
    </li>
    <li>
      Installing <span style="background-color: #ffffff;">Kubernetes</span>
    </li>
    <li>
      Interacting with your cluster
    </li>
    <li>
      Storing persistent data in Kubernetes
    </li>
    <li>
      Deploying Applications in Kubernetes
    </li>
    <li>
      Deploying SQL Server in Kubernetes
    </li>
    <li>
      High Availability SQL Server scenarios in Kubernetes
    </li>
  </ul>
</blockquote>

<p>
  <strong>General Sessions</strong>
</p>

<p>
  <a href="https://www.sqlintersection.com/#!/session/Containers%20%E2%80%93%20It's%20Time%20to%20Get%20On%20Board/4365"><strong>Containers &#8211; It’s Time to Get on Board</strong></a>
</p>

<blockquote>
  <p>
    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, learn some common container scenarios and introduce container orchestration with Kubernetes.
  </p>
  
  <p>
    In this session we&#8217;ll look at
  </p>
  
  <ul>
    <li>
      Container Fundamentals
    </li>
    <li>
      Common Container Scenarios
    </li>
    <li>
      Running SQL Server in a Container
    </li>
    <li>
      Container Orchestration with Kubernetes
    </li>
  </ul>
</blockquote>

<p>
  <a href="https://www.sqlintersection.com/#!/session/Containers%20%E2%80%93%20Continued!/4366"><strong>Containers &#8211; Continued!</strong></a>
</p>

<blockquote>
  <p>
    You’ve been working with containers in development for a while, benefiting from the ease and speed of the deployments. Now it&#8217;s time to extend your container-based data platform’s capabilities for your production scenarios.<br />In this session, we’ll look at how to build custom containers, enabling you to craft a container image for your production system’s needs. We’ll also dive deeper into operationalizing your container-based data platform and learn how to provision advanced disk topologies, seed larger databases, implement resource control and understand performance concepts.
  </p>
  
  <p>
    By the end of this session, you will learn what it takes to build containers and make them production ready for your environment.
  </p>
  
  <ul>
    <li>
      Custom container builds with Features
    </li>
    <li>
      Advanced disk configurations
    </li>
    <li>
      Backups/restores
    </li>
    <li>
      Seeding larger databases
    </li>
    <li>
      Backup restore into the container from a mounted volume
    </li>
    <li>
      Resource control
    </li>
    <li>
      Container Restart Policy
    </li>
    <li>
      Container based performance concepts
    </li>
  </ul>
</blockquote>

<p>
  <a href="https://www.sqlintersection.com/#!/session/Linux%20OS%20Fundamentals%20for%20the%20SQL%20Admin/4364"><strong>Linux OS Fundamentals for the SQL Admin</strong></a>
</p>

<blockquote>
  <p>
    Do you manage SQL Server but have developers using Linux? It’s time to take the leap to understand and communicate better with your Linux peers! You might be a Windows / SQL Server Admin but both SQL Server and PowerShell are now available on Linux. You can manage ALL of these technologies more effectively now. Don&#8217;t fear! Linux is just an operating system! While it feels different, it still has all the same components as Windows! In this session, I’ll show you that. We will look at the Linux operating system architecture and show you how to interact with and manage a Linux system. By the end of this session, you&#8217;ll be ready to go back to the office and get started working with Linux with a fundamental understanding of how it works.
  </p>
</blockquote>

<p>
  <a href="https://www.sqlintersection.com/#!/session/Monitoring%20Linux%20Performance%20for%20the%20SQL%20Server%20Admin/4403"><strong>Monitoring Linux Performance for the SQL Server Admin</strong></a>
</p>

<blockquote>
  <p>
    Taking what you learned in our Fundamentals session one step further, we will continue and focus on the performance data you’re used to collecting on Windows! We&#8217;ll dive into SQLPAL and how the Linux architecture / internals enable 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, Memory, and Networking monitoring techniques for each and look some of the new tools available from DMVs to DBFS.
  </p>
  
  <p>
    In this session we’ll cover the following
  </p>
  
  <ul>
    <li>
      System resource management concepts, CPU, disk, memory and networking
    </li>
    <li>
      Introduce SQLPAL architecture and internals and how its design enables high performance for SQL Server on Linux
    </li>
    <li>
      Baselining and benchmarking 
    </li>
  </ul>
</blockquote>

<p>
   
</p>

<p>
  <a href="https://www.sqlintersection.com/#!/?track=sql"><img loading="lazy" style="display: block; margin-left: auto; margin-right: auto;" title="SQLint20_1024x512_NOCENTINO.jpg" src="/images/2020/02/Recording-DeskSQLint20_1024x512_NOCENTINO.jpg" alt="SQLint20 1024x512 NOCENTINO" width="512" height="256" border="0" /></a>
</p>

New Pluralsight Course – Configuring and Managing Kubernetes Storage and Scheduling

My new course “Configuring and Managing Kubernetes Storage and Scheduling” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here! 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 and is the fourth course in my Kubernetes Administration Learning Path.

Let’s take your Kubernetes administration and configuration skills to the next level and get you started now!

Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method

Yesterday in this post I described a method to correct permissions when upgrading a SQL Server 2017 container using Data Volumes to 2019’s non-root container on implementations that use the Moby or HyperKit VM. My friend Steve Jones’ on Twitter wondered if you could do this in one step by attaching a shell (bash) in the 2017 container prior to shutdown. Absolutely…let’s walk through that here in this post.  I opted to use an intermediate container in the prior post out of an abundance of caution so that I was not changing permissions on the SQL Server instance directory and all of the data files while they were in use. Technically this is a-ok, but again…just being paranoid there.

Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes

Recently Microsoft released a Non-Root SQL Server 2019 container and that’s the default if you’re pulling a new container image. But what if you’re using a 2017 container running as root and want to upgrade your system the SQL Server 2019 container…well something’s going to break. As you can see here, my friend Grant Fritchey came across this issue recently and asked for some help on Twitter’s #sqlhelp. This article describe a solution to getting things sorted and running again. The scenario below is if you’re using a Linux based SQL Server container on Windows or Mac host where the container volumes are backed by a Docker Moby or HyperKit virtual machine. If you’re using Linux container on Linux, you’ll adjust the file system permissions directly.