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 […]

Scripting As Simplified Cognition (How to Catch A Flight)

Follow the three step path to enlightenment and productivity gained: Write scripts. Follow them manually. Refine and automate if preferable. Below I “scripted” out catching my flight from Chicago’s O’hare Airport to Denver. Writing things down is often the first step to realizing what needs done. Ideally, you’d turn those written steps into a script […]

Benefits of Go and Threads in Distributed Systems

Preface These are my YouTube lecture notes from MIT’s Distributed Systems course. Thank you MIT and Professor Morris! MIT 6.824 Distributed Systems Lecture 2: RPC and Threads – Feb 7, 2020 Prof. Robert Morris (Spring 2020) Introduction Go is a popular programming language choice so my ears perked up when this lecture began. These notes […]

Characterizing Database Workloads & Storage Models

Thank you Carnegie Mellon Database Group for putting this online! These are my notes from watching on YouTube. Carnegie Mellon Databases Storage II, Lecture 4 Prof. Andy Pavlo [Watch on YouTube] The Problem and Solution How should the DBMS represent the database in storage files on disk? Solve it by choosing the right storage model […]

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 […]