Development & Performance

First contact with OCI’s Autonomous Database

Introduction Benefits of going into the Oracle Cloud (OCI) are clear for most of us: no more datacenter and hardware to manage. But what else? On OCI, you can also decide to get rid of part of the DBA tasks(…)

SELECT FROM DUAL : Oracle Performance And Tuning

The DUAL table is automatically created by Oracle and contains one column (DUMMY) and one row (x value). This table is often used by SQL developer in PL/SQL code (Package, Functions, Trigger) to initialize variables storing technical information such as(…)

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