Some notes on the release of the strings package and how it works in relation to EXCEL and to some existing built-in SQL functions.

Some notes on the release of the statistics package and how it works in relation to EXCEL and in relation to existing SQL Server functions with the same or similar names.

One of the big problems that you may have in moving from the spreadsheet paradigm to the database paradigm is in ‘normalizing’ your data. In this article, I will attempt to explain what that means.

Build your own mortgage calculator using XLeratorDB/financial.

An introduction to the latest function package for SQL Server - Unit Conversions.

A graphical representation of the XNPV function mentioned in last week's blog. This illustrates the polynomial nature of the XNPV function illustrating why there can be more than one correct answer for XIRR.

Insight into the XIRR and XNPV functions as implemented in Microsoft Excel and in WestClinTech's XLeratorDB/financial.

What are the chances that any two people in the room have the same birthday?

Duration is one of those ubiquitous financial terms that is well defined but not well understood.

When you win the lottery, should you take the lump sum distribution or the annuity?

When we say that a bond has an odd last coupon, what do we mean?

We found something interesting while testing our ODDLYIELD function

Differences between the COUPDAYS calculation when the basis is 0 and DAYS360 function and why February is really the cruelest month.

A brief journey into the world of significance and precision in T-SQL.

The mechanics of bond pricing.