Rags to Riches Data

Ever wanted to create your own GPT chat app? I'll show you how you can spin up a model in Azure AI Foundry and build a back end and front end to interact with a GPT (A generative pre-trained transformer).

Tutorial on how to do CI/CD for Databricks Assets like Notebooks, Files and Jobs and Cluster set up

Using Dynamics365 API calls to the Dataverse from Databricks

In this tutorial I take a batch of service bus messages, use an web app api endpoint and trigger off a write process to a sql database using passwordless authentication.

If you are using the new Azure Verified Modules from aka.ms/avm and you are using bicep, you may have asked yourself should I build my pipelines, linked services, managed private endpoints all in the IAC or should I do it in the Data Factory then read this

Doing "delta" work in Databricks and Synapse using Delta Lake technology is so simple, follow along with me

Using a high watermark and lookup table to see the last modified date and do incremental load to target table

How to get separate lines in a line chart, one for each financial year

If you have ever wondered how you use git and DevOps to promote your Dev Synapse Workspace to the next Synapse in Test, then read on...

If you have had security recommendations on rather using certificates instead of secrets for your app registration in AAD then follow this

How to build a Common Data Model in a Lake Store and use it as a data source for Customer Insights Dynamics 365

How to get the correct totals in a Power BI report

Enabling Diagnostics on Synapse SQL Pools requires you to use an "Extension Resource". Find out how I did it.

Using the Power BI API is not straight forward. Here is my journey

Enabling Auditing on Synapse is different to enabling it on Azure SQL Server. Find out how I did it in this weeks blog post

I was recently tasked with updating an ARM template to include SQL Auditing to be enabled and for the logs to go to a Log Analytic workspace. Read how I did it.

Using Power BI on very granular data is not always a good idea. The user experience can be slow and users can get frustrated with the tool. Read more about the best way to use Power BI

Recently we tried to copy a SQL table to a Delta Table in Azure Data Factory. Immediately we were hit with the error 'You cannot copy directly from SQL to Delta'. We had to stage the data first in the Storage Account. But it wasn't so straight forward. Our Databricks resource was not able to fetch the data from the Storage Account without the proper permissions