7 Fun Things to do with your NAS Whilst in Self Isolation

Let’s all be clear about this – COVID-19 absolutely and categorically sucks. Been the ever-growing concern we have for our family and friends, as well as the stability of many people’s livelihoods coming out of this, there are plenty of reasons to be negative about the current situation.

https://nascompares.com/2020/04/22/7-fun-things-to-do-with-your-nas-whilst-in-self-isolation/

Power BI modelling

When you think of modelling, what do you think of? A lot of intricate joins, look ups, or maybe just frustrations? Have you experienced this before? You have a measure, but it doesn’t give you the correct answer. You wonder why. You are not exactly sure why, so you tweak the measure.

https://towardsdatascience.com/power-bi-modelling-bcd4431f49f9

Automatically refresh dataset when dataflow refresh completes

Back in August I highlighted the new dataflows PowerShell script repo on GitHub. These scripts provide an accelerated starting point to working with the dataflows REST APIs and to automate common dataflows tasks.

https://ssbipolar.com/2020/10/01/automatically-refresh-dataset-when-dataflow-refresh-completes/

Loading data in Azure Synapse using Copy

Azure Synapse Analytics (formerly SQL DW) )is the next evolution of Azure SQL Data Warehouse. It is a combination of enterprise data warehousing and Big Data Analytics. A Synapse SQL Pool is the enterprise data warehousing feature that is generally available in Azure Synapse Analytics.

https://www.sqlservercentral.com/articles/loading-data-in-azure-synapse-using-copy

Loading data in Azure Synapse Analytics using Azure Data Factory

In my last article, Loading data in Azure Synapse using Copy, I discussed about loading data in the SQL Pool of Azure Synapse Analytics using the COPY command. Here, I will discuss the step-by-step process for data loading in the SQL Pool using Azure Data Factory (ADF).

https://www.sqlservercentral.com/articles/loading-data-in-azure-synapse-analytics-using-azure-data-factory

Incremental Data Loading using Azure Data Factory – SQLServerCentral

In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basics are covered in that article.

https://www.sqlservercentral.com/articles/incremental-data-loading-using-azure-data-factory

Build Your Own Raspberry Pi Home Network Content Filter

Every device on your network is bombarded 24/7 with malware, banner ads, pop-ups, and activity-tracking scripts. All that extra cruft slows down your browsing. But with a bit of tinkering, you can program a tiny and cheap Raspberry Pi computer to block this noisome dross.

https://www.wired.com/story/diy-raspberry-pi-home-network-content-filter/

Using Visual Studio Code to query Power BI

In this article, I’m going to show how you can use Visual Studio Code to run queries against a Power BI model. Usually, this is the kind of task you would use the excellent DAX Studio for, but sometimes you have a requirement that doesn’t quite fit DAX Studio.

https://dax.tips/2020/08/24/using-visual-studio-code-to-query-power-bi/