Analytics

The inescapable problem of Latency within Data-based systems 2

It’s long troubled me people touting Real-Time Business Intelligence when its physically impossible to achieve true real-time; I’ve jotted down some thoughts in an attempt to bring order and better understanding to the reality of “Real-Time” – hopefully the post will help you in dealing with vendors, giving you some insight into what questions to(…)

Creating a Uniform, Normal and Benford Law’s Distribution from Random Numbers in SQL Server 0

Creating test data we often utilise random numbers, within SQL Server we can use the RAND() function or NEWID(). This quick post shows you how to create three different distributions based on the set {1..9} – Uniform (evenly distributed), Normal (distributed about the mean) and Benford – distribution follows Benfords Law of Log10( 1 +(…)