Monthly Archives: February 2018

How Random is the RAND() function? SQL, Chance and the universe.

By | February 19, 2018

I use the Random function quite a bit to generate dummy data. So recently I was interested to find out actually how random it is. Randomness implies that all possible outcomes have an equal probability of happening and therefore cannot be predicted in advance. Since the outcome can’t be predicted it is pure chance and… Read More »

Tracking DML Operations in SQL tables

By | February 6, 2018

Recently I was asked if there was a better way than triggers to perform audits on a table. Essentially the client has a number of tables and each table needs a framework to audit DML operations occurring within them. Now the challenge is not really the audit part but how the data is consumed after… Read More »

PowerBI Calendar control

By | February 1, 2018

A client recently asked for a calendar layout within the report. This is one place where I feel PowerBI seems to lacking significantly since there are no native controls available and the ones that can be added aren’t really what people call a typical calendar. Here are some of the common examples you may find… Read More »