Posts

• Apr 21, 2023

  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.

• Apr 2, 2023

  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.

• Apr 1, 2023

  Azure Data Factory Pricing

  These are estimates to calculate pricing for Azure Data Factory.

• Mar 27, 2023

  Azure Data Factory Self-Hosted Integration Runtime

  Connect an on-prem SQL Server to Azure Data Factory using a self-hosted integration runtime (IR).

• Mar 26, 2023

  Use Chocolatey in Windows Powershell to Install Programs

  Chocolatey is the Windows version of Linux’s apt or dnf.

• Mar 25, 2023

  Create a SQL Server Windows VM

  How to create a Virtual Machine in Azure with Windows SQL Server.

• Mar 24, 2023

  Create an Azure Windows Server Datacenter VM

  Create a Windows Server 2022 Datacenter Azure Edition virtual machine.

• Mar 23, 2023

  **Unsolved**: In Azure Copying files between VMs

  Unsolved: In Azure, copying files between VMs doesn’t work.

• Mar 16, 2023

  Azure Data Factory Scheduling

  Scheduling jobs in Azure Data Factory.

• Mar 15, 2023

  Power BI Dashboard of Underrepresented Companies

  Every US state has a DOT website about underrepresented and minority-owned companies also known as DBE or Disadvantaged Business Enteprise. This is the dashboard to visualize these companies by region.

• Mar 14, 2023

  Azure Data Factory Parameters

  How to improve productivity developing pipelines in Azure Data Factory using parameters.

• Mar 13, 2023

  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.

• Mar 12, 2023

  Power BI with Azure and Data Analytics Trends

  Using Power BI with Azure to find trends in data analytics from Google Ads and StackOverflow.

• Mar 11, 2023

  Power BI Design Techniques

  Power BI design settings for metrics, bar charts, maps, and other visuals.

• Mar 10, 2023

  **Unsolved**: Power BI freezes on Windows Azure VM

  Unsolved: Power BI freezes in a Windows Azure VM when connecting RDP from Linux using Remmina.

• Mar 9, 2023

  Power BI Publish to a Website

  How to publish a Power BI report to a website using Power BI Service.

• Mar 8, 2023

  BigQuery SQL Subtract Two Aggregations By Date

  In BigQuery SQL how to subtract values of two aggregations by date.

• Mar 7, 2023

  Python os.system vs subprocess.call

  How to use Python subprocess to run OS commands.

• Mar 6, 2023

  PowerBI PowerQuery Create a Dimension Date Table in M

  Create a dimension Date table in PowerBI PowerQuery using M.

• Mar 5, 2023

  Power BI Create a Hierarchy with Lookupvalue

  How to create a hierarchy in Power BI with Lookupvalue.