Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Writing repetitive mapping code, serialization logic, or validators? Source Generators create code at compile time, eliminating runtime reflection overhead. What Are Source Generators: // You write this: [GenerateToString] public partial class Person { public string Name { get; set; } public int Age { get; set; } } // Source Generator automatically creates this at […]
Processing queue of tasks between threads? System.Threading.Channels provides async-first, high-performance producer-consumer patterns. Install Package: dotnet add package System.Threading.Channels Basic Producer-Consumer: using System.Threading.Channels; // Create unbounded channel var channel = Channel.CreateUnbounded(); // Producer task var producer = Task.Run(async () => { for (int i = 0; i < 100; i++) { await channel.Writer.WriteAsync($"Message {i}"); await Task.Delay(10); […]
Modifying objects causes bugs when multiple parts of code reference the same instance. Records with with-expressions create modified copies safely. The Mutable Class Problem: public class Person { public string Name { get; set; } public int Age { get; set; } } var person = new Person { Name = “John”, Age = 30 […]
Inserting if row doesn’t exist, updating if it does? MERGE statement does both in one atomic operation without race conditions. The Problem – Separate Insert/Update: — Check if exists IF EXISTS (SELECT 1 FROM Products WHERE ProductId = @Id) BEGIN — Update UPDATE Products SET ProductName = @Name, Price = @Price WHERE ProductId = @Id; […]
Need running totals, rankings, or moving averages? Window functions do it in one query without complex self-joins or cursors. The Old Painful Way – Self-Join: — Calculate running total of sales SELECT o1.OrderDate, o1.Amount, (SELECT SUM(o2.Amount) FROM Orders o2 WHERE o2.OrderDate
Creating a controller, action method, and routing just to return simple JSON? Minimal APIs in .NET 6+ let you define endpoints in 3 lines. Traditional Controller Way: [ApiController] [Route(“api/[controller]”)] public class ProductsController : ControllerBase { private readonly IProductService _productService; public ProductsController(IProductService productService) { _productService = productService; } [HttpGet] public async Task GetAll() { var products […]
Hitting database for same data 1000 times per second? IMemoryCache stores frequently-accessed data in RAM for instant access. Setup: // Program.cs or Startup.cs builder.Services.AddMemoryCache(); Basic Usage: public class ProductService { private readonly IMemoryCache _cache; private readonly ApplicationDbContext _db; public ProductService(IMemoryCache cache, ApplicationDbContext db) { _cache = cache; _db = db; } public async Task GetProductAsync(int […]
Accidentally committed API keys or passwords? Deleting the file in a new commit doesn’t remove it from history. Here’s how to purge it completely. ⚠️ The Problem: # You committed config.json with API key git add config.json git commit -m “Add config” git push # Then realized mistake and deleted it git rm config.json git […]
Committed too early or to wrong branch? Here’s how to undo commits without losing your work, depending on whether you’ve pushed or not. Scenario 1: Undo Last Commit (Not Pushed Yet) # Keep changes in working directory (most common) git reset –soft HEAD~1 # Now your changes are uncommitted, ready to re-commit # Use case: […]
Network hiccups causing failed API requests? Axios interceptors can automatically retry failed requests before showing errors to users. Install Axios: npm install axios The Basic Retry Interceptor: import axios from ‘axios’; // Configure retry axios.interceptors.response.use( response => response, // Success – return as is async error => { const config = error.config; // If no […]
Your app crashes with “Cannot read property ‘name’ of undefined”? Optional chaining (?.) safely accesses nested properties without try-catch blocks. The Error-Prone Old Way: const user = getUserData(); // Might return null // ❌ This crashes if user is null/undefined const name = user.profile.name; // TypeError: Cannot read property ‘profile’ of undefined // ❌ Traditional […]
Serving same 4K image to mobile users? Picture element lets you serve different images per device, saving 80% bandwidth and loading 3x faster. The Old Way – One Image for All: <img src=”hero-4k.jpg” alt=”Hero” /> <!– Problems: – Mobile downloads 5MB 4K image – Only displays 800px wide on phone – Wasted 80% of bandwidth […]
Loading spinners look outdated. Modern sites use skeleton screens that show content placeholders while data loads. Pure CSS, no libraries needed. The Basic Skeleton: .skeleton { background: linear-gradient( 90deg, #f0f0f0 25%, #e0e0e0 50%, #f0f0f0 75% ); background-size: 200% 100%; animation: loading 1.5s infinite; border-radius: 4px; } @keyframes loading { 0% { background-position: 200% 0; } […]
Tired of the simplified Windows 11 right-click menu that hides all useful options behind “Show more options”? Get the full Windows 10 menu back. The Problem: Windows 11 right-click menu shows: – Cut, Copy, Paste – Rename, Delete – “Show more options” → Opens full menu Extra click needed for: – Send to – Open […]
Start Menu searches taking 5 seconds because Windows is searching Bing? Disable web search to get instant local file/app results. The Annoying Problem: You type “calc” in Start Menu Windows searches: 1. Local apps (0.1 seconds) 2. Bing web search (5 seconds loading…) 3. Shows web results you don’t want Result: 5 second delay just […]
Signing a lease, employment contract, or service agreement? AI can highlight hidden fees, unfair clauses, and red flags you might miss. The Contract Analysis Prompt: I need help analyzing a legal contract before signing. **Document Type:** [e.g., Apartment Lease, Employment Contract, Service Agreement, Phone Plan] **Full Contract Text:** [Paste entire contract here] **What I Need:** […]
Found the perfect recipe but you’re vegan, gluten-free, or missing half the ingredients? AI can adapt any recipe to your needs while keeping it delicious. The Recipe Adaptation Prompt: I need help adapting a recipe to my dietary needs and available ingredients. **Original Recipe:** [Paste entire recipe here – ingredients and instructions] **Dietary Restrictions:** [e.g., […]
Strange noise from your HVAC? Leak under the sink? Use AI to diagnose and get repair instructions without calling an expensive technician. The Diagnostic Prompt Template: I need help diagnosing and fixing a home repair issue. **The Problem:** [Describe what’s wrong: noise, leak, not working, etc.] **Location:** [Where: kitchen sink, basement furnace, bedroom ceiling, etc.] […]
Docker eating 50GB of disk space? Old images, stopped containers, and dangling volumes pile up fast. One command reclaims it all. Check Current Disk Usage: docker system df # Output: TYPE TOTAL ACTIVE SIZE RECLAIMABLE Images 47 12 28.5GB 18.2GB (63%) Containers 89 5 10.2GB 9.8GB (96%) Local Volumes 23 8 2.3GB 1.1GB (47%) Build […]
Pod stuck in “Terminating” state for hours? Kubernetes is waiting for graceful shutdown that will never complete. Force delete it properly. The Problem: # Pod stuck forever kubectl get pods NAME STATUS AGE stuck-pod-abc123 Terminating 3h # Normal delete doesn’t work kubectl delete pod stuck-pod-abc123 # Still shows Terminating… Why Pods Get Stuck: When deleting […]
Brute force bots hammering wp-login.php with 1000s of password attempts? Block them at Apache level before they even reach WordPress. The Plugin-Free Solution: Add to .htaccess in WordPress root: # Limit wp-login.php access to specific IPs <Files wp-login.php> Order Deny,Allow Deny from all Allow from YOUR_IP_ADDRESS Allow from YOUR_OFFICE_IP </Files> Replace YOUR_IP_ADDRESS with your actual […]
WordPress admin panel sluggish and using 100% CPU? The Heartbeat API polls your server every 15 seconds for autosave and notifications, eating resources. What Heartbeat Does: Every 15 seconds: – Check for new comments – Check for plugin updates – Autosave post drafts – Notify about other users editing same post – Trigger scheduled tasks […]
Scaled or rotated text looks blurry and pixelated? Photoshop’s transform interpolation is set wrong. One checkbox fixes it permanently. The Blurry Text Problem: 1. Create text layer 2. Ctrl+T to transform 3. Scale up 200% 4. Text looks jagged and blurry Why? Photoshop is treating vector text like pixels! The Permanent Fix: Edit → Preferences […]
Need to resize hundreds of images for web? Skip the tedious Actions panel – Image Processor is faster and requires zero setup. The Old Tedious Way: 1. Create Action 2. Record resize steps 3. File → Automate → Batch 4. Configure 10+ settings 5. Hope it works = 10 minutes setup + easy to mess […]
Debugging your code but accidentally stepping into framework methods like String.Format() or Linq internals? This wastes precious debugging time. The Annoying Problem: var users = GetUsers(); var result = users.Where(u => u.IsActive).ToList(); // Press F11 here // Debugger jumps into: // → Enumerable.cs (framework code) // → Buffer.cs // → List.cs // You just wanted […]