SQL Server

Add guardrails around EF Core tenant query filters

Explains how tenant query filters help, where they can be bypassed, and what extra safeguards protect tenant isolation.

ADO.NET connection pooling and pool exhaustion

Explains physical connection reuse, pool partitioning, short ownership, exhaustion causes, diagnostics, and why increasing the pool is not the first fix.

Avoid double-counting payments and refunds

Pre-aggregates two one-to-many relationships before joining them to prevent fanout from corrupting financial totals.

Build a filtered and paginated list page

Explains URL-backed filters, API query parameters, pagination, sorting, empty states, and shareable list views.

Build an admin CRUD workflow with permissions

Explains admin list/edit/delete workflows with capability checks, audit events, confirmation, validation, and recovery.

Build daily order KPIs with conditional aggregation

Builds several daily business metrics in one grouped query while keeping each metric definition explicit.

.NET Full Stack

Full-cycle .NET full-stack interview preparation.

A role-based preparation path covering C#, ASP.NET Core APIs, data access, frontend integration, testing, deployment, system design, real-life scenarios, and behavioral interview topics.

.NET Backend