Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
🔤 $”Hello {name}” is Magic String concatenation is messy. String interpolation ($”) embeds variables directly. More readable, fewer bugs. ❌ Concatenation string message = “Hello, ” + name + “! You are ” + age + ” years old.”; string sql = “SELECT * FROM users WHERE id = ” + userId; string html = […]
📦 out parameters are clunky. Tuples are elegant. Need to return multiple values? Tuples return multiple values without creating a class. Named fields, deconstruction, lightweight. ❌ Out Parameters public void GetUser(int id, out string name, out int age) { name = “Alice”; age = 30; } // Usage GetUser(1, out var name, out var age); […]
🔄 Replace NULL with Default, or Replace Value with NULL ISNULL replaces NULL with default. NULLIF replaces value with NULL. Perfect for data cleaning, division by zero, optional fields. 📝 ISNULL (SQL Server) / IFNULL (MySQL) / COALESCE (Portable) — SQL Server SELECT ISNULL(phone, ‘No phone’) as contact FROM users; — MySQL SELECT IFNULL(phone, ‘No […]
✅ Validate Models with Attributes, Not If Statements Manual validation is tedious. Data Annotations validate automatically. Clean models, automatic error messages. 📝 Common Attributes public class User { [Required(ErrorMessage = “Name is required”)] [StringLength(100, MinimumLength = 2)] public string Name { get; set; } [Required] [EmailAddress] public string Email { get; set; } [Range(18, 99)] […]
🗑️ Delete Temporary Files Cluttering Your Workspace Build artifacts, logs, temp files — not in .gitignore yet. git clean removes untracked files. Clean workspace, fresh start. 📝 Basic Clean # Preview what would be deleted (dry run) git clean -n # Delete untracked files (not folders) git clean -f # Delete untracked files and folders […]
📋 API Keys, Auth Tokens, Custom Headers Some APIs require custom headers. Headers option in fetch adds them. Authentication, content type, custom metadata. 📝 Adding Headers // Basic headers const response = await fetch(‘/api/data’, { headers: { ‘Content-Type’: ‘application/json’, ‘Accept’: ‘application/json’ } }); // Authentication token const token = ‘your-jwt-token’; await fetch(‘/api/protected’, { headers: { […]
📊 console.log() is Messy for Arrays Array of objects logs as expandable tree. console.table() displays as formatted table. Much easier to read. 📝 Basic Usage const users = [ { id: 1, name: ‘Alice’, email: ‘alice@example.com’ }, { id: 2, name: ‘Bob’, email: ‘bob@example.com’ }, { id: 3, name: ‘Charlie’, email: ‘charlie@example.com’ } ]; console.table(users); […]
✍️ Red Squiggly Lines in Your Textarea Textareas don’t spell-check by default. spellcheck attribute enables browser spell checking. Better user-generated content. 📝 Basic Usage <!– Enable spell check –> <textarea spellcheck=”true” rows=”5″ cols=”50″></textarea> <input type=”text” spellcheck=”true”> <!– Disable spell check –> <input type=”text” spellcheck=”false”> <!– For code editors (disable spell check) –> <textarea class=”code-editor” spellcheck=”false”>function […]
🚫 Stop Users from Selecting UI Elements Double-clicking button selects text. Dragging mouse selects UI labels. user-select prevents accidental selection. Better UX. 📝 Basic Usage /* Prevent selection on entire app */ body { user-select: none; } /* Allow selection on specific elements */ .content { user-select: text; } /* Buttons and UI elements */ […]
📸 Win + Shift + S = Best Screenshot Shortcut Print Screen captures entire screen. Win + Shift + S opens snipping toolbar. Select area, copy to clipboard, paste anywhere. 📝 Modes Win + Shift + S Toolbar options: – Rectangular snip (default) – Freeform snip (draw custom shape) – Window snip (capture specific window) […]
🍳 “What can I cook with chicken, rice, and bell peppers?” Don’t know what to cook with ingredients on hand? AI generates recipes from your ingredients. No more food waste. 📝 The Prompt I have these ingredients: [list your ingredients here] I also have basic pantry items: salt, pepper, oil, butter, flour, sugar, eggs, milk. […]
💾 Made Changes Inside Container? Save Them! You debugged inside container. Installed packages. Now you want to save it. docker commit creates image from running container. 📝 Basic Commit # Start container docker run -it ubuntu bash # Inside container: install packages apt-get update apt-get install -y nginx # Exit (Ctrl+D or exit) # Commit […]
📁 Virtual Clusters Inside One Physical Cluster All pods in default namespace? Chaos. Namespaces separate environments, teams, or components. Resource quotas, RBAC per namespace. 📝 Create and Use Namespaces # Create namespace kubectl create namespace development kubectl create namespace staging kubectl create namespace production # List namespaces kubectl get namespaces # Run pod in specific […]
👥 Never Give Admin to Everyone Admin has all powers. User roles limit access. Editor writes, Author edits own, Subscriber reads only. Least privilege principle. 📝 Default Roles Administrator: – Full control over site – Add/delete users, install plugins, edit themes – Risk: Can break everything Editor: – Publish and manage all posts/pages – Moderate […]
🎨 Make All Your Photos Look Like They Were Shot Together Different lighting, different cameras. Match Color transfers color palette from one image to another. Perfect for photo series, product shots. 📝 How to Use 1. Open source image (with desired colors) 2. Open target image (to be adjusted) 3. Select target image 4. Image […]
☁️ Your VS Settings Everywhere Theme, keyboard shortcuts, extensions — setting up a new PC takes hours. VS Settings Sync roams everything. Sign in, done. 🔧 Enable Sync 1. File → Account Settings 2. Sign in with Microsoft account 3. Tools → Options → Environment → Accounts 4. Check “Synchronize settings across devices” What syncs: […]
➡️ switch expression is an expression, not a statement Switch statements are verbose. Switch expressions return values. Less code, fewer bugs, no fall-through. ❌ Switch Statement string GetGrade(int score) { string grade; switch (score) { case >= 90: grade = “A”; break; case >= 80: grade = “B”; break; default: grade = “F”; break; } […]
📏 arr[^1] is Last Element. arr[1..3] is Range. arr[arr.Length – 1] is verbose. ^ operator indexes from end. .. operator creates ranges. Python-like slicing in C#. ❌ Old Way var last = arr[arr.Length – 1]; var secondLast = arr[arr.Length – 2]; var slice = arr.Skip(1).Take(3).ToArray(); ✅ Index and Range var last = arr[^1]; var secondLast […]
📋 COALESCE is NVL2, ISNULL, and IFNULL Combined Need first non-null value? COALESCE takes multiple arguments, returns first non-null. Works across all databases. 📝 Basic COALESCE — Return first non-null SELECT COALESCE(null, null, ‘first’, ‘second’); — Returns ‘first’ SELECT COALESCE(phone, mobile, email, ‘No contact’); — Returns phone if not null, else mobile, else email, else […]
⚡ 70% Smaller Responses, Same Content JSON responses are text. Text compresses well. Response compression GZIPs responses automatically. Faster downloads, less bandwidth. 📝 Enable Compression // Program.cs builder.Services.AddResponseCompression(options => { options.EnableForHttps = true; options.Providers.Add(); options.Providers.Add(); options.MimeTypes = ResponseCompressionDefaults.MimeTypes.Concat( new[] { “application/json”, “text/plain” } ); }); builder.Services.Configure(options => { options.Level = CompressionLevel.Optimal; // Fastest, Optimal, NoCompression […]
🍒 Need One Commit from Another Branch? Merge brings all commits. Sometimes you need just one. Cherry-pick applies specific commits to current branch. 📝 Basic Cherry-Pick # Switch to target branch git checkout main # Cherry-pick a commit from feature branch git cherry-pick a1b2c3d # Cherry-pick multiple commits git cherry-pick a1b2c3d d4e5f6g g7h8i9j # Cherry-pick […]
📄 Download Files via AJAX Fetch JSON is common. What about images? PDFs? ZIPs? Blob responses handle binary data. Create download links dynamically. 📝 Download Image async function downloadImage(url) { const response = await fetch(url); const blob = await response.blob(); const imageUrl = URL.createObjectURL(blob); const img = document.createElement(‘img’); img.src = imageUrl; document.body.appendChild(img); // Clean up […]
|| treats 0, ”, false as falsy. ?? only checks null/undefined. Default values with || break when value is 0. Nullish coalescing (??) fixes this. Use ?? for default values. ❌ || (Bug with 0) const volume = userVolume || 50; // If userVolume = 0 → volume = 50 (WRONG!) const name = userName […]
⌨️ User Can Type Immediately Search page? Login form? User must click input first. autofocus selects input automatically. One less click. 📝 Basic Usage <!– Search page –> <input type=”search” name=”q” autofocus placeholder=”Search…” “> <!– Login page –> <input type=”email” name=”email” autofocus placeholder=”Email”> <!– Modal dialog –> <input type=”text” name=”name” autofocus> <!– Works on any […]
📜 Instant Jump is Jarring. Smooth is Better. Anchor links jump instantly. scroll-behavior: smooth animates scrolling. Better UX, no JavaScript. 📝 Basic Usage /* Apply to entire page */ html { scroll-behavior: smooth; } /* Apply only to specific container */ .scroll-container { scroll-behavior: smooth; overflow-y: auto; height: 400px; } /* HTML structure */ <a […]
😊 Emojis, Kaomoji, Symbols, GIFs — One Shortcut Need a copyright symbol? An emoji? A GIF? Win + . (period) opens emoji panel everywhere. Browsers, documents, code editors. 📝 What’s Inside Win + . or Win + ; Tabs: – 😊 Emojis (smileys, people, animals, food, activities) – 🀆 Kaomoji (Japanese text emoticons) (◕‿◕) – […]
✉️ Turn Bullet Points into Professional Emails Don’t know how to phrase that email? AI writes professional emails from your bullet points. Different tones, styles, lengths. 📝 The Prompt Write a professional email with these key points: [Subject]: [email subject] Key points to cover: – [Point 1] – [Point 2] – [Point 3] Recipient: [Colleague […]
📝 Log to stdout/stderr, Not Files Log files inside container fill disk. Container restarts lose logs. Docker captures stdout/stderr. Use docker logs. ✅ Good vs Bad // ❌ BAD: Writing to file File.WriteAllText(“/app/logs/app.log”, message); // ✅ GOOD: Console output Console.WriteLine(message); // ❌ BAD: Log4Net to file // ✅ GOOD: Serilog to Console // Docker command […]
⚙️ No Requests = Unpredictable Scheduling Without resource requests, pods can starve others. Requests and limits ensure fair sharing and prevent resource exhaustion. 📝 Setting Resources apiVersion: v1 kind: Pod metadata: name: myapp spec: containers: – name: app image: myapp:latest resources: requests: memory: “256Mi” cpu: “250m” limits: memory: “512Mi” cpu: “500m” # CPU units: 1000m […]
📡 WordPress has Built-in RSS Feeds for Everything Display posts on other sites, newsletters, or mobile apps. WordPress RSS feeds are ready to use. No plugins needed. 📝 Feed URLs # Main feed (latest 10 posts) https://yoursite.com/feed/ # Category feed https://yoursite.com/category/news/feed/ # Tag feed https://yoursite.com/tag/wordpress/feed/ # Author feed https://yoursite.com/author/admin/feed/ # Search feed https://yoursite.com/?s=keyword&feed=rss2 # Comments […]