Posts
From Next.js and GitHub Pages to Azure Static Web App
I consolidated my two blogs into one with Jekyll in Azure using Azure Static Web Apps.
Copy a table from on-premise server to Azure Data Factory
How to copy a table from an on-premise server to Azure Data Factory using a self-hosted integration runtime.
Azure Data Factory Pricing
These are estimates to calculate pricing for Azure Data Factory.
Azure Data Factory Self-Hosted Integration Runtime
Connect an on-prem SQL Server to Azure Data Factory using a self-hosted integration runtime (IR).
Use Chocolatey in Windows Powershell to Install Programs
Chocolatey is the Windows version of Linux’s
apt
ordnf
.Create a SQL Server Windows VM
How to create a Virtual Machine in Azure with Windows SQL Server.
Create an Azure Windows Server Datacenter VM
Create a Windows Server 2022 Datacenter Azure Edition virtual machine.
**Unsolved**: In Azure Copying files between VMs
Unsolved: In Azure, copying files between VMs doesn’t work.
Azure Data Factory Scheduling
Scheduling jobs in Azure Data Factory.
Power BI Dashboard of Underrepresented Companies
Every US state has a DOT website about underrepresented and minority-owned companies also known as
DBE
orDisadvantaged Business Enteprise
. This is the dashboard to visualize these companies by region.Azure Data Factory Parameters
How to improve productivity developing pipelines in Azure Data Factory using parameters.
Copy Files to an Azure Windows VM
I am having some issues with
scp
to copy files from Linux to an Azure Windows 10 VM. Here is a procedure to create a shared folder between Azure Storage and a Windows VM.Power BI with Azure and Data Analytics Trends
Using Power BI with Azure to find trends in data analytics from Google Ads and StackOverflow.
Power BI Design Techniques
Power BI design settings for metrics, bar charts, maps, and other visuals.
**Unsolved**: Power BI freezes on Windows Azure VM
Unsolved: Power BI freezes in a Windows Azure VM when connecting RDP from Linux using Remmina.
Power BI Publish to a Website
How to publish a Power BI report to a website using Power BI Service.
BigQuery SQL Subtract Two Aggregations By Date
In BigQuery SQL how to subtract values of two aggregations by date.
Python os.system vs subprocess.call
How to use Python subprocess to run OS commands.
PowerBI PowerQuery Create a Dimension Date Table in M
Create a dimension Date table in PowerBI PowerQuery using M.
Power BI Create a Hierarchy with Lookupvalue
How to create a hierarchy in Power BI with Lookupvalue.