All posts / SQL Server

Build the Engine, Not the Pipeline: Lessons from a Configuration-Driven Data Platform

Lessons in ETL, data modeling and reusable platforms from building a configuration-driven data engine, and what AI agents would change.

SQL Stored Procedure Best Practices

A concise summary of best practices for SQL stored procedures—covering performance, maintainability, naming conventions, and security.