Wind farms offer clean, renewable electricity. Operating and maintaining wind turbines profitably is another matter. This article provides a brief…
Controlled Access using Raspberry Pi
The COVID-19 situation put a strain on all of us in many ways. Fun distractions were one means of weathering…
Using PowerShell for ETL
The Microsoft world offers BCP, .NET, and SSIS for moving data. BCP is fast and efficient, but is limited. Bespoke…
DevOx: SOX-compliant DevOps
The DevOps movement is a cultural shift toward collaboration and ownership. Collaboration among developers and users. Ownership of projects and…
The Value of an Enterprise Architect
Enterprise Architecture can be a bit nebulous. Without a clear message on value proposition and deliverable expectations, the Enterprise Architect…
Power BI Archtecture
Microsoft’s PowerBI product is a robust data visualization tool for end users. It is easy to get started with the…
Start with a Minimum Viable Solution
Borrowing from Eric Reis’s book Lean Startup, start your data warehousing project simply. Often, we envision a comprehensive, elaborate solution,…
Alternative Data Warehouse Key Design
I was once on a project where the users waited on the data warehouse load to complete before going home.…
Estimating a Data Project
Software estimation has had a lot of attention. Yet, it is still a challenge. Much has been written about metrics…
The Solution Architect
I’ve been a software architect for over 20 years, worked on a wide range of projects. I write this not…