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.
At the moment, three versions of GoldenGate are still under Premier Support, but this will very soon change, with GoldenGate 19c and 21c coming out of Premier Support in April this year ! I give below the official Oracle support end dates, as per 2026. GoldenGate Release Release date End of Premier Support End of Extended Support 23ai May 2024…
Context In the era of digital transformation, attack surfaces are constantly evolving and cyberattack techniques are becoming increasingly sophisticated. Maintaining the confidentiality, integrity, and availability of data is therefore a critical challenge for organizations, both from an operational and a regulatory standpoint (GDPR, ISO 27001, NIST). Therefore, data anonymization is crucial today. Contrary to a widely held belief, the risk…
In the first article, we discovered Exascale from a high level overview with a focus on Exascale Infrastructure. In this new article, we will dive into the Exascale storage architecture, with details about the physical components as well as the services and processes managing this new storage management approach for Exadata. In this blog post, we will explore the Exascale…
Nested transactions in SQL Server don’t provide real isolation; @@TRANCOUNT rises, but only the main transaction controls locks.
The latest MongoDB DMK release (2.3.1) introduces a lot of new features and important changes, which I will describe here. dbi services provides the DMK (Database Management Kit) to its customers for multiple technologies: Oracle, Postgres, MongoDB, etc. This toolkit is provided free of charge to all clients who work with dbi services on a consulting project. The DMK is…
In recent customer projects I had less to do with PostgreSQL but more with reviewing infrastructures and give recommendations about what and how to improve. In all of those projects GitLab is used in one way or the other. Some only use it for managing their code in Git and work on issues, others use pipelines to build their stuff,…
Another day, another not-so-documented GoldenGate error, this time about the OGG-10556 error, which I had when setting up replication on a new GoldenGate installation. After making changes from the web UI in an extract, I ended with the following error when starting it: Since the exact configuration is not relevant here, I will not add it to the blog. After…
A deep dive into how SQL Server processes XML, the performance impact of XQuery methods, and why proper indexing matters.
If you start using the GoldenGate web UI after installing it, you might end up thinking that extending the session timeout would be nice. Since there is no clear Oracle documentation on that matter, here are multiple ways of doing it. Modifying the configuration files: quick but with downtime The first way of doing it is to modify the deploymentConfiguration.dat…
To run a Perl script directly like a binary from within the shell, you have to the 2nd and 3rd example will run the script with the given Perl-binary. The 1st example uses the 1st perl binary found in $PATH If you work with Oracle and want to use a Perl script connecting to the database, then the Perl from…
Introduction When wanting to migrate from the big red to PostgreSQL, most of the time you can afford the downtime of the export/import process and starting from something fresh. It is simple and reliable. Ora2pg being one of the go-to tools for that. But sometimes, you can afford the downtime, either because the database is critical for business operations or…
