Tim talks tech

Series

Worked examples

Descriptions of how specific situations have unfolded in real-world programming I've done. Aims to provide insights into the reality of a programmer's work and learn lessons from these occasions.

Articles in this series

Worked example - Using regex to refine a SQL script

Mar 29, 20232 min read

I was recently asked to copy some data in a SQL Server database but to exclude records which had the words 'To Delete' in their names. This is a...

Worked example - Using regex to refine a SQL script

Worked example - Find the longest file path in your codebase

Mar 7, 20231 min read

I recently wanted to know the length of the longest file path within my codebase. Someone was struggling to pull the code to their local machine, and...

Worked example - Find the longest file path in your codebase

Worked example - Rearranging projects in large solution

Jun 30, 20223 min read

I've recently been working with a solution which contains 34 projects. In the file system, the root of the repository had a flat list of all 34...

Worked example - Rearranging projects in large solution

Worked example - Creating a C# class for each file in a folder

Jun 23, 20221 min read

I recently needed to create a C# class for each file in a folder. This was a one-off job, but there were a large number of files in the folder. How...

Worked example - Creating a C# class for each file in a folder

Worked example - Writing better commit messages

Feb 24, 20222 min read

Adding references and explanations to commit messages to help other developers understand your reasoning · In my experience, many developers write very...

Worked example - Writing better commit messages

Worked example - Editing an Azure DevOps wiki locally

Feb 21, 20221 min read

A gotcha that I ran into while updating an Azure DevOps wiki · All wikis in an Azure DevOps project are stored as git repositories. I wanted to use Find...

Worked example - Editing an Azure DevOps wiki locally