ExcelGuide
Translating Excel Formulas Into SQL With Worked Examples
Translate Excel formulas into SQL: lookups, conditional sums, IF, text and date functions, running totals and pivots, with a worked dataset and the traps.
18 min read
Tag
cheatsheet
14 posts
CSV
A Cheat Sheet of CSV Edge Cases to Test Every Parser With
Thirty six tiny CSV files that separate good readers from bad ones, with the right answer for each and the readers that missed it in my tests.
8 min read