Simplified Way to Install Sqlpackage on macOS using dotnet

Simplified Way to Install Sqlpackage on macOS using dotnet

  • 2024-11-15
  • 1 minute to read

It has been a right pain installing Sqlpackage on macOS but it is really easy to do using the dotnet sdk and homebrew

Read More
Retrieving Fabric Tenant Settings interactively using Powershell

Retrieving Fabric Tenant Settings interactively using Powershell

  • 2024-08-02
  • 4 minutes to read

How to use standard Azure powershell cmdlets to retrieve the Fabric Tenant settings for evaluation.

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
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
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

It is really easy to run the SQL Server database engine natively on macOS silicon using Docker for local development.

Read More
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 Microsoft Fabric development environment, you can use a Microsoft 365 Developer Account to spin up your own.

Read More
Running SQL Server natively on macOS using Azure SQL Edge

Running SQL Server natively on macOS using Azure SQL Edge

  • 2023-06-30
  • 2 minutes to read

How to run SQL Server database engine on macOS with ARM architecture using Azure SQL Edge and Docker.

Read More
Setting Up an RSS Feed for the Microsoft Fabric Blog

Setting Up an RSS Feed for the Microsoft Fabric Blog

  • 2023-06-16
  • 3 minutes to read

The new Microsoft Fabric blog annoyingly does not have an RSS feed, so I wanted to find out if I could roll my own.

Read More
How to install and sign SqlPackage on macOS

How to install and sign SqlPackage on macOS

  • 2023-06-01
  • 5 minutes to read

How to install sqlpackage on macOS and resolve the security constraints that occur because Microsoft do not sign their packages properly.

Read More
Azure Data Studio NU1101 error Unable to Find Package

Azure Data Studio NU1101 error Unable to Find Package

  • 2021-06-03
  • 1 minute to read

Error NU1101 raised whilst getting database projects to build using Azure Data Studio and steps to resolve it.

Read More
Redgate SQL Provision, SQL Clone, Data Masker Part2

Redgate SQL Provision, SQL Clone, Data Masker Part2

  • 2019-10-02
  • 8 minutes to read

I got some time with the Redgate folks at SQLBits and had a demo of SQL Provision, I was really impressed, this is part 2 of my review.

Read More
Redgate SQL Provision, SQL Clone, Data Masker Part1

Redgate SQL Provision, SQL Clone, Data Masker Part1

  • 2019-10-01
  • 10 minutes to read

I got some time with the Redgate folks at SQLBits and had a demo of SQL Provision, I was really impressed, this is part 1 of my review.

Read More