Infrastructure at your Service

All Posts By

David Barbarin

David Barbarin

Provisioning a AKS cluster and KubeInvaders with Terraform

By | Cloud, DevOps, Kubernetes | No Comments

Provisioning a K8s infrastructure may be performed in different ways. Terraform has a connector called the Kubernetes provider but it doesn’t allow building and deploying a Kubernetes cluster. The cluster must be up and running before using the provider. Fortunately, there are different cloud-specific provider depending which cloud provider you want to provision your cluster. In our CI pipeline for the MSSQL DMK maintenance, we provision SQL Server containers on Linux to perform then different…

Read More
David Barbarin

SQL Server 2019 Accelerated Database Recovery – Instantaneous rollback and aggressive log truncation

By | Database Administration & Monitoring, SQL Server | No Comments

In my previous article about Accelerated Database Recovery (ADR), I wrote mostly about the new Persistent Volume Store (PVS), how important it was important in the new SQL database engine recovery process and the potential impact it may have on the application workload. This time let’s talk a little bit more about ADR feature benefits we may get with instantaneous rollback and aggressive log truncation. These two capabilities will address some DBA pains especially when…

Read More
David Barbarin

Using non-root SQL Server containers on Docker and K8s

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes, SQL Server | No Comments

This is something that I waited for a while, in fact since SQL Server 2017 … and the news came out on Wednesday 09th September 2019. Running Non-Root SQL Server Containers is now possible either on the next version of SQL Server (2019) and it has been backported on SQL Server 2017 as well. Non-root SQL Server containers will likely be part of hidden gem of SQL Server new features, but this is definitely a…

Read More
David Barbarin

When Read-Scale availability groups and Windows Failover Cluster are not good friends

By | Database Administration & Monitoring, SQL Server | No Comments

A couple of days ago, with some fellow French data platform MVPS (@thesqlgrrrl and @Conseilit) we discussed an issue around Read-Scale availability groups and it made me think I had forgotten to share about a weird behavior I experienced with them.   Basically, Read-Scale availability groups are clusterless infrastructures meaning there is no need to install an underlying cluster. Obviously, you will not benefit from resource orchestration and automatic failover, but this is obviously the…

Read More
David Barbarin

How to get a big picture of K8s pods and PVs by script

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes | No Comments

A couple of weeks ago, during an internal dbi services workshop about Docker and K8s, I got an interesting question: is it possible to get a big picture of pods connected to one specific persistent volume (PV) by using kubectl command? It was an interesting question because if we go through the usual kubectl command, it doesn’t provide natively the desired output. In fact, one one hand we get information about PVs and their related…

Read More
David Barbarin

Introducing Accelerated Database Recovery with SQL Server 2019

By | Database Administration & Monitoring, SQL Server | 2 Comments

SQL Server 2019 RC1 was released out a few weeks ago and it is time to start blogging about my favorite core engine features that will be shipped with the next version of SQL Server. Things should not be completely different with the RTM, so let’s introduce the accelerated database recovery (aka ADR) which is mainly designed to solve an annoying issue that probably most of SQL Server DBAs already faced at least one time:…

Read More
David Barbarin

Debugging SQL Server containers considerations

By | Database Administration & Monitoring, Docker, SQL Server | No Comments

When it comes to troubleshooting processes or to get a deeper look of how SQL Server works internally , I always used debugging tools as windbg on Windows and since SQL Server is available on Linux, I switched to strace tool. But let’s add containers in the game now. I didn’t want to touch any based image for applications including SQL Server with debugging tools added. So, my concern was to figure out how to…

Read More
David Barbarin

Deploying SQL Server 2019 container on RHEL 8 with podman

By | Database Administration & Monitoring, DevOps, Docker, SQL Server | No Comments

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 purely experimental. This time I wanted to share with you some thoughts about the new…

Read More
David Barbarin

SQL Server 2019 availability group R/W connection redirection, routing mesh and load balancing

By | Database Administration & Monitoring, SQL Server | No Comments

SQL Server 2019 availability group feature will provide secondary to primary replica read/write connection redirection. I wrote about it in a previous blog post here. It consists in redirecting client application connections to the primary replica regardless of the target server specified in the connections string. That’s pretty interesting in some scenarios as read scale-out or specific multi-subnet configurations where creating the traditional AG listener is not an viable option. The new R/W connection redirection…

Read More