Tips

Pro tips I keep coming back to. C#, SQL, JavaScript, 6502 assembly.

csharp 2026-03-31

Null-coalescing assignment ??= in C#

C#NullOperators

csharp 2026-03-31

Pattern matching switch expressions in C#

C#Pattern MatchingSwitch

sql 2026-03-31

Cover a query with INCLUDE columns on an index

SQLPerformanceIndexes

sql 2026-03-31

Remove duplicates with ROW_NUMBER()

SQLDuplicatesCTE

sql 2026-03-31

Concatenate rows into a string with STRING_AGG()

SQLAggregationString