Why it mattersBreaks caching, increases IO, hides schema drift.
Author: ErcanOPAK
Covering Indexes Prevent Lookups
CREATE INDEX IX_User_Email ON Users (Email) INCLUDE (Name); Why it mattersFewer disk reads = faster queries.
Use MapGroup for Clean Endpoints
app.MapGroup(“/api/users”) .MapGet(“/”, GetUsers); Why it mattersBetter structure without controllers.
Why Minimal APIs Improve Cold Start
app.MapGet(“/ping”, () => “pong”); Why it mattersLess middleware, faster startup.
Visualize Branch History Clearly
git log –oneline –graph –all Why it mattersInstant mental model of the repo.
Stash Only What You Need
git stash push -m “temp” file.cs Why it mattersCleaner context switching.
Send JSON the Right Way
fetch(url, { method: “POST”, headers: { “Content-Type”: “application/json” }, body: JSON.stringify(data) }); Why it mattersAvoids silent model binding failures.
Use requestIdleCallback for Background Tasks
requestIdleCallback(() => heavyWork()); Why it mattersRuns tasks without blocking UI.
Native Lazy Loading Without JS
<img src=”img.jpg” loading=”lazy”> Why it mattersInstant speed win, zero JS.
Use clamp() for Perfect Responsive Font Sizes
font-size: clamp(1rem, 2vw, 1.5rem); Why it mattersOne rule replaces media queries.
Clipboard History is a Superpower
Win + V Why it mattersMultiple snippets = faster coding and writing.
Enable Ultimate Performance Mode
powercfg -duplicatescheme e9a42b02-d5df-448d-aa00-03f14749eb61 Why it mattersNo throttling during heavy builds or renders.
Emergency Home Repair Assistant
Prompt Act as a home maintenance expert. Give step-by-step guidance using only common household tools. Why it mattersPractical, offline-friendly, panic-proof advice.
Convert Legacy Code to Modern Patterns
Prompt Refactor this code using modern best practices, explain why each change matters. Why it mattersYou learn why, not just what.
Generate Code Reviews Like a Senior Engineer
Prompt Review this code for performance, security, and maintainability.Suggest improvements with explanations and alternative patterns. Why it mattersTurns AI into a virtual lead developer.
Multi-Stage Builds = Smaller Images, Faster Deploys
FROM node:18 AS build RUN npm run build FROM nginx:alpine COPY –from=build /app/dist /usr/share/nginx/html Why it mattersRemoves build junk → secure & tiny images.
Why Liveness ≠ Readiness Probes
livenessProbe: httpGet: path: /health readinessProbe: httpGet: path: /ready Why it mattersLiveness restarts pods, readiness controls traffic. Mixing them causes outages.
Custom Post Status for Internal Workflows
Editorial chaos? Add your own status. register_post_status(‘internal-review’, [ ‘label’ => ‘Internal Review’, ‘public’ => false ]); Why it mattersCleaner workflows without extra plugins.
Disable Heartbeat API Selectively (Not Globally)
Heartbeat eats CPU on admin screens. add_action(‘init’, function () { wp_deregister_script(‘heartbeat’); }); Why it mattersAdmin stays responsive without breaking autosave where needed.
Export Web Images Without Losing Color Accuracy
Browsers assume sRGB. Always:Edit → Convert to Profile → sRGB IEC61966-2.1 Why it mattersFixes “why does my image look different online?” forever.
Non-Destructive Sharpening with High Pass Layer
Never sharpen directly on the image. Workflow Duplicate layer Filter → Other → High Pass (2–4px) Blend mode → Overlay Why it mattersKeeps original pixels untouched, perfect for export variants.
Use Solution Filters to Load Only What You Need
Large solutions kill startup time and focus. Hidden feature: Solution Filters (.slnf) dotnet slnf create dotnet slnf add MyProject.csproj Why it mattersVisual Studio loads only required projects → faster boot, less RAM, more focus.
Stop Boxing With in Parameters for Hot Paths
void Process(in LargeStruct data) Why this mattersAvoids copies and reduces GC pressure.
Use FrozenDictionary for Read-Heavy Workloads (.NET 8+)
var map = myDict.ToFrozenDictionary(); Why this mattersOptimized lookups, thread-safe, zero mutation cost.
Why record Types Reduce Bugs in DTOs
The Problem: How many times have you created a simple class just to hold data (like a DTO or a config object), only to find yourself drowning in boilerplate code? You need properties, a constructor, and if you want to compare them, you have to override Equals() and GetHashCode(). Before you know it, a simple […]
Use EXISTS Instead of IN for Better Query Plans
SELECT * FROM Users u WHERE EXISTS ( SELECT 1 FROM Orders o WHERE o.UserId = u.Id ); Why this mattersEXISTS short-circuits; IN often materializes full sets.
Why COUNT(*) Can Be Slow on Large Tables
Counting rows forces full scans. SELECT COUNT_BIG(*) FROM Orders WITH (NOLOCK); Why this mattersOn massive tables, counts are expensive — cache or approximate when possible.
Use IHttpClientFactory or Face Socket Exhaustion
Creating HttpClient per request is a silent killer. services.AddHttpClient(); Why this mattersConnection pooling prevents random production outages.
Why BackgroundService Beats Task.Run in APIs
Fire-and-forget tasks die with requests. public class Worker : BackgroundService { protected override async Task ExecuteAsync(CancellationToken ct) { while (!ct.IsCancellationRequested) await DoWorkAsync(ct); } } Why this mattersHosted services respect app lifetime and graceful shutdown.
Speed Up Large Repos with Partial Clones
Huge repo? Clone only what you need. git clone –filter=blob:none <repo> Why this mattersMassive bandwidth and disk savings for CI and dev machines.