Azure data factory pipelines consist of activities that are controlled for execution precedence and flow by constructs similar to SSIS precedence constraints. However, unlike SSIS, ADF has no error event that can be given pipeline-wide scope which is … Continue reading →
RAID write times are improved by writing to a cache. This is a quick operation, the calling program can get on with its business, and the RAID controller can solidify the cached changes to disk(s) in its own time. The … Continue reading →
A simple framework for implementing a time-framed record deletion policy: deleting records that are older than a certain threshold. Consists of a logging table and a stored procedure which deletes the records. The procedure deletes rows in batches and provides … Continue reading →