0845 643 64 63


Here you’ll find source code, applications, and/or utilities available for download, that are discussed in the blog posts.
Neither Purple Frog Systems Ltd nor the author will accept any liability for any errors, problems or loss of business arising as a result of downloading or using any contents of this blog. Before downloading or using any of these files, please read the disclaimer in full here.

MSc Dissertation – Performance analysis of loading SCDs in SSIS

Following the successful completion of my MSc in Business Intelligence, here is a link to my dissertation which may be of interest to some.
Read more about the project in the blog post here.

Automated SSAS Cube Documentation in SSRS

The following zip file contains the SQL script and SSRS .rdl files for use with SQL Server 2008 R2 in conjunction with the OLAP cube documentation blog post here.

Loan Amortisation in SQL Server (PMT, FV, IPMT, PPMT)

There are a number of functions available to Excel users that calculate loan repayments, interest, future loan value etc. Unfortunately these are not available in SQL Server.
To overcome this, the Purple Frog team have written a .Net CLR library which add four loan amortisation functions to SQL Server, which can be called from within a query as scalar functions.
For more details of the functions, please look at the loan amortisation blog post here.
You can download the files below, written and tested against SQL 2008 R2:
[Edit 21 June 2022]
A big thank you to Scott Klein [@SQLScott] for taking the time to update this code from SQL 2008 to SQL 2019 and VS2019. Scott’s kindly provided the C# source and compiled binary, which you can download below:
We hope these are of some use

Power BI Sentinel
The Frog Blog

Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.

This is a collection of thoughts, ramblings and ideas that we think would be useful to share.


Alex Whittles
Jeet Kainth
Jon Fletcher
Nick Edwards
Joe Billingham
Lewis Prince
Reiss McSporran
Microsoft Gold Partner

Data Platform MVP

Power BI Sentinel
Frog Blog Out