All articles

SQL Server: Disabling FileTable/FileStream on an AlwaysOn high-availability instance

Contexte A customer recently asked me to disable FileTable/FileStream on their instance because the databases no longer use it, and to ensure that this is indeed the case.The aim is to migrate to a new architecture without FileTable/FileStream in(…)

Who owns the information? Data ownership and stewardship in an ECM

I often see this pattern in organizations. The ECM project was an overall success: the migration is complete, and users are happy with the new solution. But after a year or two, the magic faded. Search results are cluttered(…)

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(…)

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: CREATE TABLE autosch.t1 ( id NUMBER PRIMARY KEY, name VARCHAR2(50), amount NUMBER(10,2),(…)

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(…)

GoldenGate AI Service bug confirmed in the Maximum Input Characters setting

In a previous blog, I noted that there might be a bug with the Maximum Input Characters setting in GoldenGate 26ai AI Service. The bug was confirmed by Oracle, so let’s see what it is(…)

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(…)

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(…)