327 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
Why I built a Teradata real-time ingestion process for Apache NiFi using 200 ms time-bounded microbatches, automatic VOLATILE TABLE generation and set-based MERGE.
AI is changing the economics of coding. Why experienced data professionals can achieve more, and how freelancers can turn that shift into a stronger business.
A critical look at Exasol’s Teradata migration arguments, the Helsana customer results, and why a fair comparison must cover the complete production workload.
A reproducible Teradata insert-only loading test comparing individual MERGE calls, transaction batching and array-bound staging, with complete SQL and DBQL evidence.
A slow query, a licence renewal or a rising cloud bill can start the same conversation: should we move to a different data platform? The useful first question is more specific: which requirement can the current system no longer meet, and what evidence shows why? Migration can be the right answer. So can targeted optimisation, …
How AI multiplies engineering productivity, and why cutting experience can erase the benefit Companies that understand AI will use it to multiply expertise, not eliminate it. The others will see only the dollar sign, replace experienced engineers with cheaper developers plus an LLM, celebrate the quarterly savings, and proudly call it transformation. Artificial intelligence is …
Load isolation sounds like a feature that should improve concurrency. After all, it’s one of the primary reasons for enabling it: data should be loaded while applications and users continue to query the table without being unnecessarily disturbed by the load. In one system, however, we observed exactly the opposite behavior. A monitoring query periodically …
Cloud migration changes how workload management, physical design and governance are implemented. AI agents may also change utilization and costs; the effect depends on workload behavior and pricing.
The charts below are historical observations from the stated data setup. Current checks confirmed the corrected table definitions and row retrieval, not the ten-million-row storage/CPU benchmark. Treat its percentages as case-specific rather than current platform guarantees. Learning path: Compression and space. View the suggested reading order. This reference includes release-specific examples; check the version context …
Learning path: Internals and operations. View the suggested reading order. This reference includes release-specific examples; check the version context before applying a technique. This guide collects the material on this site about how Teradata behaves underneath the SQL — what the database does when it is under pressure, how it protects and isolates data, and …
Follow DWHPro in Google to see our articles more often in Search.
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.