Development & Performance

Scanning Ansible code with Ansible Lint

Introduction It’s always good to learn something new. But doing it the right way from the very beginning is even better. I recently started to work with Ansible and after creating a few roles, I quickly realized that there(…)

SQL Server: Using Client Statistics to validate a query regression after a change in the database compatibility level

Few days ago, I have very poor performance on a database that I migrate from SQL 2012 to SQL 2019. The developer Team asks me to upgrade the number of CPU and the Memory to have better performance.

SQL Server SCOM Alert Analysis: The Average Wait Time of SQL instance “xxx” on computer “xxx” is too high

I have an interested alert on SCOM for SQL Server by a customer two weeks ago. In the SCOM interface, the warning on the server is MSSQL2016: The Average Wait Time of SQL instance “xxx” on computer “xxx” is(…)

SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW

By a customer, the SCOM’s Database OperationManagerDW growth fast and becomes very big. To see what’s happens, in SSMS (SQL Server Management Studio), I right-click on the database open Reports>Standard Report> Disk Usage by Top Tables: You have(…)

Working with multipass, a VM manager

Introduction What if you need quickly to launch virtual machine instances running Ubuntu for development and testing purposes. Multipass from Canonical can be the right tool for this. You can even customize the instances during launch by using Cloud-init in(…)

SUMA Server Part 2

In my previous Blog I wrote how to install and configure SUSE Manager. In this Blog I will go more in the deep like repository management and PXE boot configuration. Configuring repository To syncronize(…)

First steps on Kusto Query Language (KQL)

Do you know this query language?  No, it’s time to explain you and see what it is.   “A Kusto query is a read-only request to process data and return results.” dixit Microsoft Documentation here The KQL(…)

Ansible Custom Interactive Dynamic Inventory

When working with an Ansible dynamic inventory, you may want to update it from your playbook on the fly. For instance, you may want to create a server and then install an application on it without calling a second playbook(…)

Oracle Database Appliance vs Oracle Cloud Infrastructure

Introduction Oracle Database Appliances are very popular these days. And not only among new customers for this kind of engineered systems. Almost all customers already using old generation ODAs are renewing their infrastructure by choosing again ODAs, meaning that the(…)

Boost your CPU speed with Standard Edition 2 on ODA

Introduction There is no need to decrease the number of cores on your ODA when using Standard Edition 2, because your license is based on the number of physical CPU. So why would you do that? Obviously, the more cores(…)