sql-server
-
Time Travel with Data – Use cases and techniques
Data Historization is a pretty frequent need in data analytics that should be managed at some point in most of the companies. Let’s just think about the following use case. A company is having it’s sales order backlog in it’s ERP system. Management is interested in the backlog, but not only how much it is…
-
Override When Created/Modified trigger on SQL Server
I’ve recently fallen into trouble when I wanted to setup a new workflow in Logic Apps. The scenario was pretty simple. Do something when a new Item is created in an on-prem SQL Server data table. This scenario was one of the basic methods learning materials was covering so I’ve started the creation of the…
Adam's Perspective on Data 