Q17 — Window Functions — ROW_NUMBER, LAG, SUM OVER, Running Totals Level: Mid-Level | Topic: SQL Server What Are Window Functions? Window functions operate across a set of rows without collapsing them into a single outpu...
A practical, single-region Azure architecture for a small team building a secure .NET application with App Service, Azure SQL Database and Microsoft Entra ID.
Q14 — EF Core Performance — Compiled Queries, Split Queries, Raw SQL Level: Senior | Topic: Entity Framework Core Performance Bottlenecks in EF Core Every LINQ query goes through an expression tree compiler that translat...
Q18 — Query Optimisation Workflow — Execution Plans, Statistics, Query Store Level: Senior | Topic: SQL Server The Optimisation Workflow Effective query optimisation follows a structured workflow: identify slow queries, ...
Q16 — Transaction Isolation Levels — READ COMMITTED SNAPSHOT vs SNAPSHOT Level: Senior | Topic: SQL Server Why Isolation Levels Matter Isolation levels control how transactions see data changed by concurrent transactions...
Q15 — Clustered vs Non-Clustered Indexes — Covering Indexes, Filtered Indexes Level: Mid-Level | Topic: SQL Server Clustered Index A clustered index physically sorts and stores the actual data rows in the table based on ...
Prepare for BI and analytics interviews with 13 questions on cohort design, retention SQL, attribution, experimentation, and analytical correctness.
A production-minded AWS blueprint for a single-agent customer support assistant that searches a PostgreSQL knowledge base through constrained tools.
A medium-scale GCP SaaS architecture that combines Cloud Run, Cloud SQL, Pub/Sub, Memorystore, and Cloud Tasks across the software delivery lifecycle.
Q13 — EF Core Migrations — Production Deployment Strategy Level: Senior | Topic: Entity Framework Core The Problem with Naive Migration Deployment Running MigrateAsync() at app startup in a multi-instance deployment is d...
A pragmatic performance playbook for EF Core: find bottlenecks, fix N+1s with projection/eager loading, and when to cache or use AsNoTracking.
A medium-scale Azure design for accepting documents, orchestrating durable processing, persisting results, and operating the workflow safely across the SDLC.
Q25 — Integration Testing with WebApplicationFactory and Testcontainers Level: Senior | Topic: Testing Why Integration Tests? Unit tests verify logic in isolation. Integration tests verify the full ASP.NET Core pipeline ...
A practical small-scale blueprint for shipping safely as a solo developer with short-lived branches, automated CI, and isolated preview deployments.
A medium-scale Azure blueprint for trusted Power BI semantic models, dynamic row-level security, staged deployment, and operational visibility.
Q11 — Eager, Lazy, and Explicit Loading — Differences and the N+1 Problem Level: Mid-Level | Topic: Entity Framework Core The Three Loading Strategies Eager Loading ( Include() ): Related data is loaded in the same query...
Build a cost-efficient, scalable personal finance tracker using Next.js Server Actions paired with PostgreSQL, all on a single VPS, focusing on simplicity, performance, and developer productivity.
A small-team blueprint for giving colleagues useful, governed analytics with Metabase and PostgreSQL—without introducing a warehouse, a data platform, or a second full-time job.
Q22 — OWASP Top 10 — How Each Applies to .NET APIs with Mitigations Level: Senior | Topic: Security The Most Critical Risks A01 — Broken Access Control: Never trust client-sent IDs. Always load the resource then verify o...
A medium-scale, AWS-based blueprint for reliable ingestion, warehouse modeling, orchestration, delivery, and operations with Airbyte, Snowflake, dbt, and Dagster.
A practical AWS blueprint for a small team building dependable nightly analytics with PostgreSQL, dbt Core, and a deliberately simple ELT pipeline.
A practical AWS blueprint for a small retrieval-augmented generation service: one API, PostgreSQL with pgvector, managed models, and an operational plan sized for a small team.
A 14-question interview guide to defining, reconciling, serving, and monitoring trustworthy BI metrics across teams and tools.
A practical testing strategy for a medium-scale SaaS: use unit, integration, contract, and end-to-end tests at the right points in the SDLC, with Testcontainers for realistic dependencies.
1. Monolithic Architecture Extracted description: A single codebase and single deployable unit where all components are tightly coupled. Structure: UI / Web API → Business Logic + Data Access + Shared Components → Databa...
Q12 — AsNoTracking vs Tracked Queries — Change Tracker Internals Level: Mid-Level | Topic: Entity Framework Core How the Change Tracker Works When you load an entity with a tracked query, EF Core stores a snapshot of the...
Build a small, production-minded MCP server in TypeScript, then take it from local development through AWS deployment, testing, observability, and recovery.
An AWS blueprint for a modular monolith with enforceable context boundaries, reliable events, context-owned data, and a practical extraction path that does not require an early microservices tax.
A practical design for a medium-scale retail warehouse that preserves history with SCD Type 2 and keeps sales, inventory, and returns consistent through conformed dimensions.