Troubleshooting and recovery
Investigate failed jobs, sequences, scheduler behaviour, load errors, stale data and reporting-impacting incidents.
Service detailsOperational WhereScape RED support
Practical WhereScape RED support for operational problems
I investigate failed, stalled or unreliable RED processing; trace metadata, dependency and data issues; compare RED definitions with deployed SQL; create reusable diagnostics and BAU procedures; and follow warehouse problems into SQL Server, SSAS, SSRS and Power BI.
Evidence-ledLogs, metadata, SQL and data lineage before assumptions.
DocumentedClear findings, repeatable procedures and handover-ready work.
Client-ownedYour systems, accounts, code and documentation remain yours.
ConfidentialClient and system details are not published without permission.
Core services
Practical support for live RED environments
Focused work for organisations that need an issue understood, a process stabilised, or an existing warehouse made easier to operate.
Repository and object analysis
Trace mappings, dependencies, generated code, deployed SQL objects and differences between environments.
Service detailsBAU improvement
Create concise procedures, diagnostics and operational checks that reduce repeated investigation and knowledge loss.
Service detailsWarehouse and reporting support
Work across SQL Server, SSAS, SSRS and Power BI when a RED-managed warehouse issue reaches downstream reporting.
Service detailsEvidence you can inspect
WhereScape RED 8.6 toolkit
The public toolkit contains repository documentation, scheduler analysis and reusable T-SQL validation or audit tools. It shows how I structure evidence, investigate RED metadata and turn repeatable checks into practical operational material.
View the toolkit on GitHubRestored broken SSAS multidimensional cube processing
Reconstructed an undocumented operational sequence by tracing dependencies and validating warehouse data.
Traced an unexpected value from source to report
Followed a discrepancy through RED, warehouse and reporting layers to establish the affected path and trustworthy outputs.
Investigated RED failures using logs, metadata and deployed SQL
Compared repository metadata, generated definitions and deployed SQL to narrow the underlying cause.
What you receive
A clear path from issue to usable outcome
A focused engagement leaves you with a clear statement of the issue and impact, an evidence-based finding or narrowed cause, recommended or implemented next steps, verification checks, and reusable SQL, procedure or handover material where applicable.
- 1
Define the operational question
Confirm the symptom, impact, scope and evidence already available.
- 2
Trace the system behaviour
Use logs, metadata, SQL, dependencies and data checks to find the cause.
- 3
Recommend or implement the change
Make the smallest sound intervention and record what changed.
- 4
Leave a repeatable result
Provide findings, verification steps and practical handover material.
Common questions
WhereScape RED consulting
Which WhereScape RED versions do you support?
My strongest recent focus is WhereScape RED 8.6.x. I also work with other RED 8.x environments and can assess older or newer versions before agreeing the scope.
Can you work remotely?
Yes. Remote consulting is available, with onsite work in Christchurch, New Zealand, and travel by arrangement.
What kinds of problems do you investigate?
Typical work includes failed jobs and sequences, scheduler issues, stale or missing data, metadata and dependency analysis, generated SQL review, environment comparison, and source-to-report tracing.
What do I receive from a focused investigation?
You receive a clear statement of the issue and impact, an evidence-based finding or narrowed cause, recommended or implemented next steps, verification checks, and reusable SQL, procedure or handover material where it is useful.
Independent consulting
Discuss your WhereScape RED environment
Send a brief outline of the issue, environment or outcome you need. Initial conversations are confidential and obligation-free.