data engineer • T-SQL developer • r and python • Power BI and tableau
machine learning enthusiast • data lover
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...
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...
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...
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...
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)
Two kinds of variables: val (immutable, can't be reassigned once initialized) and var (mutable).// for comments.
val two: Int = 2