Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
🚫 Dedicated Nodes for Special Workloads Some nodes have GPUs. Some are spot instances. Taints repel pods. Tolerations allow them. Control exactly where workloads run. 📝 Add Taint to Node # Taint effects: # NoSchedule: Pods without toleration won’t be scheduled # PreferNoSchedule: Avoid if possible # NoExecute: Evict existing pods without toleration # Add […]
⚡ 80% of Options Load on Every Page WordPress loads all ‘autoload’ options on every request. Many are never used. Clean your autoloaded options for faster admin. 📝 Check Autoloaded Options — SQL Query to see autoloaded options SELECT COUNT(*), SUM(LENGTH(option_value)) as total_size FROM wp_options WHERE autoload = ‘yes’; — List largest autoloaded options SELECT […]
🎨 Copy Pixels from Anywhere Remove blemishes, duplicate objects, fix textures. Clone Stamp copies from one area and paints to another. Essential for retouching. ⌨️ Shortcuts S → Select Clone Stamp Alt+Click → Set source point [ / ] → Decrease/Increase brush size Shift+[ / ] → Decrease/Increase brush hardness Alt+Shift+Click → Set source from […]
🎯 Break Once, Then Vanish Need to inspect a value just once? Regular breakpoint pauses every time. Temporary breakpoints delete themselves after first hit. Perfect for one-time inspections. 🔧 How to Create Method 1: Right-click breakpoint → Conditions → Check “Remove breakpoint when hit” Method 2: Hover over red breakpoint dot → Settings gear → […]
📅 Date Without Time. Time Without Date. Birthday has no time. Alarm has no date. DateOnly and TimeOnly prevent bugs from midnight times, time zones, and meaningless components. 📝 DateOnly Examples // Create DateOnly DateOnly birthday = new DateOnly(1990, 5, 15); DateOnly today = DateOnly.FromDateTime(DateTime.Today); // Parse DateOnly parsed = DateOnly.Parse(“2024-12-25”); // Operations DateOnly tomorrow […]
📍 Know Who Called You Logging without caller info is useless. Caller Info Attributes give you file path, line number, member name — at compile time. Zero performance cost. 📝 Basic Usage using System.Runtime.CompilerServices; public static void Log(string message, [CallerFilePath] string file = “”, [CallerLineNumber] int line = 0, [CallerMemberName] string member = “”) { […]
🌳 Self-Joins Are Painful. CTE Makes It Easy. Org charts, categories, comments, folder trees — all hierarchical. Recursive CTEs query parent-child relationships elegantly. 📝 Employee Hierarchy — Table structure CREATE TABLE employees ( id INT PRIMARY KEY, name VARCHAR(100), manager_id INT REFERENCES employees(id) ); — Recursive CTE to get org tree WITH RECURSIVE org_tree AS […]
📋 RFC 7807 Standard Errors Every API invents its own error format. Problem Details (RFC 7807) standardizes HTTP error responses. Clients understand errors universally. 📝 Enable Problem Details // Program.cs builder.Services.AddProblemDetails(); var app = builder.Build(); app.UseStatusCodePages(); // or app.UseProblemDetails(); // More control // Now 404, 400, 500 errors return RFC 7807 format 🎯 Custom Problem […]
🌲 Multiple Checkouts, One Repository Need to compare main vs feature branch? Stash not enough? git worktree checks out multiple branches simultaneously. No switching, no stashing. 📝 Basic Worktree # Create worktree for feature branch git worktree add ../project-feature feature-branch # Now you have: # /project (main branch) # /project-feature (feature-branch) # Open both in […]
📡 Track User Actions Even When They Leave fetch() on page unload gets cancelled. sendBeacon() sends data asynchronously, survives page close. Perfect for analytics, logging, exit tracking. 📝 Basic Usage // Track page unload window.addEventListener(‘beforeunload’, () => { const data = { event: ‘page_exit’, timeOnPage: performance.now(), url: window.location.href }; const blob = new Blob([JSON.stringify(data)], {type: […]
📦 Finally, True Deep Copy Without Libraries JSON.parse(JSON.stringify()) fails with dates, undefined, functions. structuredClone() handles dates, maps, sets, arrays, nested objects — everything. ❌ JSON Hack (Broken) const obj = { date: new Date(), fn: () => {}, undef: undefined }; const copy = JSON.parse(JSON.stringify(obj)); // date becomes string! // fn and undef are gone! […]
📥 Click to Download, Not to Preview PDF opens in browser. Image displays. User right-clicks, “Save as”. download attribute forces download with custom filename. 📝 Basic Usage <!– Download with original filename –> <a href=”/files/report.pdf” download>Download PDF</a> <!– Download with custom filename –> <a href=”/files/report.pdf” download=”Q4_Report_2024.pdf”> Download PDF </a> <!– Image download –> <a href=”image.jpg” […]
📱 Native Scroll Snap — No JavaScript Horizontal carousels, full-page scroll, image galleries — all with CSS scroll snap. No JS, smooth physics, works everywhere. 📝 Full-Page Vertical Scroll Snap .container { scroll-snap-type: y mandatory; overflow-y: scroll; height: 100vh; } .section { scroll-snap-align: start; height: 100vh; } /* HTML structure */ <div class=”container”> <section class=”section”>Page […]
👑 All Control Panels, One Folder Settings scattered everywhere. God Mode creates a folder with EVERY setting. Administrative Tools, Ease of Access, Network, Personalization — all in one place. 🔧 Create God Mode Folder 1. Right-click on Desktop 2. New → Folder 3. Rename folder to: GodMode.{ED7BA470-8E54-465E-825C-99712043E01C} 4. Press Enter 5. Double-click folder → Contains […]
💻 “Find all files modified yesterday” → Terminal Command Can’t remember sed syntax? Awk? Grep flags? AI translates English to shell commands. Stop Googling, start doing. 📝 The Prompt Generate a terminal command (bash/zsh) for: [Describe what you want to do] Requirements: – Use safe flags (no destructive commands unless specified) – Include explanation of […]
⚡ Parallel Builds = 2x Faster Old Docker builds run sequentially. BuildKit runs independent stages in parallel. Skipping unused stages. Secret mount without layers. Game changer. 🔧 Enable BuildKit # Environment variable export DOCKER_BUILDKIT=1 docker build . # Or always enable (add to ~/.docker/config.json) { “auth”: { … }, “features”: { “buildkit”: true } } […]
🛡️ Don’t Drain All Pods at Once Node draining, cluster upgrades, autoscaling down — they all kill pods. PodDisruptionBudget ensures minimum availability during voluntary disruptions. 📝 PDB Examples # At least 2 pods available at all times apiVersion: policy/v1 kind: PodDisruptionBudget metadata: name: app-pdb spec: minAvailable: 2 selector: matchLabels: app: myapp # No more than […]
❤️ Your Admin Is Making Unnecessary Requests WordPress Heartbeat API pings server every 15-60 seconds. On high-traffic admin, this kills performance. Control or disable it. 📝 Reduce Heartbeat Frequency // functions.php add_filter(‘heartbeat_settings’, ‘custom_heartbeat_settings’); function custom_heartbeat_settings($settings) { $settings[‘interval’] = 120; // Change to 120 seconds (default 15) return $settings; } // Disable completely on admin add_action(‘init’, […]
✨ Make Objects Disappear Tourist in background? Unwanted logo? Content-Aware Fill analyzes surrounding pixels and fills selection seamlessly. Like magic eraser. 📝 How To Use 1. Select object to remove (Lasso, Pen, Magic Wand) 2. Edit → Fill (Shift+F5) 3. In dialog: Contents → Content-Aware 4. Opacity: 100% 5. Click OK → Object disappears! For […]
👀 See Code Without Opening New Tabs F12 opens new tab, breaks flow. Alt+F12 (Peek Definition) shows code inline. Edit, navigate, close with Esc. Stay in context. ⌨️ Shortcuts Alt+F12 → Peek Definition (inline view) Shift+Alt+F12 → Peek References (where method is used) Ctrl+Alt+F12 → Peek to Implementation (interfaces) Within peek window: Ctrl+Alt+Home → Promote […]
📦 One .exe, No Runtime Required .NET app needs runtime installed. Native AOT compiles to single native executable. Fast startup, small container size, no .NET on target machine. 🔧 Enable Native AOT <PropertyGroup> <PublishAot>true</PublishAot> </PropertyGroup> <PropertyGroup> <TargetFramework>net8.0</TargetFramework> <PublishAot>true</PublishAot> <JsonSerializerIsReflectionEnabledByDefault>false</JsonSerializerIsReflectionEnabledByDefault> <TrimMode>full</TrimMode> </PropertyGroup> ⚙️ Publish Command # Windows (x64) dotnet publish -c Release -r win-x64 –self-contained -p:PublishAot=true […]
⚡ Zero-Allocation Slicing Span<T> gives a view into memory without copying. No allocations, no GC pressure. Ideal for parsing, string manipulation, and high-performance scenarios. ❌ Allocating Substring // Allocates new string (GC pressure) string data = “123,456,789”; string first = data.Substring(0, 3); // New string allocation string second = data.Substring(4, 3); // Another allocation // […]
🎯 Index Only What You Query Full indexes waste space. Partial indexes index only rows matching a WHERE clause. Smaller, faster, more efficient. 📝 Basic Partial Index — Index only active users (not soft-deleted) CREATE INDEX idx_active_users_email ON users(email) WHERE deleted_at IS NULL; — Query uses this index automatically SELECT * FROM users WHERE email […]
🔄 Order of Registration = Order of Execution Wrong middleware order = broken app. Auth before Routing? Exception handling after everything? Order matters dramatically. ✅ Correct Order (Recommended) var app = builder.Build(); // 1. Exception handling (catch errors from everything) if (app.Environment.IsDevelopment()) app.UseDeveloperExceptionPage(); else app.UseExceptionHandler(“/error”); // 2. Security (run early) app.UseHsts(); app.UseHttpsRedirection(); // 3. Static […]
🕰️ Git’s Time Machine Accidentally deleted branch? Reset –hard too far? Reflog logs every HEAD change. Rewind time, recover lost work. 📝 View Reflog # View all reflog entries git reflog # Output: # a1b2c3d HEAD@{0}: commit: Add feature # d4e5f6g HEAD@{1}: checkout: moving from main to feature # g7h8i9j HEAD@{2}: reset: moving to HEAD~2 […]
📁 Drag & Drop + Progress Bar, Native No more FormData polyfills. FormData API sends forms + files with fetch. Track upload progress, handle multiple files. 📝 Basic File Upload <input type=”file” id=”fileInput” multiple> <button onclick=”uploadFiles()”>Upload</button> <progress id=”progressBar” value=”0″ max=”100″></progress> async function uploadFiles() { const files = document.getElementById(‘fileInput’).files; const formData = new FormData(); for (let […]
⏰ Async Without Async Function Wrapper Need await at top level? Used to need IIFE. Top-level await works directly in ES modules. Cleaner initialization code. ❌ Old Way (IIFE) (async () => { const data = await fetch(‘/api/config’); const config = await data.json(); startApp(config); })(); ✅ Top-Level Await // In .mjs or type=”module” script const […]
📱 Built-in Modal, No Library <dialog> element creates native modals. Accessibility, focus management, backdrop — all built-in. No more 100KB modal libraries. 📝 Basic Dialog <dialog id=”myDialog”> <h2>Confirm Action</h2> <p>Are you sure you want to delete this item?</p> <form method=”dialog”> <button value=”cancel”>Cancel</button> <button value=”confirm”>Confirm</button> </form> </dialog> <button onclick=”myDialog.showModal()”>Open Modal</button> <script> myDialog.addEventListener(‘close’, () => { console.log(‘Closed […]
👨👧 Parent Finally Knows About Child CSS couldn’t select parent based on children. Until now. :has() changes everything — style parent when child exists. ❌ Before :has() // JavaScript needed if (card.querySelector(‘.badge’)) { card.classList.add(‘has-badge’); } ✅ With :has() // Pure CSS! .card:has(.badge) { border-left: 4px solid gold; } 🎯 Powerful Examples // Style form that […]
🧘 Built-In Pomodoro Timer Notifications, taskbar badges, flashing icons — all distractions. Focus Sessions silence everything, set timers, track productivity. 🔧 Start a Focus Session Method 1: Clock app → Focus Sessions Method 2: Taskbar clock/calendar → Focus Method 3: Settings → System → Focus Shortcut: Win + N → Focus ⚙️ Configure Do Not […]