JoeBloggs

Writing about programming, software engineering, and career advice.

Latest posts

Building a Safe Bulk Deletion Process Without Bulk Delete Endpoints

A practical case study on designing a long-running deletion process against a constrained external API, with pagination, rate limiting, expiring auth, retries, and resumability.

  • api-integration
  • csharp
  • system-design
  • long-running-jobs
  • rate-limiting

SQL Server Performance for Application Developers: What Actually Matters

A practical SQL Server performance guide covering SARGable queries, index design, execution plans, and optimisation techniques that improve application performance.

  • sql-server
  • performance
  • backend
  • database
  • indexing
  • query-optimization
  • software-engineering

Designing a production-safe spreadsheet import pipeline

A practical case study on transforming inconsistent Excel spreadsheets into SQL Server using a production-safe import pipeline, staging tables, and robust ID mapping.

  • data-import
  • excel
  • sql-server
  • vba macro

Junior Developer Playbook · Part 2 of 2

Junior Developer Questions Answered: Language, Portfolio, Career

Junior developers ask: which language to learn, how to build a portfolio, get experience, and thrive in their first tech job. Includes real advice, tips, and resources.

  • junior developer
  • developer advice
  • software development
  • programming languages
  • coding projects
  • tech career

Junior Developer Playbook · Part 1 of 2

Essential Guide for Junior Software Developers: Tips, Mindset, and Best Practices

Essential guide for junior software developers: practical tips, mindset shifts, real‑world stories and resources to help you thrive in your tech career.

  • junior developer
  • developer advice
  • software development
  • imposter syndrome
  • code quality
  • tech career

Welcome to My Blog

An introduction to my developer blog, my background in React, .NET, and SQL Server, and the practical software engineering content you can expect.

  • introduction
  • developer blog
  • developer advice
  • software development
  • junior developer
  • career tips