My Notes for earning the Oracle Database SQL Certified Associate (for SQL Server Developers)Disclaimer: This post is based on my personal notes and reflections. I used AI (ChatGPT by OpenAI) only to improve grammar, structure, and readability. Introduction The Oracle exam 1Z0-071 is what you need to earn the Oracle Database SQL Certified As...Sep 7, 2025·37 min read
Connect Azure DevOps data to Power BIThe 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...Oct 2, 2022·4 min read
Copy data from a Blob Storage to a Sharepoint folder with Azure Data Factory through Azure Logic App1. 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": { ...Jun 17, 2022·2 min read
XML documents in SQL Server and Azure SQL Database1. 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...Feb 27, 2022·4 min read
JSON documents in SQL Server and Azure SQL DatabaseThese 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...Jan 22, 2022·3 min read
Temporal Tables in SQL Server and Azure SQL DatabaseTemporal 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...Jan 6, 2022·3 min read
Send an email with Azure Data Factory through Azure Logic AppIn 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...Dec 3, 2021·2 min read
