Articles

Tags

#Databricks³ #Discussion¹ #Gatsby² #Github¹ #Machine Learning⁴ #Python¹¹ #SQL Server¹² #Site⁸ #Snippets²

2025

2024 Year in review

2024

My favourite Python resources

Adding source file information to tables in Databricks

2023 Year in review

2023

Understanding file paths in Databricks

Replacing multiple UNION ALLs with a Temporary Table

Connect SQLAlchemy and Databricks

2022 Year in review

2022

Recursive CTEs in SQL Server

6 lessons from a Machine Learning project

Creating custom scikit-learn Transformers

2021 Year in review

2021

Logistic Regression in Python with statsmodels

Multi-file LaTeX Documents with Pylatex

Four ways to forward-fill values in T-SQL (the last non NULL problem)

The Table Value Constructor (aka the VALUES keyword)

Clinical Natural Language Processing in Python

Identify consecutive values in SQL Server

Identify non-consecutive values in SQL Server

Placeholder Text (String Interpolation) in T-SQL

2020

2020 Year in review

Maximize user snippets in Azure Data Studio

Site update: November 2020

Use Python to quickly load lots of data to a Database

Azure Data Studio tips and tricks

Validate YAML in Python with Schema

Parse delimited values in SQL Server with STRING_SPLIT

Useful SQL Server functions: TRY_CAST & TRY_CONVERT

Move data to a Database with Python: Pandas

Move data to a Database with Python: SQLAlchemy

Move data to a Database with Python: Pure Python

How to use SQL Server's OPENJSON function

Automatically deploying a Gatsby site with Github Actions

Building my personal site in Gatsby