2024

• How the SIGN Function Simplifies Financial Calculations in SQL 02/22
• How I Automated Daily Excel Reports Using Python and SQL 01/03

2019

• Using STRING_SPLIT in SQL Server for Stored Procedures and Reporting 09/04
• STRING_AGG in SQL Server: A Better Alternative to FOR XML PATH 05/30