Select Page

Triggers I Have Known and Loved

Triggers in Microsoft SQL Server Triggers are pieces of code which are automatically executed on the occurrence of an event in the database. They can be a good solution for a whole range of problems. However, many SQL Server users choose to avoid using triggers as...

What’s New in ODE version 4

A new version (version 4) of ODE is now available for download! ODE, Optimal Data Engine, is our open source product for building a Data Vault. Anyone can download it, install on their instance of SQL Server and develop a Data Vault of their own. New features include:...

Data Vault Certification

I thought that there were Kimball and Inmon methodologies, and no other way of building data warehouses. It was a bit of surprise to me that more than 1400 data warehouses around the world are built with the Data Vault methodology, and I’d never even heard about...