78 posts tagged Performance. See all 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.
The habits that got you promoted, like having the answer first and closing tasks yourself, slow your team down once you manage it. Here are six things I'd tell every new engineering manager, with a concrete action for each.
Weekend Reading: A weekly roundup of interesting Software Architecture and Programming articles from tech companies. Find fresh ideas and insights every weekend.
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.
Weekend Reading: A weekly roundup of interesting Software Architecture and Programming articles from tech companies. Find fresh ideas and insights every weekend.
This week: Netflix shares how it runs LLM serving inside its own production ML platform, Uber shows a scalable identity-verification architecture for Apple Wallet IDs, Meta connects AI storage design directly to GPU utilization, and Cloudflare explains a reliability-focused redesign of Workers KV after a major outage.
Weekly tech digest featuring a comprehensive AI interview guide for .NET engineers covering LLMs, RAG, agents, and MCP with C# examples, Zalando's in-process client-side load balancer handling 1M RPS with occupancy-based bounded load, Netflix's Vera and VOID research models for controllable AI video editing, and LinkedIn's autonomous QA Agent using vision-language models for AI-driven testing at scale.
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.
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.
This week: featuring a beginner-friendly LLM explainer, Uber's Tarot platform solving Multiple Knapsack optimization for incentive allocation at scale, Airbnb's Skipper embedded workflow engine for durable execution without external dependencies, and Lyft's end-to-end mapping system for smarter pickups in gated communities.
Bad dev experience costs teams hours every day. Learn what DX is, why it matters nowadays, and practical fixes you can ship Monday. For devs of all levels.
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.
This week: Cloudflare’s MCP code mode, Uber’s database federation, Wix’s shift from prompting to AI management, and LinkedIn’s LLM-based ranking at scale.
Weekend Reading: A weekly roundup of interesting Software Architecture and Programming articles from tech companies. Find fresh ideas and insights every weekend.
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.
In this article, we explain what distributed deadlocks are, how they differ from blocking and slowness, the main types of distributed deadlocks, and practical strategies to prevent them in real systems.
Weekend Reading: A weekly roundup of interesting Software Architecture and Programming articles from tech companies. Find fresh ideas and insights every weekend.
A practical guide to the Outbox and Inbox patterns for reliable asynchronous messaging in distributed systems. Learn how Outbox ensures safe event publishing and Inbox ensures idempotent event processing, with step-by-step diagrams and implementation insights.
This chapter explores NoSQL Databases questions that .NET engineers should be able to answer in an interview.