DWHPro Insights

Insights

327 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.

Teradata Physical Design and Data Modelling Most read

Learning path: Physical design. View the suggested reading order. This reference includes release-specific examples; check the version context before applying a technique. Most Teradata performance problems are designed in long before anyone writes the query. This guide collects the physical design material from this site — the data model, the staging and preparatory layers, partitioning …

Read more

Teradata SQL Tuning and Query Rewriting Most read

Learning path: SQL tuning and rewriting. View the suggested reading order. This reference includes release-specific examples; check the version context before applying a technique. The cheapest Teradata tuning available is almost never a new index. It is rewriting the query so the optimizer has less work to do and better information to do it with. …

Read more

Teradata Statistics and Cardinality Estimation Most read

Start with the tested SQL: The practical Teradata statistics guide includes COLLECT STATISTICS syntax, before-and-after EXPLAIN estimates, sampling and recollection examples tested on Teradata 20.00.28.81. The specialist examples below retain their original release context and were not retested in that lab. Learning path: Statistics and row estimates. View the suggested reading order. This reference includes …

Read more

From Pay-as-You-Go to Pricing Lock-In

Two cloud icons: one carrying a clock and a price tag, an arrow leading to a second cloud holding an AI brain and a checkmark

Rethinking Cloud Pricing in the Age of AI AI, the Future of Cloud Pricing, and Business Outcomes AI Changes the Economics of Compute Continuous productive use can reduce scale-to-zero savings, but elasticity still helps changing demand and concurrency. Provider efficiencies and contract terms can also affect cost. The pricing outcomes discussed here are forecasts, not …

Read more

AI Is Automating the Work That Creates Experts Widely read

Hand-drawn infographic comparing a junior engineer's learning cycle, where a mistake builds judgment, with an AI-answered task that leaves a gap in understanding

Artificial intelligence allows consulting and technology companies to complete many tasks with fewer employees. A senior consultant supported by AI can analyse requirements, generate code, prepare documentation, review test results, and create presentations much faster than before. Work that once required several junior employees can increasingly be completed by a small number of experienced people …

Read more

The Wiring Is Free. The Judgment Is Not.

Editorial figure in which many thin grey lines stop at an axis while one red line continues, beneath the words The wiring is free, the judgment is not

Connecting two systems was once the work. It is now the part a machine can do. What remains is the part that was always the point. Some time ago, I argued that the market does not pay for tool lists. The argument has aged in an unexpected direction. It is no longer only the list …

Read more

The Market Does Not Pay for Tool Lists

A person facing a shelf of collected software tools, beside a signpost pointing from collect more tools toward solve real problems

Why capable data and platform engineers stay invisible, underpaid, and afraid to apply There is a quiet fear in the current technology job market. Many people who are entirely capable of doing the work do not apply for it. They read a job description, see ten tools listed, and fix their attention on the two …

Read more

The Brain and the Muscle Popular

A blue brain on a circuit-board background beside an orange flexed arm, under the words The Brain and the Muscle

A practical guide to spec-driven development — built around one real website, so you can follow along and try it yourself. Whether a conversation persists after closing depends on the product and settings. Keep project decisions in versioned specifications so they remain reviewable independent of chat persistence. This is vibe coding, and there is nothing wrong …

Read more

The Two Engineers

Three people with money: one downcast behind shrinking stacks, one with folded arms behind even stacks, and a cleaner throwing banknotes into the air

This is a story. The two men in it do not exist. Everything that happens to them does. Year One They had studied together, and so once a year or so they met at the same café near the old university, ordered the same coffee, and compared the shape of their careers. In the first …

Read more