Posts and interview questions tagged SQL.
30 senior EF Core interview questions with deep answers and real code: change tracking, query performance, concurrency, transactions, and migrations.
30 senior microservices interview questions with deep answers and real code: service boundaries, saga & eventual consistency, resilience, and observability.
30 senior SQL Server interview questions with deep answers and real T-SQL: execution plans, indexing, locking & isolation, parameter sniffing, and tuning.
30 senior ASP.NET Core interview questions with deep answers and real production code: the middleware pipeline, DI lifetimes, Kestrel, hosting, and auth.
30 senior C# interview questions with deep answers and real production code: async/await, GC and memory, the type system, LINQ, and concurrency.
30 senior Angular interview questions with deep answers and real code: change detection, OnPush, RxJS operators, signals, and performance.
OnPush, trackBy, lazy loading, Signals, and standalone components — the Angular 19 performance playbook with real production metrics from Mattrx.
Webpack Module Federation vs Native Federation, independent deployments, versioning shared deps — the Angular micro frontends playbook from Mattrx.
Signals model state, RxJS models events over time — when to use each, performance numbers, and the interop pattern that uses both at the right boundary.
Core, Shared, Feature modules + Nx monorepo — the enterprise Angular layout that survives 4 apps, 20 libs, 5 teams. Real project + production metrics.
LLMs from first principles: tokenization, embeddings, RoPE, self-attention, multi-head, nanoGPT, pretraining, SFT, LoRA, QLoRA, DPO, vLLM serving.
The MLOps playbook: deploying models (REST/batch/streaming), versioning + registry + CI/CD, drift monitoring, cloud strategies, and a full end-to-end app.