Azure

  • Apr 21, 2023

    From Next.js and GitHub Pages to Azure Static Web App

    I moved out of Next.JS because it would not load the Google Analytics script. This blog is back to Jekyll built through Github Actions to an Azure Static Web App.

  • 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 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 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 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.

  • Mar 4, 2023

    Azure Cost By Resource Over Time

    How to review the cost of Azure by resource over time.

  • Feb 27, 2023

    Azure Data Factory Data Flow

    Creating a data flow to join CSV files for an ETL pipeline in Azure Data Factory.

  • Feb 26, 2023

    Build a Pipeline with Azure Data Factory

    Building a pipeline with Azure Data Factory.

  • Feb 26, 2023

    Azure Virtual Network

    Create a virtual network (Vnet) in Azure.

  • Feb 26, 2023

    Azure Resource Group and Network Security Group

    Organize your Azure resources with a Resource Group and a Network Security Group.

  • Feb 26, 2023

    Azure Data Factory Linked Service

    Create a Linked Service in Azure Data Factory.

  • Feb 26, 2023

    Azure Data Factory Dataset

    Create datasets in Azure Data Factory.

  • Feb 25, 2023

    Create an Azure Data Factory

    How to create an Azure Data Factory.

  • Feb 23, 2023

    Install Visual Studio in Azure VM

    Installing Visual Studio in an Azure VM.

  • Feb 23, 2023

    Deploy a Power BI Model to Azure Analysis Services

    Can we apply software engineering patterns like separation of concerns, single responsibility, and not repeating yourself to BI workflows?

  • Feb 22, 2023

    Azure VM agent status is not ready

    Once in a while I am getting this issue when starting a VM.

  • Feb 21, 2023

    Using Azure Data Studio

    Connect to Azure from Azure Data Studio. Generate an ER diagram.

  • Feb 20, 2023

    PowerBI with Azure SQL Database

    Connect PowerBI to Azure SQL Database.

  • Feb 19, 2023

    Create a GitHub Dashboard with PowerBI Service

    This requires PowerBI Pro.

  • Feb 19, 2023

    Azure AD Admin Microsoft Account Members Not Allowed

    When trying to set an Azure AD Admin in Azure SQL Server and looking for your account, you might get a Microsoft Account Members Not Allowed.

  • Feb 18, 2023

    Create a Power BI Service Individual Account

    What’s the hack to creating a PBI service account with a personal email account?

  • Feb 17, 2023

    Create a Windows 10 Virtual Machine in Azure

    Create a Windows VM in Azure and RDP from Linux.

  • Feb 16, 2023

    RDP from Linux to an Azure VM

    How to RDP from Linux to an Azure Virtual Machine.

  • Feb 14, 2023

    Create an Azure Blob Storage and Container

    How to create an Azure Blob Storage and containers.

  • Feb 13, 2023

    Create an Azure SQL Database

    How to create an Azure SQL Database.

  • Feb 8, 2023

    Set up PowerBI in an Azure VM

    How to set up Power BI desktop in an Azure Virtual Machine.

  • Feb 7, 2023

    DAX Studio and Power BI

    Using DAX Studio to query a Power BI model or develop DAX measures.