Advanced SQL Server Guide
This is a short quick guide on advanced SQL Server topics, that I recently learned in this course from Udemy. The examples run in this post, use the AdventureWorks2019 sample database provided by Microsoft.
SQL
All posts
Page 11 of 12
SQL Server Integration Services (SSIS) Guide
SQL Server Integration Services (SSIS) Guide
SQL
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.
Linux
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...
Cloud
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...
Cloud
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...
Cloud
How to Install Linux Ubuntu on Windows
I recently learned how to install Ubuntu on my Windows 10 laptop, not as a virtual machine, but as part of my normal Windows installation, so I have the advantage of not wasting resources dedicated to Ubuntu on a virtual machine.
Linux
Docker and Kubernetes Guide
Additional parameters to run a container
Cloud