Managing SQL Server trace flags effectively is a common task for DBAs and system engineers, especially when tuning the SQL Server behavior for specific use cases or performance optimizations. While trace flags can be enabled programmatically using T-SQL commands such as DBCC TRACEON, this approach has an inherent limitation: the flags are session-based or global only until the SQL Server…
I attended this tour from Red Hat to promote automation at Ansible automates roadshow with my colleague Arnaud Berbier. You’ll find his review of the journey here) in Geneva. It was the third date from their tour. In case you’re interested in automation with Ansible there is 2 more dates in Germany. It started with Loïc Avenel who is the…
Procedure to check a one-to-one migration between different database types autogenerated and generically with OMrun.
You want to deploy Ansible AWX on a Kubernetes cluster using awx-operator, but your security policy requires you to use a local registry to store the necessary container images ? Okay, let’s see how to do this using Helm. Default deployment By reading the awx-operator documentation, you should have a values file similar to this one (with spec values according…
I will add another example of what can be done with Ansible Driven Automation by interfacing it with Kafka. For those who wonder what Event-Driven Ansible is have a look at my previous blog about it. Additional Installation Steps In my previous blog, I already listed the steps to setup Event Driven Ansible (EDA). To connect to Kafka (I will…
In my previous blogs about Ansible, I covered a few use cases: All these still require a manual trigger to run. With Ansible Event Driven (AED), we can be pro-active by running playbooks automatically based on events. Installation To install, it is just a few commands: Now, we are ready to run our first rulebook. Rulebook AED introduce a new…
Oracle delivers patches for WebLogic every 3 months. These Critical Patch Updates (CPU) are often composed of multiple patches which makes even more steps to have them installed on server: Since April 2021, Oracle is providing what they are calling a Stack Patch Bundle (SPB) which includes Stack Patch Bundle Automation Tool (SPBAT). This make the installation easier and safer.…
So again during the 3rd day of the re:Invent 2022 there were plenty of interesting information to take with us. However, the most interesting part was for sure the workshop about gray failures and how to mitigate them in a multi-AZ environment. Let me try to wrap this up for you… What are gray failures? No idea what “gray failures…
If you are following social medias, you are probably aware of the new product that dbi services launched which is called YaK (news here). With Pascal Brand, we are working on developing new components for it. I will share my experience on creating new components with few tips that could makes your development faster and safer. By the way, dbi…
Even if YaK Core does not manage on-premises servers provisioning, these can be easily added to YaK inventory. If you are too excited, can’t wait to test YaK and have no cloud account handy, you can use our demo or deploy on premises. Infrastructure Definitions For on premise, we have to create the directory structure under configuration/infrastructure. Let’s call it…
In the 1st post of this serie, I demonstrate how easy it is to install AWX on a local Minikube Kubernetes cluster. Now that the installation is done and the access to the web console is working, let’s find out what kind of objects should be created to best manage Ansible playbooks deployments using AWX. AWX Command Line Interface Obviously…
AWX is a web based GUI tool for managing Ansible playbooks. It is the open source upstream project of Red Hat Automation Controller (formerly Ansible Tower) . As for Fedora and RHEL operating systems, the releases of Automation Controller are created from a branch of AWX, which sponsored is by Red Hat. AWX provides user interface, REST API and task…
