Microsoft Team

How to use the licensing Control-M reporting tool

BMC Software requests yearly a licencing report of the usage of Control-M at the customer site, for that they send you a request to generate a report by using a Usage Reporting Tool provided by them and send back the(…)

How to trigger an action in On Do Action based of a text in the Job Log output

Normally we can trigger an On Do Action based on string found in the Job Output. But we would like to do the same for a Job log, that feature doesn’t exist, but there is a way to make it(…)

Microsoft Teams, Power Automate and Planner

As we moved to Teams at dbi and one of our customers, automating tasks was a strong need. One of the tasks that could be automated is the creation of tasks in Microsoft Planner which does not support recurring tasks.

How to automate a kill of one or several executing jobs in AJF at specific Date/Time at once

Introduction We had a request to automate a kill of some executing jobs in AJF at specific date and time. For example: A Control-M job is running a script all day, in order other programs can connect to it,(…)

How SQL Server MVCC compares to Oracle and PostgreSQL

By Franck Pachot . Microsoft SQL Server has implemented MVCC in 2005, which has been proven to be the best approach for transaction isolation (the I in ACID) in OLTP. But are you sure that writers do not block readers(…)

Provisioning a AKS cluster and KubeInvaders with Terraform

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.

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

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(…)

Using non-root SQL Server containers on Docker and K8s

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(…)

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

A couple of days ago, with some fellow French data platform MVPS (@thesqlgrrrl and @Conseilit) we discussed an issue around Read-Scale availability groups(…)

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

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(…)