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. Window Functions OVER() Function OVER() is a function used after an aggregate function like SUM() to...
Continue reading...SQL Server Integration Services (SSIS) Guide
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...