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

Backend-focused .NET interview preparation.

A backend-focused .NET preparation path covering C#, ASP.NET Core APIs, data access, reliability, testing, and practical coding.

ASP.NET Core Practical API Labs

Build the endpoint, protect its boundaries, and make failure behavior explicit.

A hands-on ASP.NET Core interview track covering typed contracts, validation, list queries, overposting, idempotency, concurrency, bulk writes, capability and resource authorization, secure files, downstream calls, durable jobs, webhooks, and rate limiting.

EF Core Practical Data Access Labs

Implement, inspect, and debug the data-access code behind real .NET APIs.

A hands-on EF Core interview track covering DTO projections, N plus one fixes, optional filters, keyset pagination, split queries, set-based updates, concurrency conflicts, outbox transactions, retry strategies, cancellation, bounded imports, query diagnostics, and pooled tenant state.