Writing about SQL, data systems, and real-world problems.

Mostly things I’ve learned from:

  • Writing SQL for real systems
  • Designing data models that scale
  • Automating data workflows with Python
  • Working across SQL Server, PostgreSQL, and Snowflake

Check out my latest posts ↓

How the SIGN Function Simplifies Financial Calculations in SQL
Hey there! While working with financial data in SQL, I ran into a somewhat forgotten function called SIGN() that turned out to be surprisingly useful.
2024/02/22 · Posts
How I Automated Daily Excel Reports Using Python and SQL
Excel is a powerful tool for creating daily reports, charts, and data analysis workflows. However, when reports rely on large datasets stored in a SQL database, manual extraction quickly becomes inefficient and error-prone.
2024/01/03 · Posts
Using STRING_SPLIT in SQL Server for Stored Procedures and Reporting
Hello and welcome back to another post! Recently, I was reviewing some stored procedures used to generate reports. These procedures accepted several parameters — some nullable, others allowing multiple values.
2019/09/04 · Posts
STRING_AGG in SQL Server: A Better Alternative to FOR XML PATH
Hello again! How many times have you needed to create a list of values separated by commas? I’ve been in that situation many times, and I’m sure you have too. Before SQL Server 2017, doing this usually meant ugly XML tricks like STUFF and FOR XML PATH.
2019/05/30 · Posts