My posts

2024
- Running Proxmox on a Raspberry Pi
- Honouring .gitignore settings
- Faker.Net: Data Generation for Developers
- Exploring MiniExcel: A Lightweight .NET Library for Excel Operations
- File Path Size Does Matter
- How to Install and Use BareTail for Real-Time Log File Monitoring
- Enhancing Kubernetes Experience with Kubecolor
- SQL Server Object Explorer Microsoft.Data.SqlClient.TdsParser exception
- Running SQL Statements
- Time Management with the Eisenhower Matrix
- Exploring Playwright’s Trace Viewer
- The foreach Loop Best Practices and Common Pitfalls
- HashSet v List
- Asynchronous Task.Delay
- Optimising Performance by Defining the Length of a C# List
- Using Custom ID Classes
- Guard Clauses
- The Bulkhead Pattern
- Understanding Task.Yield
- Underused Moq Features
- Inserting Records with Identity Fields and Retrieving IDs for Future Use
- Understanding GetRequiredService in .NET: Enhancing Dependency Injection
- Strongly Typed Configuration in .NET8
- API Mocking with Mockoon
- The Power of Back-End-for-Front-End (BFF) in Decoupling Front-End and Back-End Services
- Checking IP/Ports are Open for Business
- Network Policies in Kubernetes with Rancher
- NUnit’s Coolest Feature – Data-Driven Tests
- Using Moq to Verify your Logging is working
- NUnit’s Assert.That
- Asynchronous Testing with NUnit and C#
- Using NUnit to test Exceptions
- TDD – Test Driven Development
- Building a Web API with TypeScript
- TypeScript for C# Developers – making a move
- Understanding TypeScript Promises
- Understanding JavaScript Promises
- Jest: The Comprehensive JavaScript Testing Framework
- View Models in MVC
- Enhancing Code Consistency with EditorConfig
- Using LINQPad with an Existing Database
- LINQPad

2023
- A potential C# Snowflake Generator
- Snowflake Id’s – Unique Id’s – sort of
- Azure Table Storage and Transactions
- Integrating BenchmarkDotNet in Azure DevOps Pipeline for Performance Measurement
- Integrating Serilog with Loki for Efficient Logging in .NET Applications
- Exploring the Versatility of Serilog Sinks in .NET Applications
- Implementing Serilog in ASP.NET C# Web API for Enhanced Logging of Requests and Responses
- How to Install Docker on Windows 11: A Step-by-Step Guide
- Connecting to a Kubernetes Cluster on Rancher with kubectl from Windows
- Install kubectl on Windows
- Add Human Intervention into an Azure Pipeline
- Create a YAML Pipeline in Azure DevOps
- Boost Your C# Code’s Performance with BenchmarkDotNet
- Choose await/async over Task Alone
- To Pass or Not To Pass a Cancellation Token
- Await vs. ContinueWith in Asynchronous Programming: Making the Right Choice
- Making Methods Async
- Avoid async void
- Insomnia vs. Postman: A Guide to API Testing and Debugging Tools
- Insomnia: An API Testing and Debugging Tool
- A Christmas Message
- The Evil Designer Files
- The Provider Model
- The Specification Pattern
- Elevate Your .NET Console Applications with Spectre.Console
- The Importance of C# Records: Simplify Your Code with Examples
- Getting Started with Serilog in C#
- The Power of Kong – The API Gateway
- Turning a Folder into a Git Repository
- Leveraging the Power of a 1-Second Cache
- Rectangle App: A Window Management Powerhouse for Mac
- Using a MacBook for Windows Development with Parallels
- Hosting a Windows Container Build Agent and Connecting It to Azure DevOps
- Performance Comparison: List vs. HashSet in .NET
- RateLimiterOptionsExtensions in .NET:
- Rate Limiting Strategies in .NET
- Building a Secure Web API with C#
- Serialising and Deserialising JSON in C#
- JSON Web Tokens (JWTs)
- The Single Responsibility Principle
- The Liskov Substitution Principle
- The Interface Segregation Principle
- The State Pattern
- The Facade Pattern
- Design Patterns
- The Proxy Pattern
- The Memento Pattern
- The Flyweight Pattern
- The Decorator Pattern
- The Composite Pattern
- The Bridge Pattern
- The Adapter Pattern
- The Null Object Pattern
- The Visitor Pattern
- The Template Method Pattern
- The Strategy Pattern
- The Observer Pattern
- The Iterator Pattern
- The Interpreter Pattern
- The Command Pattern
- The Chain of Responsibility Pattern
- The Mediator Pattern
- The Factory Method Pattern
- The Abstract Factory Pattern
- The Object Pool Pattern
- The Prototype Pattern
- The Builder Pattern
- The Singleton Pattern
- The Factory Pattern
- Demystifying Reflection in C#
- Testing Exceptions in C# with NUnit
- Unit Testing in C# with NUnit
- A Christmas Story of the Web Forms Application
- What are SQL fat pipes?
- Understanding the SQL “SELECT FROM a SELECT” Query
- The SQL Like Command
- Testing Date Pickers with Playwright and TypeScript
- Automating Dropdown, Textbox, and Checkbox Interactions in TypeScript
- SonarLint for C# Developers: Enhancing Code Quality and Productivity
- K6 – The Modern Load Testing Tool for Agile Development
- Keeping Your Git Repository Tidy: The git clean Command
- Demystifying the SqlPackage.exe Command
- Resharper
- Visual Studio Macros
- Creating A Docker Image to Run An Application
- Ventoy: A Multi-Boot USB Tool for Windows, Linux, and macOS
- Using Jest With TypeScript
- Containerising an ASP.NET Core Web API Application with Docker
- Stryker Plugin for Visual Studio Code
- Stryker – Static Code Analysis
- Prettier: A Code Formatter for Consistent Code Styling
- Airbnb TSLint
- TSLint Plugin for Visual Studio Code
- TSLint Plugin for Visual Studio
- TSLint: A Code Linter for TypeScript
- HTTP Return Codes
- SQL JSON: Taming the Wild World of JSON Data in SQL Server
- Debugging ESP32 Applications with VisualGDB
- Using the VisualGDB Plugin
- Log Levels
- Asynchronous HTTP Requests with Axios.all and TypeScript
- Using Axios with Vue3 to talk to an API
- A Guide to Common Table Expressions
- Update your GIT Repositories
- Resetting a Git Repository Branch
- Terminating Database Connections
- Moving SQL Server Log Files to a New Location
- Fix Up SQL User Access
- Keyboard Short Cuts in Visual Studio Code
- Transitioning from Visual Studio to Visual Studio Code: A Practical Guide for Developers
- F.lux – Help your Eyes
- Installing Choco on Windows
- Enhancing Local Development with Acrylic DNS
- Git Merge v Rebase
- Lock Hunter
- Curl
- Integrating C# with GraphQL: A Guide for Developers
- Understanding SSL Certificates and Certificate Authorities
- Integrating Ngrok with C# Applications
- Exploring the Microsoft Feature Management Library in .NET
- Understanding the yield Keyword in C#
- Enabling Foreach Functionality in C# Classes
- Understanding Init-Only Properties in C#
- Advanced Use of Async Cancellation Tokens in C#
- Understanding Async in C#
- Vite
- Installing and Using TypeScript on a Windows Machine
- Another Time Machine
- Unit Testing Mininal APIs
- Building a Customer API with .NET Minimal API Framework
- The Time Machine
- What are C# Records
- Avoid Typescript Pitfalls
- Bundler and Bundling
- The TypeScript Compiler: An Essential Tool for TypeScript Development
- TypeScript Configuration Files: Best Practices and Essentials
- Mastering TypeScript Interfaces: A Guide for Efficient Development
- Exploring TypeScript Source Maps: Enhancing Debugging and Development
- Understanding Boxing and Unboxing in C#
- Rubber Ducking
- Unifi Controller Software
- Exploring Vue.js: Let’s start simple
- Creating a Basic Vue3 App
- SonarLint for C#: Elevating Code Quality and Productivity
- Hardware Passthrough with Proxmox
- Tailoring Your Command-Line with Oh My Posh: Exploring Module Configurations
- Guide to Installing and Configuring Proxmox VE
- Building Minimal APIs with .NET 8 and C#
- Unveiling the Performance Enhancements in .NET 8
- Understanding .NET Collection Classes and Their Performance
- SQLCMD: A Tool for SQL Server Management
- Exporting a SQL Database: A Step-by-Step Guide
- Streamlining Your Workflow: A Guide to Stream Deck Mobile on iOS
- Write a Self Updating Application on a Raspberry Pi with C#
- Testing Popup Windows with TypeScript and Playwright
- Use PlayWright to test www.google.com
- File Compression in C# with System.IO.Compression
- Notepad++: My GoTo Text Editor
- How a Stream Deck Can Revolutionize Your Coding Workflow
- An Illuminating Subject
- Using SQL Extended Events for Advanced Monitoring and Tuning
- Using the Microsoft SQL Profiler
- YARRP – Additional Content
- Maximising Revenue Potential: A Guide to Adding Adverts to Your WordPress Site
- Setting Up AdSense
- Mastering SQL TDE: A Guide to Managing Certificates for Disaster Recovery
- Send an ESP32 New Firmware OTA
- Diskspd: The Essential Tool for Storage Performance Analysis
- YAML Files
- Exploring the New Horizons of .NET 8: A Summary of Features and Improvements
- Connecting an ESP32 to a DS18B20 Temperature Sensor Using C# and nanoFramework
- Exploring the nanoFramework Flasher Tool (nanoff) for ESP32 Development
- Installing Drivers for ESP32 Development on Windows: A Step-by-Step Guide
- Flashing nanoFramework onto ESP32: A Comprehensive Guide
- Harnessing WiFi Capabilities on ESP32 with C#: A Practical Guide
- Debugging C# on ESP32: A Guide for Developers
- Installing the nanoFramework for Visual Studio: A Step-by-Step Guide
- Running C# on an ESP32 Microcontroller
- Understanding Playwright’s Screen Capture
- Learn how to create Playwright Tests
- Mastering SQL Stored Procedures
- Git Command List
- Fix incorrect Git Comments
- Pruning your Git Repository
- Merging, Stashing and Reverting in Git
- Understanding the Essentials: Git commands
- Mastering SQL Cross Apply and Outer Apply Joins
- Kavita – your online library
- Monitor Servers and Services with Uptime Kuma
- Mastering SQL Cross Joins
- Mastering the SQL Self Join
- Mastering the SQL Outer Join
- SQL Performance Strategies
- Mastering the SQL Left Join
- Mastering the SQL Inner Join
- SQL Execution Plan
- C# and handling SSL Certificate Problems
- Why is SQL slow?
- Stop / Start a Site in IIS
- Regex for Passwords
- Generate a C# class from a SQL Table
- Used Identity Fields in SQL
- Who is using my database
- Delete Obj/Bin folders in a Visual Studio solution
- Find duplicate records in a table and remove them
- SQL Number of records per table
- List IIS AppPool processes
- Check for SQL Index Fragmentation
- SQL Disk Space Usage
- Test SQL Connection without SSMS
- Web Forms Page / Control Events and Sequence
- SQL Joins
- SQL Suggested Indexes
- Determine where SQL files are
- Shrink an SQL database
- Fix a SQL Database
- Enable SQL Database Diagrams
- Update SQL Statistics on things
- Another way in SQL to Delete Duplicate Records
- SQL Records Per Table
- Delete a constraint on a table / field combination without knowing the name of the constraint
- SQL Indexes and Check if One Exists
- How to duplicate SQL Rows
- Restore a SQL database
- Debugging Dot Net Core applications on a Raspberry Pi with Visual Studio
- TFT Display on a Raspberry Pi
- C# and Rebooting a Raspberry Pi
- Proxmox Tag Colours
- Install the Dot Net Debugger on a Raspberry Pi
- Install Dot Net Core on a Raspberry Pi
- Prepare a Raspberry Pi for GPIO access
- Encoding & Decoding Secrets
- Static IP address on Ubuntu
- Creating a new Ubuntu Server VM in Proxmox
- Setting Up Rancher
- Setup a Raspberry Pi
- Network UPS Server
- ArgoCD
- A new code prettyfier
- Raspberry Pi 3-4 IO Pin Diagram
- Twingate – It’s not a VPN, or is it?
- Unifi Dream Machine
- Dell XC730-16G
- Unifi US-16-XG
- Hyper-V Powershell Networking
- HP 10Gb Dual SFP+ Network Card & Hyper-V
- Heimdall
- Homarr – My new homepage
- Moving VMs and Containers on Proxmox
- Updating a Copy Code WordPress Plugin
- Mount an existing NFS share into K8s Pods
- Add an NFS provisioner to Kubernetes
- NFS and Proxmox containers don’t mix
- Manage K8s with K9s
- Moving from Hyper-V Server to Proxmox
- Installing & Configuring Traefik with SSL certs
- Updating the site URL on an existing WordPress site
- Proxmox failed container backups
- Slow and Problematic Windows -> Linux SMB Share
- PiHole and lots of Block Lists
- Create a Kubernetes Cluster with Rancher
- Setup for Move VM from one Hyper-V host to another
- Traefik – a great ingress controller
- MetalLB – Kubernetes does need a load balancer
- A cluster of Proxmox servers
- Shares in TrueNAS
- Setting up backups in Proxmox
- Windows Terminal Configuration
- Setting up Proxmox
- Configuring Email Alerts on Proxmox

My posts

Stephen