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:
We hope these are of some use

The Frog Blog

I'm Alex Whittles.

I specialise in designing and implementing SQL Server business intelligence solutions, and this is my blog! Just a collection of thoughts, techniques and ramblings on SQL Server, Cubes, Data Warehouses, MDX, DAX and whatever else comes to mind.

Data Platform MVP

Frog Blog Out