Currently I’m doing the course Data Engineering on Microsoft Azure (DP-203) and from the DP-203-Data-Engineer repository on GitHub we have a PowerShell called dp-203-setup.ps1 that create all resource groups automatically for us on your Azure account with specific types of resources (Storage account, Azure Databricks Service, Synapse workspace, etc). So…

How to create a server and deploy a Python application on AWS — First go to AWS website and create your free account. As soon as you have your account all setup, go to the menu bar on the top and click on Services and then EC2 on Compute topic as the image below.

This recommendation system was iniciated and learned during my Data Science training, beside the data exploration below, I’m also going to build a new application to show this recommentation to the end user in the near future. Dataset The Netflix dataset is from Kaggle competition “Netflix Prize data”, so they can…

Another simple article, which provides a PowerShell script that I need to use to download a file from a Sharepoint site. So for that we are using the Pnp.Powershell module by giving the Sharepoint online credentials and then we use Connect-PnPOnline function to connect in the account from the PowerShell. …

Another simple article, which provides a PowerShell script that I need to use to download a file from a Sharepoint site. So for that we are using the Pnp.Powershell module by giving the Sharepoint online credentials and then we use Connect-PnPOnline function to connect in the account from the PowerShell. …

In this article I’m going to show how the configparser module from Python works. This module is used for working with configuration files, which is very similar to Windows INI files. The file is organized into sections, and each section can contain name-value pairs for configuration data, just like the…

This is a really simple article, which provides a PowerShell script that I really need to use to run another PowerShell script into another Windows server. So I had a server that an SSIS package was running into the catalogs but the PowerShell script in the package was in another…

This article is very simple and short, so the main goal is to delete (clean up) automatically any file from a specific folder older than any days wanted. To achieve that, you can get the script from my GitHub repository: guimatheus92/Delete-Files-from-Folder: With this PowerShell script you can delete files from…

I’m writting this article because I used this macro several times, so I’d like to help others if I can. I’ll teach how to use VBA scripts in Microsoft Outlook to run a macro that can save any attachments from email to a folder. You can find the attachments in…