CC C# Corner
RSS

Migrating SQL Server to UTF-8 Collations Without Breaking Data

In SQL Server 2019 and later, varchar columns using a collation whose name ends in _UTF8 can store Unicode text, so not every text column has to become nvarchar. The change is more than a single database setting, though: comparisons, sorting, unique indexes and storage sizes all shift. The article lays out a step-by-step path from column inventory to production rollout.

Materialized Lake Views in Microsoft Fabric: persisted transformations for Lakehouses

Microsoft Fabric's Materialized Lake Views persist Lakehouse transformations as Delta tables, letting Fabric decide how each view refreshes and enforcing data quality constraints along the way. The article walks through how MLVs fit Bronze, Silver and Gold layers, which refresh strategies apply, and where they fall short. Read it if your Fabric pipelines are stitched together from notebooks and orchestration jobs.

Balancing Azure Cosmos DB Change Feed work across multiple workers

The Azure Cosmos DB Change Feed Processor spreads change processing across several .NET workers using a lease container for ownership and checkpoints. The article walks through the setup in the .NET SDK and explains when adding workers actually helps. It also covers why downstream operations must be idempotent, since changes can be delivered again after a failure.

Reading CBOR Data Incrementally in .NET

C# Corner walks through reading CBOR data with the System.Formats.Cbor package, from a basic CborReader example to buffering partial network reads. It stresses separating incomplete input from malformed data, enforcing size limits and defining message boundaries. Useful for services that receive binary payloads from devices or APIs.

PostgreSQL Connection Pooling: Preventing Connection Exhaustion in Production

A practical guide to configuring Npgsql connection pooling in .NET and sizing pools across multiple application instances so PostgreSQL does not run out of connections. It stresses that pool limits must be calculated for the whole deployment, not a single process.

SQL Server Always Encrypted: How Secure Enclaves Change Query Support

Always Encrypted encrypts SQL Server columns on the client, so the database engine never sees their plaintext. Secure enclaves can run some otherwise blocked query operations inside a protected environment. The article walks through choosing an encryption type, defining the column and configuring a .NET client.

Custom Array Sorting vs LINQ: BenchmarkDotNet Results for 2D and Jagged Arrays

Željko Perić benchmarks his custom multi-column sort extensions for 2D and jagged arrays against the standard LINQ OrderBy/ThenBy pipeline using BenchmarkDotNet. The results show how memory layout and sorting algorithm change speed and allocations on datasets up to one million rows. It is a practical reference for developers who care about GC pressure in data-heavy code.

How to Handle Graceful Shutdown in ASP.NET Core Background Services

This guide covers how ASP.NET Core background services can stop cleanly during shutdown without losing or duplicating work. It walks through cancellation tokens, scoped dependencies, queue acknowledgement order and host shutdown timeouts, with a test checklist for production readiness.

Kafka Consumer Recovery: Resuming Processing After a Crash

Kafka consumers must pick up where they left off after a restart, crash or network failure. This article explains how committed offsets, consumer groups and manual commits govern recovery, using a C# example built on Confluent.Kafka. It also covers duplicate deliveries, poison messages and the monitoring signals that reveal a consumer quietly falling behind.

How to Scale SignalR Applications Across Multiple Servers

This guide explains how to scale ASP.NET Core SignalR across several servers using either a Redis backplane or Azure SignalR Service. It covers why messages fail to reach clients on other servers, how each option distributes them, and when sticky sessions are still needed. It is a practical starting point for teams moving real-time apps into production.