Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
⚡ Logging Without String Allocation Interpolation allocates strings even if log level is off. Custom interpolated string handlers defer formatting until needed. 📝 Custom Handler [InterpolatedStringHandler] public ref struct DebugLogHandler { private readonly bool _enabled; private StringBuilder? _builder; public DebugLogHandler(int literalLength, int formattedCount, bool enabled, out bool shouldAppend) { _enabled = enabled; shouldAppend = enabled; […]
🔍 Know Which Argument Caused the Error ArgumentNullException with parameter name is good. CallerArgumentExpression shows the actual expression. Even better for complex validations. ❌ Standard Validation public void Process(string data) { if (data == null) throw new ArgumentNullException(nameof(data)); } // Exception: Parameter name: data ✅ CallerArgumentExpression static void GuardNotNull(object value, [CallerArgumentExpression(“value”)] string expr = null) […]
🌳 Org Charts, Categories, Comment Threads Self-joins are messy. Recursive CTEs query parent-child relationships elegantly. Get entire organization tree in one query. 📝 Employee Hierarchy WITH RECURSIVE org_tree AS ( — Anchor: top-level managers SELECT id, name, manager_id, 0 as level, name as path FROM employees WHERE manager_id IS NULL UNION ALL — Recursive: employees […]
📦 One EXE, No Runtime, Instant Start .NET apps need runtime installed. Native AOT compiles to single native executable. Works on machines without .NET. 10ms startup. 🔧 Enable Native AOT <Project Sdk=”Microsoft.NET.Sdk”> <PropertyGroup> <OutputType>Exe</OutputType> <TargetFramework>net8.0</TargetFramework> <PublishAot>true</PublishAot> </PropertyGroup> </Project> # Publish command dotnet publish -c Release -r win-x64 –self-contained # Output: single .exe file (~10-30MB) 🎯 […]
📦 Which Stash Had That Code? Forgot what’s in stash @{3}? git stash show reveals changes. Preview before applying. 📝 Basic Show # Show latest stash (summary) git stash show # Show latest stash (full diff) git stash show -p # Show specific stash git stash show stash@{2} git stash show -p stash@{2} # Show […]
⚡ Hero Image > Analytics Script Browsers guess priority. They’re often wrong. Priority Hints (fetchpriority) tell browser exactly what’s important. Faster LCP, better UX. 📝 Basic Priority Hints <!– High priority (hero image, main content) –> <img src=”hero.jpg” fetchpriority=”high”> <link rel=”preload” href=”font.woff2″ as=”font” fetchpriority=”high”> <!– Low priority (below fold, analytics) –> <img src=”footer-logo.png” fetchpriority=”low”> <script […]
🗑️ Know When Objects Are Garbage Collected WeakMap is known. WeakRef and FinalizationRegistry give advanced memory management. Cache cleanup, resource release, memory leak detection. 📝 WeakRef Example let obj = { data: ‘important’ }; const weakRef = new WeakRef(obj); // Later, obj might be garbage collected obj = null; // Check if still alive const […]
📜 Animation Tied to Scroll Position Scroll-triggered animations needed JavaScript. Scroll-driven animations are pure CSS. Progress bar, reveal on scroll, parallax — all native. 📝 Basic Scroll Progress /* Progress bar that fills as you scroll */ @keyframes grow-progress { from { transform: scaleX(0); } to { transform: scaleX(1); } } .progress-bar { position: fixed; […]
📸 Record Screen Steps Automatically ‘It doesn’t work’ isn’t helpful. Steps Recorder captures every click, keystroke, and screen. Perfect for IT tickets, bug reports, user training. 🔧 Start Steps Recorder Start → Steps Recorder (or “psr”) Alternative: Win + R → psr → Enter Buttons: – Start Record (Ctrl + Shift + R) – Stop […]
📝 Write Better Reviews, Faster Performance reviews are hard to write. AI generates review comments from metrics, achievements, and feedback. Professional, balanced, specific. 📝 The Prompt Write a performance review for an employee with the following data: Role: [Software Engineer / Product Manager / Designer] Tenure: [6 months / 2 years / etc.] Key achievements: […]
📁 No Helm. No Templating. Pure YAML. Helm templates are complex. Kustomize is built into kubectl. Overlay configs for dev, staging, prod. No new syntax to learn. 📁 Folder Structure k8s/ ├── base/ │ ├── deployment.yaml │ ├── service.yaml │ └── kustomization.yaml └── overlays/ ├── dev/ │ ├── replica_count.yaml │ ├── configmap.yaml │ └── kustomization.yaml […]
🔌 Actions Do Something. Filters Change Something. Both hooks, but different purposes. Actions execute code. Filters modify data. Knowing the difference saves hours of debugging. ⚡ Action Hook // Do something (no return value) add_action(‘wp_head’, ‘add_google_analytics’); function add_google_analytics() { echo ‘<script>// GA code</script>’; } // do_action() executes callbacks // Returns nothing, just runs 🔄 Filter […]
🎨 Magic Wand on Steroids Magic Wand selects contiguous pixels. Color Range selects ALL pixels matching a color, anywhere in image. Perfect for removing backgrounds, color correction. 📝 How to Use Select → Color Range Sampled Colors: (dropdown) – Sampled Colors: Use eyedropper to pick color – Reds / Yellows / Greens / Cyans / […]
📋 Copy File Path Without Opening Properties Need to share file location? Copy path? Shift + Right Click reveals hidden context menu items. Copy as path, copy full path, open in terminal. ⌨️ Hidden Shortcut Normal right-click: – Open – Open With – Copy (Ctrl+C) Shift + Right Click: – Copy as path – Copy […]
📋 Match Arrays Like Prolog Match first element, last element, empty list — all with pattern matching. List patterns make array processing declarative. 📝 Basic Patterns int[] numbers = [1, 2, 3, 4, 5]; // Match first two elements if (numbers is [1, 2, ..]) { Console.WriteLine(“Starts with 1,2”); } // Match last two elements […]
🧮 One Algorithm, Any Number Type Sum() works on int, double, decimal? Not before. Generic math lets you write math algorithms once for all numeric types. ❌ Before (Duplicated Code) int Sum(int[] numbers) { int total = 0; foreach (var n in numbers) total += n; return total; } double Sum(double[] numbers) { double total […]
📊 NoSQL in SQL, Best of Both Worlds Store flexible data as JSON. Query inside JSON. Index specific fields. PostgreSQL JSON functions give you relational + document database. 📝 Store and Query JSON CREATE TABLE products ( id SERIAL PRIMARY KEY, name TEXT, metadata JSONB ); INSERT INTO products (name, metadata) VALUES (‘Laptop’, ‘{“brand”: “Apple”, […]
⚙️ Write Code That Writes Code Reflection is slow. Source generators run at compile time. Generate JSON serializers, INotifyPropertyChanged, mappers — zero runtime overhead. 📝 Simple Source Generator [Generator] public class HelloWorldGenerator : ISourceGenerator { public void Initialize(GeneratorInitializationContext context) { } public void Execute(GeneratorExecutionContext context) { string source = @” namespace Generated { public static […]
🔍 Binary Search Through Git History Bug appeared sometime. Which commit? Git bisect does binary search through commits. Find culprit in O(log n) steps. 🔧 Manual Bisect # Start bisect git bisect start # Mark current commit as bad (bug exists) git bisect bad # Mark a known good commit (no bug) git bisect good […]
🛑 Stop Slow Requests When User Navigates User typed new search term? Old request still running. AbortController cancels fetch. Save bandwidth, avoid race conditions. 📝 Basic Usage const controller = new AbortController(); const signal = controller.signal; // Start request fetch(‘/api/search’, { signal }) .then(response => response.json()) .then(data => console.log(data)) .catch(err => { if (err.name === […]
ℹ️ Know Your Module’s URL, Resolve Paths Need to load assets relative to current file? import.meta gives you module URL, hot reload status, and more. 📝 import.meta.url // main.js console.log(import.meta.url); // “file:///C:/project/src/main.js” (Node.js) // “https://example.com/js/main.js” (browser) // Get directory of current module const modulePath = new URL(‘.’, import.meta.url).pathname; // Load sibling file dynamically const data […]
🚫 Make Content Unclickable, Unfocusable, Invisible to Screen Readers Modal open? Background content should be ignored. inert attribute disables everything inside. 📝 Basic Usage <!– Main content with modal open –> <main inert> <button>Can’t click me!</button> <a href=”#”>Can’t focus me!</a> <input placeholder=”Can’t type here”> </main> <div class=”modal”> <h2>This is accessible</h2> <button onclick=”closeModal()”>Close</button> </div> <script> function […]
📦 One Font File, Infinite Styles Normal fonts need separate files for each weight (400, 700). Variable fonts contain all weights in one file. Smaller total size, smoother transitions. 📝 Using Variable Fonts @font-face { font-family: ‘InterVariable’; src: url(‘InterVariable.woff2’) format(‘woff2’); font-weight: 100 900; /* Range of weights */ font-stretch: 75% 125%; /* Optional width range […]
📡 Send Files Without USB, Email, or Cloud Need to send a file to the computer next to you? Nearby Sharing uses Bluetooth + Wi-Fi. Like Airdrop for Windows. 🔧 Enable Nearby Sharing Settings → System → Nearby sharing → On Choose: – Everyone nearby (anyone with Bluetooth) – My devices only (same Microsoft account) […]
🔄 Convert Python to C#, Java to TypeScript Rewriting code manually is slow and error-prone. AI translates between languages preserving logic, edge cases, and structure. 📝 The Prompt Migrate the following code from [Source Language] to [Target Language]: [Paste source code here] Requirements: 1. Preserve exact logic and edge case handling 2. Use idiomatic patterns […]
🏷️ Who Built This Image? When? Why? Image tags tell version. But who built it? Git commit? Labels add metadata. Filter images by label. Audit trail built-in. 📝 Add Labels in Dockerfile FROM node:18-alpine LABEL maintainer=”team@example.com” LABEL version=”1.2.3″ LABEL build-date=”2024-01-15″ LABEL git-commit=”a1b2c3d” LABEL description=”API service for user management” LABEL org.opencontainers.image.source=”https://github.com/example/repo” LABEL org.opencontainers.image.licenses=”MIT” # Multi-line labels […]
🗺️ Spread Pods Across Zones, Nodes, Racks All pods on same node? Node failure = downtime. Topology spread constraints spread pods evenly across zones, nodes, or custom domains. 📝 Pod Topology Spread apiVersion: apps/v1 kind: Deployment metadata: name: myapp spec: replicas: 6 template: spec: topologySpreadConstraints: – maxSkew: 1 topologyKey: kubernetes.io/hostname whenUnsatisfiable: DoNotSchedule labelSelector: matchLabels: app: […]
admin_url(‘admin-ajax.php’), ‘nonce’ => wp_create_nonce(‘my_nonce’) )); } add_action(‘wp_enqueue_scripts’, ‘my_theme_assets’); 🎯 Conditional Loading // Only on single post pages if (is_single()) { wp_enqueue_script(‘post-specific’, ‘…’); } // Only on contact page if (is_page(‘contact’)) { wp_enqueue_script(‘google-maps’, ‘https://maps.googleapis.com/…’); } // Only for logged-in users if (is_user_logged_in()) { wp_enqueue_script(‘logged-in’, ‘…’); } // Deregister unused scripts (performance) wp_deregister_script(‘wp-embed’); wp_dequeue_style(‘wp-block-library’); 💡 Best Practices […]