Why I love temporal tables
Nov 7 · 3 min read
Back in 2003, I was in production support and client implementation for an eLearning application. One day, we got an email from a client , requesting for a new feature. The feature they requested for their version of the deployment is to have a process that would log every attempt by the user , in logging in and also the courses taken, their scores, etc. They wanted a report that would lost all these when the admin requested. It was the university’s attempt to track cheating in completing online courses.
We had a database designed in MSSQL. The application had been designed to…

