Only My Notes

Massimiliano Figini

Massimiliano Figini

15 followers

data engineer • T-SQL developer • r and python • Power BI and tableau machine learning enthusiast • data lover

Connect Azure DevOps data to Power BI

Oct 2, 20224 min read

The following are some notes about the connection from Power BI to Azure DevOps data. 1. Create the token from Azure DevOps To read your Azure DevOps...

Connect Azure DevOps data to Power BI

XML documents in SQL Server and Azure SQL Database

Feb 27, 20224 min read

1. XML documents in SQL Server and Azure SQL Database While JSON uses nvarchar type, XML has a dedicated column type of the same name in SQL Server...

XML documents in SQL Server and Azure SQL Database

JSON documents in SQL Server and Azure SQL Database

Jan 22, 20223 min read

These contents working in SQL Server 2016 and later and Azure SQL Database. 1. JSON documents in SQL Server Use nvarchar(max) data type to store JSON...

JSON documents in SQL Server and Azure SQL Database

Send an email with Azure Data Factory through Azure Logic App

Dec 3, 20212 min read

In this demo I assume you have already configured a pipeline in Azure Data Factory and you want only to send an email at the end of it. 1. Create a...

Send an email with Azure Data Factory through Azure Logic App

Intro to Spark SQL in Python

Nov 21, 20211 min read

Spark SQL is a component of Apache Spark that works with tabular data. # Load data from file df = spark.read.csv("trains.csv", header=True) # Create...

Intro to Spark SQL in Python

Basic Scala

Nov 7, 20212 min read

Variables Two kinds of variables: val (immutable, can't be reassigned once initialized) and var (mutable).// for comments. val two: Int = 2 var a:...

Basic Scala