Azure First Thoughts: Drinking From the Blue Fountain

Azure First Thoughts: Drinking From the Blue Fountain

Earthquakes, Cyclones, Work – How to Stay Resilient Through Disasters

Earthquakes, Cyclones, Work – How to Stay Resilient Through Disasters

Gartner Magic Quadrant for Business Intelligence 2018 – Augmented Capability will be the New Black

Gartner Magic Quadrant for Business Intelligence 2018 – Augmented Capability will be the New Black

Bias – a capability challenge

Bias – a capability challenge

It seems bias in algorithms is a very hot topic at the moment. In a surprisingly honest move Twitter admits their algorithms aren't always impartial: Twitter chief executive Jack Dorsey has told US lawmakers the company's algorithms have not always been...

Data Vault on Graph database

Data Vault on Graph database

Recently I have bumped into this blog by David Nicholson. I have heard an opinion that the Graph database and the Data Vault look similar before. This idea comes to mind when you see diagrams next to each other. (You can draw them to be identical, but it doesn't prove...

Web Accessibility

Web Accessibility

Introduction Web accessibility may be a phrase that evokes a number of reactions in different people. As a developer you may feel anything from relief to indifference to contempt. The fact is accessibility is important, easier than you might think, and can still look...

Giving up for a cause

Giving up for a cause

The month of July for many people was a "dry" month - giving up alcohol for a great cause. Here at OptimalBI we expanded that scope to a month of giving up something we are addicted to. Many of the team, like me, chose alcohol (I actually had a damp July with loads of...

SQL Server Table Partitioning: Divide and Rule

SQL Server Table Partitioning: Divide and Rule

For the first time I am on the project that has big enough Data Warehouse tables that could be partitioned. While many data warehouses are big, in my previous projects a single table has rarely exceeded a few million rows, which means it is too early to think about...

Don't start your project with code

Don't start your project with code

Ever needed to make sense of 13 million files?  Shaun did.  Where to start?  Start by thinking about the business, rather than the data.  Think about Who in the business Does What? My brief I was given complete discretion on how to turn millions of files into useful...