Blog

I am a Redgate Community Ambassador for 2024

I am a Redgate Community Ambassador for 2024

  • 2024-06-19
  • 3 minutes to read

I am pleased to announce that I have been welcomed into the Redgate Community Ambassador program for 2024

Read More
Install Apache Spark on macOS using Homebrew

Install Apache Spark on macOS using Homebrew

  • 2024-06-05
  • 3 minutes to read

It is really easy to install Apache Spark on macOS and load in data in just a few minutes using Homebrew.

Read More
Floating windows in vscode for editor and terminal

Floating windows in vscode for editor and terminal

  • 2024-05-23
  • 2 minutes to read

I have discovered a new feature in vscode that allows you to float windows, you float editor and terminal windows.

Read More
Add PR Checklists with Pull Request Templates

Add PR Checklists with Pull Request Templates

  • 2024-05-22
  • 5 minutes to read

One useful tool to standardise your peer review process is to create a pull request template. This is really easy to achieve in both Azure DevOps and Github.

Read More
Hugo live reload constantly keeps reloading

Hugo live reload constantly keeps reloading

  • 2024-05-18
  • 3 minutes to read

I have run into an issue from time to time where Hugo's live reload feature keeps reloading the page. This is how I fixed it.

Read More
Creating Mermaid diagrams in markdown using vscode

Creating Mermaid diagrams in markdown using vscode

  • 2024-05-17
  • 7 minutes to read

My blog theme supports mermaid. Mermaid is a visual diagram syntax, so I wanted to test it out in vscode.

Read More
T-SQL Tuesday #174 My favourite job interview question

T-SQL Tuesday #174 My favourite job interview question

  • 2024-05-14
  • 4 minutes to read

This is my 12th contribution to TSQL Tuesday, the data community blog party. Have a read, and why not join in next time!

Read More
Using Brewfile to Share Homebrew Configs across machines

Using Brewfile to Share Homebrew Configs across machines

  • 2024-05-14
  • 4 minutes to read

I have found Brewfile to be a useful tool for producing a dotfile, which allows me to share my Homebrew configuration between machines.

Read More
Connecting to a Postgres database with Azure Data Studio

Connecting to a Postgres database with Azure Data Studio

  • 2024-05-09
  • 2 minutes to read

You can connect to a Postgres database using Azure Data Studio with the help of the Postgres extension.

Read More
Creating a Postgres docker container and connecting dbt

Creating a Postgres docker container and connecting dbt

  • 2024-05-09
  • 5 minutes to read

This post talks through how to create a Postgres database in a Docker container and connect dbt to it for local development.

Read More
Steps required to set up the dbt SQL Server Adapter

Steps required to set up the dbt SQL Server Adapter

  • 2024-05-09
  • 6 minutes to read

This post explains how to get started with dbt and the SQL Server adapter. Also covers resolving some of the issues encountered on macOS.

Read More
Running SQL Server natively on macOS using SQLCMD CLI

Running SQL Server natively on macOS using SQLCMD CLI

  • 2024-05-08
  • 7 minutes to read

It is really easy to run SQL Server on macOS using the new SQLCMD CLI tool. This post explains how to set it up.

Read More