Following this guide you can have your own copy of the full AdventureWorks2022 demo dataset. Check out the steps in here to deploy .bak file to Azure SQL.

In this guide, we will walk you through the step-by-step process of deploying an Azure SQL Server using various methods, including the Azure Portal, PowerShell and Visual Studio.

A guide on how to send ChatGPT prompts inside Power Query scripts and save the data right back as new columns into your actual data.

If you are working with DirectQuery, Dual-mode or hybrid tables you will inevitably hit your back-end server with loads of queries, some more performant than others. Being able to analyze what queries are sent out comes quite handy - and doing so is quite simple.

Every day, Every minute, Fresh data from Business Central. Cloud-enabled near real-time data export—Isn’t that the dream?! I recently discovered an amazing open-source extension for Business Central that let us seamlessly synchronize our data to an Azure Data Lake.

I’m often asked about how to transition from Power BI to Synapse—Here’s my simple 7 step guide to do just that.

Wouldn’t it be nice if we could just point at a column and know about any measure that would crash if we messed with it? Yes, it would—it would be a godsend, and we can do exactly that!

Quick tip for Synapse Serverless SQL💡 Use the values of wildcards in your SQL query—Very powerful way to convert your file path or filename metadata into actual data!

Data Marts are here. It’s still a very new feature. But stay tuned! This blog post will be updated on the fly for the next few days.

By default, PowerPoint will only let you export a 96 DPI image file from your slide - but with a bit of tweaking, we can adjust it to just the right resolution.