Blog

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