Book Review – Snowflake Security

2 years ago

When I was working with Snowflake on a project, it seemed security (assigning roles to users, assigning permissions etc.) is…

Book Review – Azure Data Factory by Example

2 years ago

I just finished the book Azure Data Factory by Example: Practical Implementation for Data Engineers by Richard Swinbank. The book…

Parsing JSON in SQL Server with OPENJSON

2 years ago

Recently I had a piece of JSON of which I needed to extract data from to put into a table…

Book Review – Mastering Snowflake Solutions: Supporting Analytics and Data Sharing

2 years ago

Disclaimer: Apress gave me a free copy of the book to review. People that know me, also know I always…

Execute SQL Scripts on Snowflake using Azure Data Factory

2 years ago

Azure Data Factory has a new activity introduced this week (around the 10th of March 2022 for you future readers):…

Extracting Data from the AFAS REST API with Azure Data Factory

2 years ago

AFAS is a Dutch business software company, proving companies with ERP and HR software-as-a-service. You can extract data from the…

Dynamically Map JSON to SQL in Azure Data Factory

2 years ago

We're reading in some JSON files in Azure Data Factory (ADF), for example for a REST API. We're storing the…

T-SQL Linting in an Azure Devops Build Pipeline

2 years ago

Linting is a process where a code analyzer is run to find programmatic errors, bugs, "stylistic constructs" or anti-patterns. For…

DirectQuery to Power BI Datasets

2 years ago

A new feature has been added to the Power BI Desktop toolset and it's a very nice one. The official…

Speaking at Techorama 2022

2 years ago

I've received some good news: Techorama is back with an in-person conference! I'm selected as a speaker and I'll be…