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 data from Power BI you can create a Token from the DevOps user settings page -> Personal Access Toke...
1. Create the Logic App Choose the "Consuption" type. 2. Design the Logic App Start with the common trigger "When a HTTP request is received" In the JSON body add all the parameters you need to use: { "properties": { "Blob": { ...
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 and Azure SQL Database. -- Create table and insert data for the examples CREATE TABLE [dbo].[XMLexampl...
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 documents up to 2 GB in size in a column of a SQL Server table. If your JSON is less then 8 KB is re...
Temporal table: to provide information about data in a table at any point in time.On SQL Server from the 2016 version. -- This statement creates a Temporal Table CREATE TABLE dbo.ExampleTemporal ( Id INT NOT NULL PRIMARY KEY CLUSTERED, Col1 I...
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 Logic App Create a Logic App (Consumption Type) Once the deployment is complete, go to the Logic Ap...
