This article is not a step by step of how I developed it, because the project is huge. So this article is to show the difficulties that I found for my learning. If you want, you can access the repository on GitHub in the topic Conclusion.

Through Mario Filho’s course…


Photo by Ulisses on UlyssesNeves

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.

Photo by Thibault Penin on Unsplash

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 server, so in order to run without errors, we need to call the first PowerShell script that will call the second and script and the one that you needed.

So for that we are using the Enter-PSSession function by giving the server name and the credentials to connect to it.
The documentation of this function can be found here: Enter-PSSession (Microsoft.PowerShell.Core) — PowerShell | Microsoft Docs

PowerShell script example

It’s a really simple PS1 script that can be found on my GitHub reporitory:
guimatheus92/Run-PowerShell-Script-Into-Another-Server (github.com)

I hope you enjoyed this simple solution.


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.

PowerShell script

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 folder within a certain time period (github.com)

For the script to work, you just have to define how many days you want to filter to delete files on the line below.

# Defines how many days the files can stay in the defined directory
$limit = (Get-Date).AddDays(-7)

You also need to paste the folder path where the files are located on the line below.

# Defines the destination directory to clean files
$path = "Put your folder path here"

And that’s it! Now we can automate this task easily.


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…

Guilherme Matheus

Mechanical Engineer Business Intelligence developer, passionate about technology, I have knowledge and experience to create a BI architecture and much more 📚.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store