Data Warehousing — WhereScape RED — SQL Server
Automated data warehouse builds using WhereScape RED — from initial design through to production-grade pipelines your team can operate and trust. SQL Server performance diagnosed at root cause, not patched.
Discuss Your Data Platform WhereScape REDEvery month, senior people in your firm spend time assembling numbers that should already exist. Data pulled from NavOne, Business Central, and other systems — reconciled manually in Excel — before anyone can review actual performance.
That is not a reporting problem. It is a data architecture problem. The fix is a warehouse that pulls from your source systems automatically, reconciles at load time, and delivers numbers your Finance Director can sign off on without a weekend of preparation.
Data from multiple systems consolidated manually. Same process, same risk of error, same cost in senior time — every single period.
Finance has one number. Operations has another. Compliance has a third. All defensible from their own sources. None of them reconciled.
ETL runs complete — but silently drop records, skip partitions, or time out on large tables. Nobody knows until a report is wrong.
FATCA, CRS, and CARF require clean, auditable pipelines. Manual assembly carries compliance risk and escalating cost as reporting obligations expand.
Slow queries, long-running jobs, I/O spikes at peak load. Patched repeatedly. Never traced to root cause. Still happening.
WhereScape RED automates the build of data warehouse objects — staging tables, dimension tables, fact tables, ETL procedures — from metadata. What takes weeks to hand-code takes days with RED.
But automation only delivers value when it is implemented correctly. Poorly configured RED environments produce automated bad code at scale. The difference is in the patterns, the Pebble templates, and the defensive ETL practices that separate a production-grade warehouse from one that works in development and fails under load.
Yitron has worked with WhereScape RED across the full lifecycle — greenfield builds, rescue projects, performance overhauls, and documentation of estates where the original author has left.
WhereScape RED lifecycle
Profile source systems. Identify data quality issues before they enter the warehouse.
Dimensional model designed for your reporting requirements — not generic best practice.
Automated object generation. Custom Pebble templates eliminate manual code adjustments.
Defensive patterns, error handling, job monitoring, selective data cloning for UAT.
Monitored pipelines. Runbooks. Operable by your team without the original author.
Standard RED templates generate functional code. Custom Pebble templates generate code that matches your standards — error handling, logging, and naming conventions baked in at generation time, not added manually afterwards.
ETL that fails silently is worse than ETL that doesn't run. Every pipeline built by Yitron includes explicit error trapping, row count validation, and alerting that surfaces problems before reports are produced.
Custom job reporting layer on top of RED's scheduler — duration trends, failure history, and data volume tracking. Spots degradation before it becomes an incident.
Custom utilities for selective data cloning — copy a representative subset of production data into UAT without exposing full client datasets. Test against realistic volumes without compliance risk.
When the original author has left and the documentation doesn't exist — Yitron audits, documents, and stabilises existing RED environments. Then improves them. Starting with whatever is causing the most pain.
Every engagement ends with documentation your team can actually use: data flow diagrams, object inventories, runbooks, and handover sessions. No dependency on Yitron to keep the lights on.
A production performance problem that the full internal team had investigated and closed as unresolvable. Traced to root cause and fixed in a single engagement.
Fact table redesign prototype — benchmark improvements an order of magnitude beyond the existing structure.
Data warehouse built for a Channel Islands organisation — still running without major rework.
Most SQL Server performance problems are diagnosed at the wrong level. A slow query gets a new index. The index helps for a week. The problem returns. The real cause — a configuration setting, an I/O bottleneck, a blocking chain, a statistics problem — is never found.
Yitron diagnoses SQL Server performance at every level: query execution plans, index design, statistics, tempdb contention, I/O subsystem behaviour, memory pressure, and server configuration. Including problems that are masked by successful job completion — where the job finishes but takes three times longer than it should.
Diagnose My Performance ProblemCapture actual runtime, I/O, CPU, and wait statistics under normal load before touching anything. Without a baseline, you cannot measure whether a fix worked.
SQL Server records exactly what it is waiting for. PAGEIOLATCH, CXPACKET, LCK_M, WRITELOG — each points to a different class of problem. This is where most investigations skip to solutions too early.
Query-level fixes address symptoms. Configuration-level fixes address causes. Max degree of parallelism, cost threshold for parallelism, memory settings, tempdb file count, instant file initialisation — these matter.
A fix that improves one query while degrading three others is not a fix. Every change is validated against the full workload baseline before it is recommended for production.
Findings delivered as a written report — root cause, evidence, fix applied, and what to monitor going forward. Not just a list of changes made.
The 50× ETL improvement is one example. The full case studies page covers the consolidation of 6,000+ tables across 20 databases, a data warehouse that has run for over a decade without major rework, and a KYC screening system that cut processing time by 20×.
All anonymised. All from production environments.
View All Case Studies →A 30-minute call is usually enough to understand whether there is a structural problem worth fixing, or a performance issue worth diagnosing. No charge. No obligation beyond the call itself.
Book a Discovery Callenquiry@yitron.co.uk +44 7829 800454 Jersey, Channel Islands