Here is a Guide on SSIS Integration Services Tasks Service Type Service Name Explanation Data Flow Task Data Flow Task * Extract data from a variety of sources, apply column-level transformations, and load data into a database Data Preparation Tasks * FTP Task* Hadoop File System Task* File System Task...
Continue reading...NetStat Cheat Sheet
Here is a quick cheat sheet about NetStat that I gathered from the video I share at the bottom of this post. NetStat is a very useful tool for managing system network connection ports among other things. NetStat Basic Commands Command Explanation netstat –help Help netstat -ie Displays the Network...
Continue reading...How to Setup an Azure Virtual Machine for Python Development
As part of the Data Science course I’m currently studying in Tec de Monterrey, I learned how to do remote python development using Github Codespaces for free. I found this to be an eye-opener as it meant I could use Visual Studio Code for coding Python apps directly on a...
Continue reading...Cloud Services Comparison (AWS vs Google vs Azure)
This is a quick reference guide to compare the basic cloud services among the 3 top competitors, Microsoft Azure, Google Cloud Services, and Amazon AWS. This compilation was made based on two articles published by Microsoft, and the prices I was able to get in their respective pricing calculators. It...
Continue reading...How to Connect to an Amazon EC2 Virtual Machine from Windows 10
Connecting to Amazon’s EC2 Virtual Machine from Linux is easy, as all we have to do is download the PEM key file into the project folder, change the permissions with the CHMOD command as in the example below, and then connect to the virtual machine from the terminal using something...
Continue reading...