The error “Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause” appears when a query uses ...

Parse sacct output (this was made before it had JSON output, which you might want to look at instead - it's hard to use though). Preprocess all the values in to basic units, including values like GPU ...

Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...

The automation of repetitive tasks has become part of today’s workplace, whether CPAs are engaged in industry, governmental, not-forprofit, or public accounting. This automation can consist of ...

I was recently going through my notes of SQL Antipatterns and was shocked to realize how actual this book still is. I'm going to share my summary of the book. I guarantee you'll find at least a few ...

This project enables anyone to get historical and up-to-date price information at the 1-minute level of granularity for the two largest cryptocurrency projects at the moment, Bitcoin and Ethereum. The ...