SQL and other ramblings

• When Legacy Code Meets Modern Load: A Deadlock Story 5 min read - Apr 23, 2025
• Rebuilding StravaDataAnalysis: From First Python Script to Proper Architecture 4 min read - Apr 22, 2025
• 503: Server Too Busy – Or: How I Learned to Stop Worrying and Love the Scheduled Restart 4 min read - Mar 6, 2025
• When Transactions Aren't Enough: Fixing a SQL Server Race Condition With Locking Hints 5 min read - Sep 14, 2024
• Ten Data Science Mistakes (and How to Avoid Them) 5 min read - Jul 23, 2024
• OAuth 2.0: The Developer's Quick Dip 4 min read - Oct 9, 2023
• Execution Plan Operators Reference Guide 5 min read - Oct 3, 2023
• The IN Clause That Brought Down Reporting – And How We Fixed It With a String Splitter 3 min read - Jul 7, 2023
• When SQL Server Agent Jobs Vanish Without a Trace 3 min read - Jan 20, 2021
• Create a DNS Sinkhole 10 min read - Jun 14, 2020

• 1
• 2