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
-
A project that looked successful. But…
As You know, I will talk about ECM projects again. This time we will focus on what comes after. When everything was delivered on time and within the budget. Yep it’s not fiction, it happens really 🙂 Every KPI is green! At the last steering committee meeting, congratulations were in order. A slide presentation highlighted the project’s key milestones, its…
-
LOB replication with GoldenGate and importance of primary keys
Every time I work on database migrations with GoldenGate, I have the same talks with application teams about missing primary keys. Especially when it comes to LOB replication with GoldenGate. In a previous blog, I wrote about how to interpret the DBA_GOLDENGATE_NOT_UNIQUE view, which lists tables with no primary key or non-null unique indexes. There are two main groups of…
-
GoldenGate row identification: misconceptions and solutions
GoldenGate is a powerful replication tool, but it is so versatile that you should always check whether what you intend to do is supported or not. Oracle provides a few interesting scripts and views to check your environments before attempting a replication with GoldenGate, and I wanted to write about the DBA_GOLDENGATE_NOT_UNIQUE view. Before explaining what this view contains and…
-
Zabbix – Monitoring full cluster Patroni/PostgreSQL
Introduction Monitoring a PostgreSQL environment involves much more than simply checking whether the database is running. In a modern high availability architecture, multiple components work together to keep the service available and stable. In this article, we will explain how to monitor a PostgreSQL cluster environment with Zabbix: The goal of this blog is to provide a simple and clear…
-
Temporary tablespace and ODA 19.31.
I recently patched Oracle Database Appliances (ODAs) to 19.31. For DBs with more than 1 tempfile in the temporary tablespace I got an error during the “odacli update-dbhome” : The issue is that Oracle tries to “set autoextend on” on the temporary files in 19.31., but runs a syntactically wrong command. E.g. in the alert.log I could see I.e. Oracle…
-
The ROI mirage in ECM projects
In my fifteen-plus years working in the ECM world, I have seen the promise of a high ROI (return on investment) numerous times. Faster processes, fewer errors, reduced storage, and improved compliance can all be quantified and multiplied across the organization to create a compelling business case. The benefit is real; otherwise, I would have moved on to something more…
-
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
-
SQL Server Always On Availability Groups and Database Master Keys: A Hidden Failover Pitfall
I recently came across an interesting case involving a client whose application used SQL Server symmetric keys to encrypt sensitive data. The database was hosted in an Always On Availability Group environment for high-availability and disaster-recovery. The interesting and challenging aspect of this setup is ensuring that the encryption and decryption remains intact after a failover. This challenge originates from…
-
GoldenGate NGINX reverse proxy behavior changes
I recently wrote about NGINX reverse proxy reconfiguration after creating or deleting a deployment in GoldenGate. It reminded me that there is an overlooked aspect of the reverse proxy configuration, which is important when trying to automate GoldenGate management with the REST API. In fact, when using a reverse proxy with a single deployment, some endpoints are different from a…
Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.