C# mistakes, SQL partitioning, and .NET observability
A varied .NET roundup with C# fundamentals, SQL partitioning, outbox messaging, Azure automation, logging, and OpenCV in .NET.
Jasen's top three picks
- 1 The 9 Most Painful C# Mistakes (And How to Avoid Them)
medium.com
A solid set of C# basics and gotchas—good for newer devs and a quick refresher for the rest of us.
- 2 C# Made Easy: 8 Techniques Every Beginner Must Try
medium.com
The outbox/RabbitMQ article stands out for anyone trying to make messaging reliable without hand-waving away transactions.
- 3 Horizontal vs Vertical Partitioning in SQL
c-sharpcorner.com
Log buffering and ADO.NET connection pooling are the kind of operational details that save pain later.
Editor's note
I curated a pretty mixed bag this time: beginner-friendly C# posts sit beside deeper topics like outbox messaging, log buffering, and SQL partitioning. The Brighter outbox piece and the .NET Blog update on on-demand log buffering are especially practical for teams shipping production systems. I also included a couple of automation and AI-adjacent posts, but there isn’t a single theme tying the whole issue together.
Today's articles
The 9 Most Painful C# Mistakes (And How to Avoid Them)
medium.com
https://medium.com/@nagarajvela/the-9-most-painful-c-mistakes-and-how-to-avoid-them-a1c1f27d396e
Topics: C#
Read article
C# Made Easy: 8 Techniques Every Beginner Must Try
medium.com
https://medium.com/write-a-catalyst/c-made-easy-8-techniques-every-beginner-must-try-0bc54786fff2
Topics: C#
Read article
Horizontal vs Vertical Partitioning in SQL
c-sharpcorner.com
https://www.c-sharpcorner.com/article/horizontal-vs-vertical-partitioning-in-sql/
Topics: SQL Server
Read article
A story of collaborating agents: chatting with your database the right way
devblogs.microsoft.com
https://devblogs.microsoft.com/azure-sql/a-story-of-collaborating-agents-chatting-with-your-database-the-right-way/
Topics: Azure OpenAI SQL Server
Read article
5 n8n Hacks to Unleash .NET 9 API Automation in 2025
medium.com
https://medium.com/turbo-net/5-n8n-hacks-to-unleash-net-9-api-automation-in-2025-4544e71464cd
Read article
Transactional Messaging in .NET: Integrating Brighter’s Outbox Pattern with SQL Server and RabbitMQ
medium.com
https://medium.com/@actor-swe/transactional-messaging-in-net-integrating-brighters-outbox-pattern-with-sql-server-and-rabbitmq-181ae87212cd
Topics: RabbitMQ Service Bus SQL Server
Read article
C# .NET Chart Customization Quickstart
medium.com
https://medium.com/mesciusinc/c-net-chart-customization-quickstart-6096f2ebacc4
Topics: C#
Read articleGetting Started with OpenCV in .NET
c-sharpcorner.com
https://www.c-sharpcorner.com/article/getting-started-with-opencv-in-net/
Topics: ML.NET
Read article
Why is enumerating over List faster than IList?
steven-giesel.com
https://steven-giesel.com/blogPost/c624c170-c16c-4414-8506-2ae25ba54df7
Topics: C# Performance
Read article
LINQ & Lambda Expressions in .NET: A Deep Dive
medium.com
https://medium.com/@hpultimatemedia/linq-lambda-expressions-in-net-a-deep-dive-f1426026a07c
Topics: C#
Read article
Quick Start: Build and Connect to an MCP Server with .NET
sannidhisiva.medium.com
https://sannidhisiva.medium.com/quick-start-build-and-connect-to-an-mcp-server-with-net-7073a302c7df
Topics: C# Semantic Kernel
Read articleHow to Automate Tasks in Azure Using Logic Apps with C# Integration
c-sharpcorner.com
https://www.c-sharpcorner.com/article/how-to-automate-tasks-in-azure-using-logic-apps-with-c-sharp-integration/
Topics: Azure Azure Functions C#
Read article
C# String Methods Through Real-Life Examples
medium.com
https://medium.com/@aibhi.dev/c-string-methods-through-real-life-examples-287cc1ebefc8
Topics: C#
Read articleHow Base Differs from Ethereum: Key Comparisons
c-sharpcorner.com
https://www.c-sharpcorner.com/article/how-base-differs-from-ethereum-key-comparisons/
Topics: .NET Framework
Read article
Mastering Logging with NLog and .NET: A Playful Guide
medium.com
https://medium.com/@Pin_Pixels/mastering-logging-with-nlog-and-net-a-playful-guide-31c70d770b7e
Read articleMastering the Factory Pattern in C# 13: Best Practices with Real-World Examples
c-sharpcorner.com
https://www.c-sharpcorner.com/article/mastering-the-factory-pattern-in-c-sharp-13-best-practices-with-real-world-examples/
Topics: Serilog
Read article
Type Conversion in C#
medium.com
https://medium.com/@payton9609/type-conversion-in-c-fe905b222bbc
Topics: C# Design Patterns
Read article
Emit logs on-demand with log buffering - .NET Blog
devblogs.microsoft.com
https://devblogs.microsoft.com/dotnet/emit-logs-on-demand-with-log-buffering/
Topics: C#
Read article
Is Connection Pool Management required for ADO.NET — A Step-by-Step Detail Guide
dotnetfullstackdev.medium.com
https://dotnetfullstackdev.medium.com/is-connection-pool-management-required-for-ado-net-a-step-by-step-detail-guide-b63842f4ac96
Topics: OpenTelemetry Performance
Read articleUse Copilot to Create and Edit Power Fx formulas
c-sharpcorner.com
https://www.c-sharpcorner.com/article/use-copilot-to-create-and-edit-power-fx-formulas/
Topics: Performance SQL Server
Read article
Ways to Access Config Settings (appsettings) in ASP.NET Core— IConfig and IOptions
benedictodoh.medium.com
https://benedictodoh.medium.com/ways-to-access-config-settings-appsettings-in-asp-net-core-iconfig-and-ioptions-t-2ef48d28d4af
Topics: GitHub Copilot Performance
Read article