Pondering Join Algorithms

Truly enjoying this Intro to Database Systems course from Carnegie Mellon University. Some really great breakdowns of common join algorithms in this lecture. Here are my notes. Lecture 11- Join Algorithms (CMU Databases Systems / Fall 2019) Prof. Andy Pavlo, Carnegie Mellon Database Group screenshot from lecture Table Positioning for a Join “In general, your […]

Script Windows Like A Pro: Command Line, Batch Files, Remote Desktop Connection and pywin32

Here are a few useful corners of the vast array of Windows scripting tools. Helpful Windows Command Line Documentation Windows command line Documentation Syntax Command-line reference A-Z Command shell overview Using command redirection operators About Windows Remote Management A Few General Windows Commands Use find to look in a text file to count the lines […]