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

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…

Tracking DML Operations in SQL tables

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…

PowerBI Calendar control

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…