Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
By end of June 2023 Oracle announced the availability of Oracle 19c for the Arm-architecture (aarch64). Consultants and DBAs, who do use a Mac Laptop with Apple Silicon (M1 or M2), have waited quite a long time to run an Oracle database in a Sandbox environment on their Apple machine. The database software Oracle 19c is not certified on MacOS.…
In the world of database management, high availability and data integrity are of most importance. Patroni, a robust open-source solution, offers a way to manage and maintain PostgreSQL high availability clusters seamlessly. However, even with tools like Patroni, you can face challenges. The setup: Patroni Cluster Installation I had the mission of setting up a Patroni cluster for a critical…
Introduction: Security is an important matter when using or allowing access to your database.You need to be sure that nobody will harm your infrastructure by passing some dangerous commands. Aim is to limit the access to user to specifics rights when he will authenticate on the database. For that we will use the Redis ACL feature. Let’s see how it…
Introduction It’s been several weeks that patch 19.19 is available on ODA. And I finally had the possibility to test it. What’s new? This version brings latest PSUs to database and grid homes, with their bug fixes as usual. It also brings latest 21c and 19c DB Systems. You already know that 21c is an innovation release. 23c will be…
As you know, with the new version of SSMS since the version 18, the tools like sqlcmd are no more included in the installation. You need to download separately the tools that you need here Few months ago, Microsoft announces the replacement of the “old” sqlcmd with a new version called go-sqlcmd. This new version includes all parameters from the…
As part of a very exciting project around Oracle Exadata Cloud @ Customer (aka. ExaCC) technology, we wanted to rollout in an automated manner the database software aka. ORACLE_HOME on ExaCC database clusters (aka. VM cluster). However, we rapidly identified a small lack of command-line parameters to “mimic” the console behavior. This post describes briefly how to get rid of…
PostgreSQL 16 (currently in beta 2) will come with a new view for tracking I/O related statistics. I’ve written a very basic blog about pg_stat_io in the past. In this post and some follow up posts we want to dig a bit deeper into the various statistics this view provides. The first statistic we want to look at is “extends”.…
Sometimes it becomes handy when you can auto-generate a column based on an expression. For this there is the concept of generated column. Those columns can be either of type “stored” (the derived value is computed when the column is written) or “virtual” (the derived value is computed when the column is being read). Currently PostgreSQL only supports the “stored”…
Introduction: Users are always searching to ease their life when using their favorite Nosql tool such as MongoDB. Current methods are fine but what if you want to go further when developing on MongoDB?Is their any way to edit your files, update it use scripts and more?The answer is YES! By using the MongoDB extension for VS code you will…
Introduction: During a Control-M installation, you can face some issues, sometime it’s due to a lack of prerequisites ( Keep the best practices and be sure to follow the advice from BMC site experts, take a look on the installation documentation to fill all the prerequisite). However it can be a singular issue ( not as explicit as a right…
Today at a customer I faced this: “System catalog modifications are currently disallowed” which, honestly, I’ve never seen before. Why would someone try to modify the system catalogs, at least in a productive environment? It turned out to be pretty simple, but when I’ve seen this I was somehow lost. The command which was executed was: Sometimes customers do things…
We continue our blog series about Prometheus, today addressing a particularly interesting but often overlooked topic: Prometheus Instrumentation. What does that mean? I’m not telling you anything new when I say that Prometheus allows you to collect tons of metrics, assess the health of your systems, and keep an eye on everything that’s happening, thanks to a wide range of…
