Python Practical Reference Guide
This is a Python reference guide that I wrote for myself, with code samples so I can remember how to write them. I embedded a Jupyter notebook inside this blog post to test them.
Python
All posts
Page 11 of 12
KQL and Azure Data Explorer – Reference Guide
Recently I’ve been learning a new database query language, KQL which stands for “Kusto Query Language”. It is the language used by Azure Data Explorer, a tool in Microsoft’s Azure Cloud that helps query Kusto Databases. These databases run on server clusters so they are...
SQL
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
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