SQL Server Posts

Link Notes to a SQL Server Table in Excel Using Power Query

April 21, 2023

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

Cloud Data Pull Using JSON HTTP Request in Power Automate

October 7, 2022

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

Create a Power BI Date Table

May 27, 2023

How to Set Up a Data Gateway in Power Automate

October 11, 2022

Cloud Data Pull Using JSON HTTP Request in Power Automate

October 7, 2022

SharePoint Team Vacation Tracker

October 12, 2023

Link Notes to a SQL Server Table in Excel Using Power Query

April 21, 2023

Using Power Automate to Move and Rename Excel Files and Copy its Content to Another Excel File-Series Summary

September 5, 2022