Goal Progress for May 2022

I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. A few days late, and I missed April, but I’m...

Power BI: Calculating Network Days in M Custom Columns

Knowing the days between events is a fairly common reporting request because a lot of reporting is created to track SLA’s (service level agreement) and other KPI’s (key performance...

Daily Coping 3 Jun 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Speaking on Ethics in Modern Data at Improving Edge 2022

Christine and I are looking forward to speaking at the Improving Edge conference, co-presenting our session on Monday, June 6th. Our presentation on “Ethics in Modern Data” features topics relevant...

Branding Yourself for A Dream Job Slides

Slides from today’s talk at DataGrillen Branding Yourself for a Dream Job.

dbatools - Rich Datatypes

Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard. What...

SQL Homework – June 2022 – SQL Agent Jobs continued.

A few years ago I gave you homework to create a SQL Agent Job and play with it a little ... Continue reading

Daily Coping 2 Jun 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Daily Coping 1 Jun 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Populating PostgreSQL JSONB column using Azure Data Factory Data Flow

(2022-May-31) 
Personal notes of one of the recent ADF JSON pipeline development to remember how to use it next time.
Requirements:

Sourcing data comes from a SQL Server database
The destination is a...