We want to find how often customers are behind in their payments or calculate their average debt when they are in debt. The question might be How many customer-months of debt am I experiencing (counting 1 for each month that … Continue reading →
This script is aimed at data warehouse relational databases which don’t have foreign key constraints. Using column names it matches key column values between fact and dimension tables to identify orphans.
Continue reading →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 →
In retrospect this was a simple task: the steps set out in the invaluable video Configuring HTTP for SSAS all work. However, in the middle of a long process trying to get it to work the first time it seems … Continue reading →
This is an attempt to create a script that will configure an instance of SSRS that has been left at the “installed but not configured” stage by the installer. The script is required to run during the spin-up of a … Continue reading →
Colour Choices for Graphs and Tables Heatmap Colouring for SSRS Sample colours for a range of 10 levels with mid-point roughly yellow. Code for BackgroundColor property of cell: = IIF(Fields!FieldName.Value >= .98, “#63be7b”, IIF(Fields!FieldName.Value >= .95, “#86c87d”, IIF(Fields!FieldName.Value >= .92, … Continue reading →
Phenomenally useful. Not supported at 64bit. Location Normally: C:\Windows\SysWOW64. Versions I’m using version 6.01.9846 of 9/12/2015 Registering C:\Windows\system32>Regsvr32 c:\windows\syswow64\mscomctl.ocx Unregister C:\Windows\system32>Regsvr32 /u c:\windows\syswow64\mscomctl.ocx Troubleshooting First check References. If it shows as MISSING, untick it and close the References dialog box. Compile the code … Continue reading →
Sample backup compression figures – SQL Server 2012. The relative sizes and timings are interesting. This was a database with data that compressed well. Uncompressed backup file: 73.4GB. 18 minutes to create Compressed backup: 17.5GB. About 20 minutes to create … Continue reading →