SQL Server hierarchyid: A Built-In Alternative to Recursive CTEs
Learn how SQL Server’s hierarchyid data type stores and queries tree structures without recursive CTEs, with practical examples for org charts and hierarchical data.
Recursive CTEs in SQL Server: How the Parts Actually Work Together
A plain-language walkthrough of recursive CTEs in SQL Server, breaking down the anchor, the recursive member, and the iteration cycle so the syntax finally makes sense.
A Better Cursor Pattern for SQL Server: Cursor Variables and @@CURSOR_ROWS
Replace the traditional WHILE @@FETCH_STATUS cursor loop with a cleaner pattern using cursor variables, STATIC cursors, and @@CURSOR_ROWS for more readable, less error-prone T-SQL.
Self-Hosting Forgejo on Windows Server Hyper-V Step-by-Step
A complete walkthrough for running Forgejo on Debian 13 inside a Windows Server Hyper-V VM, with Docker Compose, Let’s Encrypt TLS, GitHub repo mirroring, and automated backups to a Windows network share.
Setting Up Your Three-Layer Backup
This is Part 3 of a series. In Part 1, I argued that open source licenses protect your code but not the infrastructure around it. In Part 2, I surveyed the landscape of options for…
Where Should Your Code Live Besides GitHub?
This is Part 2 of a series. In Part 1, I made the case that open source licenses protect your code but not the infrastructure around it. GitHub, npm, and the platforms we depend on…