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