Skip to content

DevOps

How we automate infrastructure and databases so that deployments become boring: Ansible, Docker, Kubernetes, CI/CD pipelines, infrastructure as code, GitOps, Control-M scheduling and our own YaK deployment framework.

SQL Server 2019: Java in SQL Server hard to believe, no?

It has already been a few months that we are testing the next version of SQL Server: SQL Server 2019. I already blogged about a previous version of SQL Server supporting R and Python. With the new version of SQL Server 2019, Java will also be integrated. The Java runtime used is Zulu Open JRE and can be tested from… 

Windows Docker containers, when platform matters

A couple of days ago, I got a question from a customer about an issue he ran into when trying to spin up a container on Windows. The context was as follows: > docker container run hello-world:nanoserver Unable to find image ‘hello-world:nanoserver’ locally nanoserver: Pulling from library/hello-world C:\Program Files\Docker\docker.exe: no matching manifest for windows/amd64 10.0.14393 in the manifest list entries.… 

CloudBees DevOps Playground – Hands On with JenkinsX

Last week, we had the chance to attend to the CloudBees DevOps Playground in London. The event was a presentation and a Hands-On on Jenkins X done by one of the most popular guys from the CloudBees, Gareth Evans. Before taking an interest in Jenkins X, we focused most of our time in the Docker and Kubernetes part. We enhance… 

Deploying SQL Server 2019 container on RHEL 8 with podman

Having a fresh install of RHEL8 on my lab environment, I was curious to take a look at new containerization stuff from Red Hat in the context of SQL Server 2019. Good chances are the future version of SQL Server should be available and supported on with the latest version of Red Hat but for now this blog post is… 

Kubernetes – How to install a single master cluster with kubeadm?

To bootstrap a minimal K8S cluster for testing purpose, kubeadm is a very interesting tool. The goal of this blog is not to explain to you the K8S architecture or the components but only the deployment part. using kubeadm. The final architecture of our cluster will be the following: Source:https://elastisys.com/2018/01/25/setting-highly-available-kubernetes-clusters/ Docker Installation The first step is to install Docker on… 

Microsoft Inspire Partner Event 2019 / Day 1

dbi services at Microsoft Inspire Conference Summary of my first participation – Day 1 After 20 years in the business of IT Infrastructure, time has come to open my mind 😉 and Microsoft Inspire is the perfect opportunity. It is a partner conference that has quite a different approach compared to other software editors I worked for (e.g. Oracle). Indeed,… 

SQL Server containers and docker network driver performance considerations

Few months ago I attended to the Franck Pachot session about Microservices and databases at SOUG Romandie in Lausanne on 2019 May 21th. He covered some performance challenges that can be introduced by Microservices architecture design and especially when database components come into the game with chatty applications. One year ago, I was in a situation where a customer installed… 

Deploying SQL Server on Azure virtual machine with Terraform

We are entering now to the infrastructure as code world and provisioning a SQL Server infrastructure is not excluded from the equation. This is especially true when it comes the Cloud regardless we are using IaaS or PaaS. One great tool to use in such scenario is certainly terraform and I introduced it during the last PowerSaturday pre-conference named “DBA… 

Windocks and K8s support

I got recently the 4.08 update from the Windocks team and I was very excited to evaluate some of new features. The first cool one I want to present in this blog concerns the Kubernetes support for deploying Windocks containers that will make my application deployment definitely easier. Let’s say you want to deploy your application that is tied to… 

Windocks, SQL Server and Azure in our internal CI pipeline

During the last DevOps Day in Geneva, I presented a sample of our CI implementation related to our MSSQL DMK maintenance product. It was definitely a very good experience for me and good opportunity to get feedback from DevOps community as well. During the session I explained our CI pipeline includes SQL Server containers both on AKS (K8s as managed… 

Upgrading SQL Server pods on K8s and helm charts

It has been while since my last blog. Today it is about continuing with helm charts and how to upgrade / downgrade SQL Server containers to a specific cumulative update. My first write-up in my to-do list. Last year, I wrote an introduction of SQL Server containers on K8s. I remembered to face some issues when testing upgrade scenarios (probably… 

How workload policies is making your life easy

Working as a control-M administrator, we are often requested to hold jobs or stop jobs during a period of time. Holding jobs and updating the job configuration might not be the most efficient way to do this. Workload policies is making your life really easier, giving you the possibility to configure such modification in advance and to let the system…