Blog

A lesser known feature of Azure Synapse is the "Shared Metadata Model". Synapse has the capability to automatically synchronize tables created via Synapse Spark with objects you can query via the usual SQL Serverless endpoint, without any additional configuration. This article brings attention to this capability, highlighting the benefits and tradeoffs vs rolling your own SQL Serverless VIEWs.

This blog post explores how the CALCULATE function in DAX performs context transition.

The stack and heap are central components of memory management in C# programs. This post aims to introduce the topic, with a number of worked examples.

The world runs on Excel, and misuse has caused some infamous data loss incidents. This post explores what happens when identifiers fall foul of Excel's numeric precision rules.

This blog post explores one of the most powerful functions in DAX - CALCULATE.

This blog post explores two common functions in DAX - RELATED and RELATEDTABLE.

We often come across spreadsheets and CSV files that contain features which are a list of tags or categories. This blog article walks through a simple way of extracting insights from this data using a combination of Pandas for data wrangling and Power BI for analytics and visualisation.

We're constantly using computer networks and the internet, especially as developers. The Web is the most important application on the Internet; this is the second of two posts aiming to explain the basics of the Web.

In this post, we will be showing how to implement dependency injection in an ASP.NET Core application.

Star Schemas are designed to be able to filter the fact table by any dimension. But in some cases, we might also want to filter a dimension table by another dimension. Here's a clean way of doing so.

It's possible to get into a tricky situation when combining asynchronous methods that return Task objects with multicast delegates in C#. In this post Liam explains how that situation arises.

Field Parameters allow users to dynamically change the measure being analysed within a report. This blog post will explore how to use the new Field Parameters feature to dynamically switch between measures in a visua.

Debugging allows us to troubleshoot problems in our applications by stepping through our code line by line, and stepping into methods when necessary. But there might be instances where the process is not so straightforward. Debugging NuGet packages is one of them.