Database Administration & Monitoring

Patching ODA HA from 19.8 to 19.10

In this blog I am describing the steps to patch an ODA HA from the version 19.8 to version 19.10. The patching was done with a customer. Thanks to Pierre. The name of the servers were changed The ODA(…)

PostgreSQL: set_config and current_setting

PostgreSQL comes with a rich set of administrative functions for various use cases. There are functions to control parameters, there are functions for index maintenance, others are for recovery and or backup control and there is much more. In this(…)

Building a PostgreSQL EC2 AMI for testing the latest commits

Testing the latest features or bug fixes in PostgreSQL can easily be done by pulling the latest commits from the git repository and compile PostgreSQL from source code. I am doing that frequently on my local sandbox VM but this(…)

Is it possible to switch a service between 2 pluggable databases?

Introduction In an Oracle database, services have multiple purposes: identifying group of users prior authenticating them enabling/disabling access to a database for particular groups managing preferred nodes on a RAC configuration redirecting users to the primary after a switchover/failover when(…)

SQL Server CPU limitation for Express and Standard Edition

Introduction When performing an audit on an SQL Server VM the first thing the system administrator told me was that there’s no issue with the CPU on this box, the monitoring shows it’s always around 50% usage. Problem Here is(…)

SQL Server: Get email notifications for Error Log entries

Introduction In a previous blog post, I did a T-SQL script reading Audit files to send emails with valuable information about instance changes. In this one, you will see how to get nice emails from critical errors or(…)

SQL Server: How to delete the msdb backup history kindly

This week I noticed some slowness on queries related to backup history. The instance had a huge msdb database (more than 10GB size), the backup history had never been purged. I already wrote a post on this topic and(…)

SQL Server: Replace the old SCOM login by the new one

It’s every time hard to replace a login who as role and permissions in every database like the service account for SCOM. In the previous version of Scom, you create a service account (dbiscom) to access the SQL Server(…)

Ansible Basics Workshop day @dbi services

Today, I follow our Workshop Ansible Basics with Jérôme Witt. Why I follow this workshop? First, it’s to have the basics and Best Practices before begin myself and do “bricolage” by my customers.

SQL Server: Audit changes on Instance Configuration, Linked Servers and Agent Jobs

Introduction Very often with our customers, there is only one person with the DBA role. The configuration of the instances is then under control and if anything strange has to be questioned, the culprit is quickly identified. 🙂 When(…)