Data24 min read
Star schema: how to design one with Kimball's four steps and SQL
A star schema joins one fact table at a declared grain to flat dimension tables. Design steps, tested SQL, SCD Type 2, snowflake vs one big table, mistakes.
Updated
Information technology blog, page 2
Guides and explainers on web development, custom software, hosting, SEO, IT support, security, integrations, cloud, data and AI, each checked against the sources it lists.
Web development19 min read
What is a headless CMS? How it works and when to use one
A headless CMS stores content behind an API and renders no pages, leaving presentation to a separate front end. How it works, the options, the trade-offs.
Updated
Cloud17 min read
VMware alternatives: the credible options, the trade-offs and a safe migration plan
Why VMware customers are rethinking their renewal, how the main alternatives compare on licensing, skills and storage, and a staged plan for moving off vSphere.
Updated
Integrations20 min read
System integration: approaches, patterns and how to choose
System integration connects separate software so data flows between systems. Compare point-to-point, ESB, iPaaS and event-driven approaches, and how to choose.
Updated
Data15 min read
Semantic layer: what it is, how it works and how to choose in 2026
A semantic layer defines each business metric once and compiles it to SQL for every tool. See a tested MetricFlow example, the 2026 options and AI limits.
Updated
Web development25 min read
Website migration SEO: how to move your site without losing traffic
Move a website to a new host, CMS or domain without losing search traffic: benchmark, map every URL, test redirects, run the cutover and monitor the move.
Updated
Cloud15 min read
Cloud migration strategy: choose a path per application, then plan the waves
A cloud migration strategy gives each application one of seven treatments (the 7 Rs), then orders them into waves. How to choose, plan and avoid stalls.
Updated
Data22 min read
Medallion architecture: bronze, silver and gold layers, and when to skip them
Medallion architecture sorts lakehouse tables into bronze, silver and gold layers. What each holds, the SQL between them, the checks, and when to skip it.
Updated
Integrations15 min read
What is a webhook? How it works, webhook vs API and how to secure it
A webhook is an HTTP request a service sends to your URL when something happens. How webhooks work, webhook vs API polling, and how to receive them safely.
Updated
AI & automation14 min read
AI limitations in understanding: where models fall short and why it matters
AI models predict plausible text without a reliable model of the world. See where their understanding falls short and how to use them safely in critical work.
Updated
Start with a conversation.
Tell us what you run and what is getting in the way. You get a reply within 24 hours.
- Hours
- Mon–Fri, 9:00–17:00 ET
Closed on statutory holidays - Office
- 110 Place d'Orléans Dr
Ottawa, ON K1C 2L9