Insights. One level above.
We know what above looks like. Explore the expertise built inside most demanding environments.
More than 9.9 million reads in the past 2 years See what readers open most
-
Beyond TDE and TLS: Bridging the Data Security Governance Gap in Lower Environments
Why one layer is never enough, why dev environments are your biggest GDPR gap, and how to industrialize their governance.
-
Not enough space for using ODABR? Reduce /u01 and /opt size on your ODA
Introduction The patching of an Oracle Database Appliance needs to be secured. This is because it won’t limit to patching the databases: there is plenty of other components embedded with the patch, the goal being to keep everything updated. A possible rollback may be needed. For sure, there is no possible rollback for firmwares, BIOS and ILOM (it’s unlikely you…
-
Bulk update of GoldenGate extract profiles
After writing blogs about Default profile updates and a bug affecting profiles in GoldenGate 26ai, I realized it would be a good idea to present a quick way to update all processes at once with the REST API. Because even if you set a new profile as default with the {“isDefault”: true} flag, previously created extracts and replicats will not…
-
Loosing java remote console full control during ODA Reimage
Recently I had to patch an ODA at one of our customer from 19.20 to 19.26, going through 19.24. As you are aware of, knowing we go from Oracle Linux 7 (19.20) to Oracle Linux 8 (19.24), we need to patch the ODA using Data Preserving Reprovisioning. This includes a reimage of the nodes… Data Preserving Reprovisioning will allow you…
-
The day your ECM System became unusable
It started like any normal Tuesday.No alarms. No warning signs. No urgent emails flooding inboxes before 8 AM.Just a regular working day, until people tried to open documents.At first, it was a single complaint.“Hey, I can’t access the invoice archive.”Then another.“The HR files are taking forever to load.”Then ten more.“Nothing is opening.”And within an hour, the entire ECM system, the…
-
PostgreSQL 19: Importing statistics from remote servers
Usually we do not see many foreign data wrappers being used by our customers. Most of them use the foreign data wrapper for Oracle to fetch data from Oracle systems. Some of them use the foreign data wrapper for files but that’s mostly it. Only one (I am aware of) actually uses the foreign data wrapper for PostgreSQL which obviously…
-
GoldenGate 26ai logs explained
GoldenGate logs are a powerful source of information when troubleshooting or analyzing your deployments. However, there is at least one log file per service in the Microservices Architecture. This means that for a GoldenGate setup with multiple deployments, you can quickly have tens of log files to search for information. In that context, knowing where to look is important, especially…
-
Create distribution paths in NGINX-secured GoldenGate 26ai
Setting up a distribution path is an important step when connecting two GoldenGate deployments. However, there are so many connection options that it’s hard to know how to proceed. In this blog, I will present the way to connect two deployments secured through NGINX. Here are the prerequisites before attempting the distribution path creation: In my environment, I have the…
-
PostgreSQL 19: Online enabling of data checksums
Since PostgreSQL 18 was released last year checksums are enabled by default when a new cluster is initialized. This also means, that you either need to explicitly disable that when you upgrade from a previous version of PostgreSQL or you need to enable this in the old version of PostgreSQL you want to upgrade from. The reason is, that pg_upgrade…
-
Let’s work together
Ready to operate at
the next level?Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.
-
Most read
More than 360,000 reads in the last 30 days
The posts our readers open most: the all-time favourites, and what is trending right now.
All-time favourites
- Automate encryption-in-transit for SQL Server 124,231 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,760 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,132 reads
Trending, last 30 days
-
M-Files didn’t fix your problem, your organization did.
Last week a wrote about the reasons why ECM projects fails. M-Files is a wonderful tool and probably my favorite ECM, but it won’t solve your problem. Companies that initiate digitalization projects like to convince themselves that investing in an ECM will solve all their problems: no more chaos, data loss, inefficiency, or lack of collaboration. I’m sorry to break…
-
PostgreSQL 19: get_*_ddl functions
PostgreSQL already comes with plenty of system information functions to reconstruct the commands to create various objects, e.g. constraints or indexes. Starting with PostgreSQL 19 more functions will be available, namely those: As the names imply they can be used to recreate the commands to create a database, a role, or a tablespace. To see what they do lets create…
-
PostgreSQL 19: json format for “copy to”
PostgreSQL already has impressive support for working with data in json format. If you look at the jsonb data type and all the built-in functions and operators you can use, there is so much you can do with it by default. Starting with PostgreSQL 19 there is one feature more when it comes to working with data in json format.…
Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.