Home
Articles
About
Articles
Tags
#
Databricks
3
#
Discussion
1
#
Gatsby
2
#
Github
1
#
Machine Learning
4
#
Python
11
#
SQL Server
12
#
Site
7
#
Snippets
2
2024
30 Nov 2024
My favourite Python resources
1 Mar 2024
Adding source file information to tables in Databricks
19 Jan 2024
2023 Year in review
2023
6 Oct 2023
Understanding file paths in Databricks
28 May 2023
Replacing multiple UNION ALLs with a Temporary Table
12 Mar 2023
Connect SQLAlchemy and Databricks
16 Feb 2023
2022 Year in review
2022
9 Aug 2022
Recursive CTEs in SQL Server
28 May 2022
6 lessons from a Machine Learning project
17 Jan 2022
Creating custom scikit-learn Transformers
10 Jan 2022
2021 Year in review
2021
14 Nov 2021
Logistic Regression in Python with statsmodels
16 Sep 2021
Multi-file LaTeX Documents with Pylatex
1 Sep 2021
Four ways to forward-fill values in T-SQL (the last non NULL problem)
19 Jun 2021
The Table Value Constructor (aka the VALUES keyword)
30 Apr 2021
Clinical Natural Language Processing in Python
17 Mar 2021
Identify consecutive values in SQL Server
24 Feb 2021
Identify non-consecutive values in SQL Server
23 Jan 2021
Placeholder Text (String Interpolation) in T-SQL
2020
31 Dec 2020
2020 Year in review
20 Dec 2020
Maximize user snippets in Azure Data Studio
30 Nov 2020
Site update: November 2020
9 Nov 2020
Use Python to quickly load lots of data to a Database
25 Oct 2020
Azure Data Studio tips and tricks
8 Oct 2020
Validate YAML in Python with Schema
24 Sep 2020
Parse delimited values in SQL Server with STRING_SPLIT
9 Sep 2020
Useful SQL Server functions: TRY_CAST & TRY_CONVERT
1 Sep 2020
Move data to a Database with Python: Pandas
26 Aug 2020
Move data to a Database with Python: SQLAlchemy
10 Aug 2020
Move data to a Database with Python: Pure Python
5 Aug 2020
How to use SQL Server's OPENJSON function
17 Jul 2020
Automatically deploying a Gatsby site with Github Actions
1 Jul 2020
Building my personal site in Gatsby