Build Offline-Ready Power Apps Without Dataverse
Introduction This blog post discusses how to build offline-first Power Apps that store data and images locally when there is no internet connection, then synchronize them to SQL Server and Azure Blob Storage once the device is back online. Perfect for field workers, mobile apps, and low-connectivity environments. In a previous post, I created a […]
Connect a Fabric Lakehouse to VS Code in Minutes
Introduction Easily connect your Microsoft Fabric Lakehouse, Warehouse, or SQL Database to VS Code. This gives you the ability to run queries in read-only on Lakehouse’s, or full CRUD operations in Warehouses and SQL Databases from within VS Code. It is as easy as installing a VS Code extension to get started. Fabric Lakehouse I […]
Save Images to Azure Blob Storage via Power Apps and Reference them from a SQL Database
Intro In this article, I demonstrate how to save images from a Power App to Azure Blob Storage and subsequently reference those images from a SQL Server data source. I have developed a Power App designed for product testing, which includes capturing an image as part of the test process. You can also catch the […]
Link Notes to a SQL Server Table in Excel Using Power Query
While working at Microsoft I had access to the SQL data from many of the applications used by the Azure Capacity Planning and Supply Chain teams. One of my functions was to track the changes and movement made to capacity (server racks) across time. To accomplish this, I used Power Query in Excel to link […]
Cloud Data Pull Using JSON HTTP Request in Power Automate
This post reviews the process of setting up a Scheduled Cloud Flow to pull data from the cloud to a local SQL Server using an HTTP request. The pulled data comes in the form of a JSON file and will need to be parsed in order to be received by SQL Server. You will also […]