Common Interview Questions Blog Posts
An index can turn a slow query into a fast one, or slow down every insert on the table. In this article, we explain database indexing in SQL Server, PostgreSQL, and MySQL: eleven index types, when to use each one, when to avoid them, and how to find missing and unused indexes.
AI keeps evolving, and AI skills are becoming mandatory for engineers. In this article, we look at how companies assess these skills today and which approach you can use in your interview process: six formats, a rubric, and a 60-minute template.
Every migration guide explains how to split a monolith. This one goes the other way: a test for which services to merge, and seven patterns for merging them back into a modular monolith without a big-bang rewrite, each with its cost.
EF Core makes the slow path look exactly like the fast path. A scan, an N+1 loop, and a Cartesian join all read like clean LINQ. This guide walks through 18 concrete mistakes across querying, related data, change tracking, indexes, plan caching, and context overhead, with the fix for each and a ready-to-use rule for your AI coding assistant.
Prepare for your next .NET interview with 800+ interview questions and answers covering C#, ASP.NET Core, SQL, NoSQL, microservices, distributed systems, testing, AI, Agile, desktop and mobile development. For developers, senior engineers, architects and tech leads.
Complete Agile interview guide covering Scrum, Kanban, metrics, risk management, and enterprise scaling. For junior to senior engineers preparing for interviews
A practical guide to 17 prioritization frameworks for product managers, engineering teams, and portfolio leaders covering MoSCoW, RICE, ICE, WSJF, Cost of Delay, Kano, Opportunity Scoring, and more. Includes formulas, worked examples, limitations, and a framework selection guide.
In this article, we review AI, LLM, prompting, .NET AI integration, Semantic Kernel, Microsoft Agent Framework, MCP, RAG, resilience, testing, observability, security, and AI coding tools for .NET engineers.
Learn how modern LLMs are trained, from pretraining and instruction tuning to SFT, RLHF, DPO, and model distillation. This guide explains how raw foundation models become production-ready AI assistants, coding copilots, and enterprise agents.
A practical guide to C# mobile development interviews in 2026. Covers .NET MAUI, Xamarin, architecture, performance, UI patterns, and real-world mobile engineering concepts with clear explanations and examples.
This part of C# / .NET interview questions and answers covering modern desktop development: WinUI 3, .NET MAUI, Avalonia UI, MVVM architecture with CommunityToolkit, performance optimization, data storage with EF Core and SQLite, secure credentials, background sync, MSIX packaging, and auto-update strategies.
60+ C# / .NET testing interview questions with code examples. Covers unit testing, integration testing, gRPC, contracts, distributed systems, Playwright, and performance.
MCP is the universal standard for connecting AI agents to external tools and data. Learn what it is, how it works, and why every major AI company adopted it.
Learn the most common unit test anti-patterns in .NET, over-mocking, testing implementation details, flaky async, assertion roulette, and how to fix them.
In this article, we explore microservices and distributed systems interview questions and answers, and what every .NET engineer should know, from service boundaries and BFF to sagas, events, service discovery, and communication patterns.
This chapter explores NoSQL Databases questions that .NET engineers should be able to answer in an interview.
In this article, we explore practical patterns for data versioning and schema evolution in NoSQL systems.
This chapter explores SQL Database questions that .NET engineers should be able to answer in an interview.
Learn efficient SQL pagination techniques: offset, keyset, cursor, snapshot, hybrid & more. Understand trade-offs, use cases, and best practices.
Learn the BASE model in databases explained simply for junior developers. Understand how Basically Available, Soft State, and Eventual Consistency work in distributed systems, such as NoSQL.