In the first post in this series I showed how it was possible to create a DirectQuery dataset connected to Log Analytics so you could analyse Power BI query and refresh activity in near real-time. In ...

Here's a diagram of the high level pipeline design for this pattern: We initially build our daily metrics table that is at the grain of whatever our entity is. This data is derived from whatever event ...

Abstract: Nested queries are commonly used to express complex use-cases by connecting the output of a subquery as an input to the outer query block. However, their execution is highly time-consuming.

This repository contains the BNF (Backus-Naur Form) grammars for three versions of standard SQL — SQL-92, SQL-99 and SQL-2003. It may not be the most recent release, but the technical content is ...