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
-
Calling AI from SQL Server 2025 can lock everyone out of your on-prem instance
sp_invoke_external_rest_endpoint has no limit in SQL Server 2025: each waiting call holds a worker. Compared with Azure SQL.
-
Removing instantiation filtering from a GoldenGate replicat
In a recent blog, I explained how instantiation filtering works. DBOPTIONS ENABLE_INSTANTIATION_FILTERING makes a replicat discard any record whose commit CSN is at or below a table’s instantiation CSN. It applies everything above it. This replicat parameter should be kept during the whole initial load process. At some point the replicat has processed past the instantiation boundary for every table,…
-
GoldenGate 26ai AutoSchema TYPEMAP: overriding the default datatype mapping
In my blog about the new automatic schema evolution feature in GoldenGate 26ai, I was replicating the following table from Oracle to PostgreSQL: The replicat created a PostgreSQL table from an Oracle one during an initial load. It worked, but one choice was not mine: the NUMBER primary key became a varchar(50). Automatic Schema Evolution takes its datatypes from a…
-
Archiving 5 TB from Oracle into SQL Server: views, indexes and compression (part 2)
Translating 4,000 Oracle views, rebuilding indexes offline on Standard Edition, and compressing clustered index to save 1T.
-
Is your content ready for AI?
Imagine an employee asking the company’s AI assistant, ‘What is the notice period for supplier XYZ?’ The answer comes back immediately: a clear, precise quote from the contract. It sounds right, so nobody checks it. However, the quoted contract is an expired draft. The signed amendment that changed the notice period is stored somewhere else entirely. This is a hypothetical…
-
SQL Server 2025 CU5: max lock manager cache memory (%): what I could reproduce and what I could not
Cumulative Update 5 for SQL Server 2025 was released on May 20, 2026 (build 17.0.4045.5). Seven entries in the KB, mostly fixes. One of them is not a fix: it is a new server configuration option, max lock manager cache memory (%). Reference: https://support.microsoft.com/en-us/servicing/sql/sql-server-2025/cumulative-update/kb5084896-cu5 I built a lab on CU5 and on later builds up to CU9 and I spent…
-
GoldenGate 26ai automatic schema evolution: creating missing tables during an initial load
For as long as I have used GoldenGate, an initial load had one prerequisite: the target tables must already exist. Data Pump takes care of it between two Oracle databases. For anything else, you write the CREATE TABLE statements yourself, with the datatypes you choose, or choose another initial load method. The Automatic Schema Evolution feature launched in GoldenGate 26ai…
-
AI problems are database problems
Introduction When discussing agentic AI, we spend a lot of time on the model. Which one should we use? How much context does it support? Can it choose the right tool? These are useful questions. But from a my perspective, there are a few others I would ask quite early. Where does the agent store its state? Who can access…
-
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 430,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,224 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,721 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,106 reads
Trending, last 30 days
-
AI agents on sensitive data: what PostgreSQL can enforce, and what it can’t
Every useful database content, document behind an internal AI agent names someone, a company, server names,… A relationship manager might ask “what did this client complain about last quarter?”, an operations engineer might ask “what happened on this server last month?”, and the answer sits in notes, emails and incident tickets, CRMs and ERPs data, full of client names, staff…
-
SOUG Day October 2026
What a great and interesting day I could spent today at the SOUG Day which took place at the SIX ConventionPoint in Zurich. Thanks to the whole SOUG team for the great organization and to all the speakers for the interesting sessions. Oracle Database Mission-critical Technologies by Ashish Ray (Oracle) In his presentation, Ashish definitively confirmed that the new driver…
-
Zabbix – the Swiss Army knife of monitoring
In today’s data-driven economy, downtime isn’t just an IT headache; it’s a direct hit to your bottom line. As modern environments grow more complex, spanning hybrid clouds, edge devices, and massive enterprise clusters, Zabbix monitoring provides the single source of truth IT teams need. The biggest challenge for IT Managers today isn’t a lack of data; it’s fragmentation. Using one…
Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.