Skip to content

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Author: ErcanOPAK

CSS

CSS Layouts Break on Large Screens Only

- 07.01.26 | 07.01.26 - ErcanOPAK comment on CSS Layouts Break on Large Screens Only

Mobile and desktop fine, ultrawide broken. WhyFixed max-width assumptions. Fix Use fluid containers with max-width limits instead of fixed layouts.

Read More
Windows

Windows 11 Laptop Battery Drains Fast While Idle

- 07.01.26 - ErcanOPAK comment on Windows 11 Laptop Battery Drains Fast While Idle

Screen off, battery gone. WhyModern standby keeps apps semi-active. Fix Limit background app permissions and disable unnecessary wake sources.

Read More
Windows

Windows 11 Feels Slower After Updates

- 07.01.26 - ErcanOPAK comment on Windows 11 Feels Slower After Updates

Nothing broken, just slower. WhyBackground indexing and telemetry re-enabled. Fix Review startup tasks and background permissions after major updates.

Read More
AI

AI Prompt — Personal Learning Accelerator

- 07.01.26 - ErcanOPAK comment on AI Prompt — Personal Learning Accelerator

Prompt: Create a 30-day learning plan for: – A complete beginner – Only 20 minutes per day – Focus on practical outcomes Topic: <ANY SKILL>  

Read More
AI

AI Prompt — Generate Tests for Edge Cases Only

- 07.01.26 - ErcanOPAK comment on AI Prompt — Generate Tests for Edge Cases Only

Prompt: Generate unit tests focusing only on: – Boundary conditions – Rare edge cases – Failure paths Code: <PASTE CODE>  

Read More
AI

AI Prompt — Refactor Code for Long-Term Ownership

- 07.01.26 - ErcanOPAK comment on AI Prompt — Refactor Code for Long-Term Ownership

Prompt: Refactor this code assuming: – It will be maintained by juniors – It will live for 5+ years Explain trade-offs and decisions. Code: <PASTE CODE>  

Read More
Docker

Docker Images Grow Over Time Without Reason

- 07.01.26 - ErcanOPAK comment on Docker Images Grow Over Time Without Reason

Same app, bigger image. WhyLayer cache accumulates unused artifacts. Fix Use multi-stage builds and remove build-time dependencies.

Read More
Kubernetes

Kubernetes Deployments Appear “Healthy” but Perform Poorly

- 07.01.26 - ErcanOPAK comment on Kubernetes Deployments Appear “Healthy” but Perform Poorly

Pods are green, users complain. WhyResource limits hide throttling issues. Fix Monitor CPU throttling, not just pod status. Healthy pods can still be starved.

Read More
Wordpress

WordPress Images Look Blurry on Retina Screens

- 07.01.26 - ErcanOPAK comment on WordPress Images Look Blurry on Retina Screens

Uploaded images look fine locally, blurry online. WhyDefault image sizes don’t match device pixel ratio. Fix Enable responsive image sizes and serve higher-resolution variants.

Read More
Wordpress

WordPress Admin Becomes Slower Over Time

- 07.01.26 - ErcanOPAK comment on WordPress Admin Becomes Slower Over Time

Not broken — just painfully slow. WhyAccumulated transients and orphaned options. Fix Clean expired transients periodically and limit autoloaded options. This prevents admin-side slowdown without affecting visitors.

Read More
Photoshop

Photoshop Brushes Feel Laggy on Powerful Machines

- 07.01.26 - ErcanOPAK comment on Photoshop Brushes Feel Laggy on Powerful Machines

High-end GPU, still stuttering. WhyBrush smoothing and real-time preview overload input processing. Fix Lower brush smoothing slightly instead of disabling GPU acceleration entirely.

Read More
Photoshop

Photoshop Files Suddenly Get Huge After Small Edits

- 07.01.26 - ErcanOPAK comment on Photoshop Files Suddenly Get Huge After Small Edits

You save a minor change… file size doubles. WhyHidden layer metadata and smart object history are preserved by default. Fix Convert Smart Objects to raster when finalized Use File → Save a Copy instead of Save This strips unnecessary history without losing quality.

Read More
Visual Studio

Visual Studio Uses Too Much RAM Even with Small Projects

- 07.01.26 - ErcanOPAK comment on Visual Studio Uses Too Much RAM Even with Small Projects

You open a tiny solution… memory spikes instantly. WhyVisual Studio loads analyzers, live diagnostics, and background code models eagerly. ImpactSlower builds, sluggish IntelliSense, high battery usage. Fix Disable unnecessary background features: Turn off CodeLens Limit live analyzers for non-critical projects This keeps the IDE responsive without breaking core features.

Read More
C#

C# Static Constructors Break Startup

- 06.01.26 - ErcanOPAK comment on C# Static Constructors Break Startup

App fails before logging. WhyExceptions thrown too early. FixMove logic out of static constructors.

Read More
C#

C# LINQ Kills Performance in Hot Paths

- 06.01.26 - ErcanOPAK comment on C# LINQ Kills Performance in Hot Paths

Readable but slow. WhyAllocations and deferred execution. FixUse loops in critical sections.

Read More
C#

C# async void Causes Invisible Crashes

- 06.01.26 - ErcanOPAK comment on C# async void Causes Invisible Crashes

No stack trace. WhyExceptions cannot be awaited. FixAvoid async void except event handlers.

Read More
SQL

SQL COUNT(*) Is Slower Than Expected

- 06.01.26 - ErcanOPAK comment on SQL COUNT(*) Is Slower Than Expected

Small table, big delay. WhyTable scan instead of index usage. FixUse indexed columns.

Read More
SQL

SQL Queries Slow Only After Server Restart

- 06.01.26 - ErcanOPAK comment on SQL Queries Slow Only After Server Restart

Then magically improve. WhyCold cache + outdated statistics. Fix UPDATE STATISTICS TableName;  

Read More
Asp.Net Core

.NET Core Memory Grows Without Leaks

- 06.01.26 - ErcanOPAK comment on .NET Core Memory Grows Without Leaks

GC runs but memory stays high. WhyLarge object heap fragmentation. FixReuse large buffers.

Read More
Asp.Net Core / C#

ASP.NET Core Requests Hang Randomly

- 06.01.26 - ErcanOPAK comment on ASP.NET Core Requests Hang Randomly

No exceptions thrown. WhyThread starvation due to sync-over-async. Fix await Task.Run(() => AsyncMethod()).ConfigureAwait(false);  

Read More
Git

Git Pull Breaks Local Changes Silently

- 06.01.26 - ErcanOPAK comment on Git Pull Breaks Local Changes Silently

No conflict shown. WhyAuto-merge with rerere. FixDisable rerere temporarily.

Read More
Git

Git History Looks Clean but Bugs Exist

- 06.01.26 - ErcanOPAK comment on Git History Looks Clean but Bugs Exist

Commits look fine. WhyLogical changes bundled together. FixUse smaller, purpose-driven commits.

Read More
Ajax / JavaScript

Ajax Calls Fail Only Behind Load Balancer

- 06.01.26 - ErcanOPAK comment on Ajax Calls Fail Only Behind Load Balancer

Direct calls succeed. WhyMissing forwarded headers. FixForward X-Forwarded-Proto.

Read More
JavaScript

JavaScript Memory Usage Keeps Growing

- 06.01.26 - ErcanOPAK comment on JavaScript Memory Usage Keeps Growing

No visible leaks. WhyDetached DOM nodes remain referenced. FixExplicitly null unused references.

Read More
HTML

HTML5 Videos Don’t Autoplay on Mobile

- 06.01.26 - ErcanOPAK comment on HTML5 Videos Don’t Autoplay on Mobile

Works on desktop. WhyMobile requires muted autoplay. Fix <video autoplay muted playsinline></video>  

Read More
CSS

CSS Animations Lag on Mobile Only

- 06.01.26 - ErcanOPAK comment on CSS Animations Lag on Mobile Only

Desktop smooth, mobile stutters. WhyLayout-triggering properties. Fix transform: translateZ(0);  

Read More
Windows

Windows 11 SSD Feels Slower Over Time

- 06.01.26 - ErcanOPAK comment on Windows 11 SSD Feels Slower Over Time

Benchmarks drop gradually. WhyIndexing + background telemetry. FixLimit indexing scope manually.

Read More
Windows

Windows 11 Taskbar Becomes Unresponsive

- 06.01.26 - ErcanOPAK comment on Windows 11 Taskbar Becomes Unresponsive

xplorer runs, UI frozen. WhyShell extensions crash silently. FixDisable third-party shell extensions.

Read More
AI

AI Prompt — Solve a Life Decision Clearly

- 06.01.26 - ErcanOPAK comment on AI Prompt — Solve a Life Decision Clearly

Prompt: Help me think clearly. List: – Emotional bias involved – Hidden risks – The safest reversible step Decision: <DESCRIBE>  

Read More
AI

AI Prompt — Refactor for Readability and Scale

- 06.01.26 - ErcanOPAK comment on AI Prompt — Refactor for Readability and Scale

Prompt: Refactor this code. Goals: – Reduce cognitive load – Improve long-term maintainability – Explain WHY each change matters Code: <PASTE CODE>  

Read More
Page 41 of 69
« Previous 1 … 36 37 38 39 40 41 42 43 44 45 46 … 69 Next »

Posts navigation

Older posts
Newer posts
April 2026
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930  
« Mar    

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (950)
  • How to add default value for Entity Framework migrations for DateTime and Bool (859)
  • Get the First and Last Word from a String or Sentence in SQL (837)
  • How to select distinct rows in a datatable in C# (805)
  • How to make theater mode the default for Youtube (754)
  • Add Constraint to SQL Table to ensure email contains @ (578)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (564)
  • Average of all values in a column that are not zero in SQL (531)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (489)
  • Find numbers with more than two decimal places in SQL (449)

Recent Posts

  • C#: Use Init-Only Setters for Immutable Objects After Construction
  • C#: Use Expression-Bodied Members for Concise Single-Line Methods
  • C#: Enable Nullable Reference Types to Eliminate Null Reference Exceptions
  • C#: Use Record Types for Immutable Data Objects
  • SQL: Use CTEs for Readable Complex Queries
  • SQL: Use Window Functions for Advanced Analytical Queries
  • .NET Core: Use Background Services for Long-Running Tasks
  • .NET Core: Use Minimal APIs for Lightweight HTTP Services
  • Git: Use Cherry-Pick to Apply Specific Commits Across Branches
  • Git: Use Interactive Rebase to Clean Up Commit History Before Merge

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (950)
  • How to add default value for Entity Framework migrations for DateTime and Bool (859)
  • Get the First and Last Word from a String or Sentence in SQL (837)
  • How to select distinct rows in a datatable in C# (805)
  • How to make theater mode the default for Youtube (754)

Recent Posts

  • C#: Use Init-Only Setters for Immutable Objects After Construction
  • C#: Use Expression-Bodied Members for Concise Single-Line Methods
  • C#: Enable Nullable Reference Types to Eliminate Null Reference Exceptions
  • C#: Use Record Types for Immutable Data Objects
  • SQL: Use CTEs for Readable Complex Queries

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com