Pies, Lies and AIs

It's now easier to see the documentation directly in the notebook, rather than having to call "help" or go searching the Internet

Back in October 2020 I had the amazing opportunity to with with Richard on a small project where we wanted to speed up processing of CEF...

So input output tables are an economic cludge format which groups together a bunch of coefficients per country per year (these are...

A simple way to determine which country and IP address originated from at scale using Azure Databricks.

Over the past few months we've been hearing more and more about Azure Synapse. For those of you that heard my talk and saw my talk at the...

It's been a while but I'm back with lightning facts! So Row Level Security or RLS is a key feature of Microsoft data platform design...

A key initiative and a first step in introducing time series analytics into a data model is to generate moving averages. Indeed, the most...

A key capability of Kusto Query Language and Azure Data Explorer is the ability to make time series. This is the start of a 3-series set...

A key facet of using Azure Data Explorer is the ability to easily use command control. For those that have a good SQL background some of...

In the previous lightning fact we looked at using variables through the let command. In this tutorial we'll look at using functions which...

One of the great things about Kusto and KQL is that the key language bindings support charts as well as tabular output. Aside from this...

Learn how to use the KQL summarize keyword with this post

Over the past few months I've been working with Azure Data Explorer (ADX) and have been liasing with Microsoft product team (who...

Recently we looked at a project to predict train delays on the network. It's a complex problem and we addressed a small part of it. It...