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
-
Rename a GoldenGate extract with the REST API
In a previous blog, I went through the full procedure of renaming a GoldenGate extract from the adminclient. I included all necessary steps to avoid missing transactions. Doing this by hand is completely fine, but if you do it often, or want to remove the risk of a typo on an SCN, I have another solution for you. In this…
-
SQL Server: Stop ordering index columns by selectivity
Column order does not affect equality seeks in SQL Server. Measured on 5M rows, then proven inside the B-tree pages.
-
GoldenGate REST API Python client now on pip
In a previous post, I shared the OGGRestAPI Python client I built for the GoldenGate REST API. Since then, I kept using it on production deployments, fixing it and adding new features along the way. It felt like the right time to stop asking people to copy a .py file into their project, so I published it to PyPI. You…
-
Why UUIDv7 does not reduce fragmentation in SQL Server
UUIDv7 places its timestamp first, but SQL Server compares uniqueidentifier values starting from the last bytes. Measured on 25,000 inserts: no gain over NEWID().
-
M-Files AI: from Intelligent Metadata to AI Agents
For years, the primary role of artificial intelligence in enterprise content management (ECM) has been to analyse documents. This involved extracting information, classifying documents, suggesting properties, and identifying similar content or patterns. To be honest, that was already quite useful. For years, M-Files has offered capabilities such as Text Analytics, Matcher, Smart Metadata, and Smart Classifier. These intelligent services analyze…
-
MongoDB DMK 2.6.0 : pymongo integration and new features
In this blog, I will present the new features introduced with the latest release (2.6.0) of the MongoDB DMK. The DMK is a set of standardized tools that aims at easing the work of DBAs by having dbi’s best practices embedded in common scripts across all the database servers of an organization. dbi services provides the DMK (Database Management Kit)…
-
AWS Summit Zurich 2026 Edition
New AWS Summit, new day to learn new stuff and deepen my knowledge of this cloud provider. As a starter, I attended the Keynote. The various speakers explained to us the benefits of AWS for startups, how they push newcomers to join the cloud and also help students with their AWS projects. We also had a few customer feedbacks where…
-
Rename a GoldenGate extract without missing transactions
Throughout my consulting missions, I have often been asked to rename GoldenGate extracts. While this is not a difficult task, it should still be done correctly to avoid missing transactions. In this blog, I will explain how to rename a GoldenGate extract from the adminclient. If you often rename extracts, or want to remove the risk of a typo on…
-
The forgotten power of relationships in ECM
In many people’s minds, an Enterprise Content Management System (ECM) is just a shared folder on steroids: enhanced security, lifecycle tracking, and more efficient search capabilities. This is broadly true and can encourage user adoption by explaining what obscure acronyms like DMS, ECM, and IMS mean. However, this definition is too restrictive. A good ECM can do much more and…
-
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 340,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,233 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,764 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,136 reads
Trending, last 30 days
-
GoldenGate DB2 z/OS upgrade checklist
Upgrading GoldenGate when the source is DB2 for z/OS is not quite the same exercise as upgrading a GoldenGate installation for Oracle. Most of what I described in my generic blogs about planning a GoldenGate upgrade and migrating from Classic to Microservices Architecture is still valid. However, there is an extra layer to deal with. It has to do with…
-
Fixing ORA-00904 on Oracle hidden columns during SSMA data migration
SSMA fails with ORA-00904 on Oracle SET UNUSED columns. Fix it with a custom select aliasing NULL, no source DDL required.
-
NGINX secured distribution path with GoldenGate REST API
In a previous blog, I presented how to set up a distribution path between two GoldenGate deployments both secured with NGINX. The method I used there was purely through the Web UI. But GoldenGate also exposes a full REST API, and everything you can do in the UI can be done through the API as well, which is useful for…
Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.