322 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
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 …
A data warehouse migration replaces the technology, not the workload. Workload management, physical design, predictability and governance all reappear in cloud architectures under new names — and AI agents, which have no office hours, are about to change the economics again.
Teradata gives you more than one way to store the same data in less space, and they behave very differently once queries start reading it back. This guide brings together the compression material on this site: what multi-value and block level compression each do, how to find the columns worth compressing, and the trade-off you …
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 the operational details that only matter until the day they matter a great deal. Workload Flow Control and DBC.ResUsage The DBC.ResUsageSAWT table serves …
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 choices, and the MAPS feature — into one reference, starting with the mistakes that cause the most damage. Seven Sins That Destroy …
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. This guide gathers the query-rewriting material from this site into one place: full worked examples first, then the individual operators and patterns that repeatedly …
Almost every bad Teradata query plan traces back to one thing: the optimizer estimated the wrong number of rows. This guide collects everything on this site about statistics and cardinality estimation — what the optimizer does with the statistics you give it, how it copes when they are missing or stale, and how to diagnose …
Rethinking Cloud Pricing in the Age of AI Part 3: AI, the Future of Cloud Pricing, and Business Outcomes AI Changes the Economics of Compute One of the strongest economic arguments supporting consumption-based pricing has historically been the elimination of idle capacity. If infrastructure performs no useful work, paying for it appears economically inefficient. This …
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 …
Follow DWHPro in Google to see our articles more often in Search.
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.