I used the ggplot2 package's approach to returning the "last plot" to make a session cache for my latest package.
You can combine Excel's INDEX() and MATCH() functions to search for values in a column, but it relies on your data being sorted to work correctly. I figured out a solution for unsorted data by incorporating MINIFS() and MAXIFS() into the logic.
The targets package is a fantastic tool for reproducible workflows, but requires a some extra logic when working with databases.
There are quite a few ways to interact with MS SQL Server from R, but things seem more limited when it comes to spatial data. I figured out a way to have my cake and eat it too.
Reflecting on things I wish I'd known when I started graduate school.