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 mighty as they can query...
Continue reading...Hector Sanchez
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. 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...