Blog

2026-05-30 1 minute

Long-form posts from Justin Bird on data engineering, analytics consulting, coding, Hugo, learning, community, and building a thoughtful independent web.

Blog

How to search for lost files or changes using Git Log

How to search for lost files or changes using Git Log

  • 2024-04-27
  • 5 minutes to read

How to find a lost file or set of changes in a Git repository using git log and git grep, including filtering by commit message, author, date range, or file path.

Error No Such Shell Function 'Zle Line Init' in Zsh

Error No Such Shell Function 'Zle Line Init' in Zsh

  • 2024-04-25
  • 3 minutes to read

How to troubleshoot the zsh error message "no such shell function 'zle line init'" which commonly appears after installing or updating Oh My Posh on macOS.

Microsoft Certified: Azure Solutions Architect Expert

Microsoft Certified: Azure Solutions Architect Expert

  • 2024-04-03
  • 1 minute to read

Information on passing the AZ-305 exam and earning the Azure Solutions Architect Expert certification, covering cloud solution design and Azure infrastructure patterns.

Addressing line feed issues between macOS and Windows in Git

Addressing line feed issues between macOS and Windows in Git

  • 2024-03-29
  • 4 minutes to read

How to fix line ending issues in Git projects where developers contribute from both macOS and Windows machines, using .gitattributes and core.autocrlf configuration.

My experience helping at SQLBits 2024 in Farnborough

My experience helping at SQLBits 2024 in Farnborough

  • 2024-03-28
  • 11 minutes to read

An account of my fourth time helping at SQLBits 2024 in Farnborough, covering the sessions I attended and the community spirit that makes this conference so enjoyable.

Microsoft Certified: Fabric Analytics Engineer Associate

Microsoft Certified: Fabric Analytics Engineer Associate

  • 2024-03-13
  • 1 minute to read

Information on passing the DP-600 exam and earning the Microsoft Certified Fabric Analytics Engineer Associate certification, covering Microsoft Fabric analytics.

How to run a powershell script as part of a Git hook

How to run a powershell script as part of a Git hook

  • 2024-03-09
  • 3 minutes to read

Ever wanted to run a powershell script as part of a Git Hook? Well you can! This post explains how you do it.

Why does my markdown header not appear has a header

Why does my markdown header not appear has a header

  • 2024-03-03
  • 3 minutes to read

Markdown headers sometimes do not render correctly. This post explains the most common cause and the simple fix to get headings working properly again in your editor.

Running SQL Server on macOS Silicon natively using Docker

Running SQL Server on macOS Silicon natively using Docker

  • 2024-03-01
  • 3 minutes to read

Running the SQL Server database engine natively on macOS Silicon using Docker is straightforward and enables local SQL development without needing a Windows machine.

Microsoft Certified Trainer (MCT) 2024 Credentials

Microsoft Certified Trainer (MCT) 2024 Credentials

  • 2024-03-01
  • 3 minutes to read

I have recently been awarded the Microsoft Certified Trainer accreditation for 2024 permitting me to provide training towards Microsoft certifications.

How to Update the Remote URL of a Git Repository in Git

How to Update the Remote URL of a Git Repository in Git

  • 2024-02-24
  • 4 minutes to read

How to update the remote URL of a Git repository using the git remote set-url command, useful when a repository has been moved, renamed, or migrated to a different host.

Connect to and authenticate with Azure from Github Actions

Connect to and authenticate with Azure from Github Actions

  • 2024-02-19
  • 8 minutes to read

How to configure authentication between GitHub Actions or Azure DevOps and Azure, enabling pipelines to run securely without storing sensitive credentials in the repository.

T-SQL Tuesday #171 The most recent issue you closed

T-SQL Tuesday #171 The most recent issue you closed

  • 2024-02-13
  • 4 minutes to read

My 11th T-SQL Tuesday contribution, hosted by Brent Ozar. The topic this month was the most recent technical issue I closed at work, and the lessons learnt from it.

Set up Microsoft Fabric with Microsoft 365 Developer Account

Set up Microsoft Fabric with Microsoft 365 Developer Account

  • 2024-02-09
  • 2 minutes to read

If you do not have access to a Microsoft Fabric development environment, a free Microsoft 365 Developer Account lets you provision your own trial tenant to get started.

Running a Code Club dedicated to marginalised young people

Running a Code Club dedicated to marginalised young people

  • 2024-01-30
  • 5 minutes to read

I help run a Code Club for marginalised young people in Cardiff. It is the most rewarding thing I do, and this post shares why I got involved and what we get up to.

What happens when you take a break in a proctored exam

What happens when you take a break in a proctored exam

  • 2024-01-26
  • 2 minutes to read

What to expect when taking a break in a proctored Microsoft certification exam, including how the process works and what happens to your exam session whilst you are away.

Microsoft Certified: Azure Database Administrator Associate

Microsoft Certified: Azure Database Administrator Associate

  • 2024-01-26
  • 2 minutes to read

Information on passing the DP-300 exam and earning the Microsoft Certified Azure Database Administrator Associate certification, covering Azure SQL database management.

Microsoft Certified: Azure Enterprise Data Analyst Associate

Microsoft Certified: Azure Enterprise Data Analyst Associate

  • 2024-01-24
  • 2 minutes to read

Information on passing the DP-500 exam and earning the Microsoft Certified Azure Enterprise Data Analyst Associate certification, covering enterprise analytics.

My activities tracker for community contributions in 2023

My activities tracker for community contributions in 2023

  • 2023-12-31
  • 2 minutes to read

A list of events and activities I have contributed to STEM and the community during 2023, including conferences, blogging, speaking, and data community activities.

Stem Ambassador Award 2023 for 30 hours of volunteering

Stem Ambassador Award 2023 for 30 hours of volunteering

  • 2023-12-31
  • 2 minutes to read

I have received a STEM Ambassador award for contributing 30 hours of volunteering to the STEM Ambassador programme, recognising my efforts supporting young people in STEM.