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

Git

Git Conflicts Keep Reappearing

- 18.01.26 - ErcanOPAK comment on Git Conflicts Keep Reappearing

Same files, same pain. WhyLong-lived branches. TipMerge often, keep branches short.

Read More
Git

Git Rebase Feels Dangerous

- 18.01.26 - ErcanOPAK comment on Git Rebase Feels Dangerous

Fear of losing work. WhyRebase misunderstood. TipUse rebase on local branches only.

Read More
Ajax / JavaScript

Ajax Forms Submit Twice

- 18.01.26 - ErcanOPAK comment on Ajax Forms Submit Twice

Users click once. WhyButton not disabled during request. TipDisable button until response. button.disabled = true;  

Read More
JavaScript

JavaScript Loops Feel Slow

- 18.01.26 - ErcanOPAK comment on JavaScript Loops Feel Slow

Small loops, big impact. WhyDOM updates inside loops. TipBatch DOM changes. const fragment = document.createDocumentFragment();  

Read More
HTML

HTML5 Videos Don’t Autoplay

- 18.01.26 - ErcanOPAK comment on HTML5 Videos Don’t Autoplay

Works locally, fails in browser. WhyBrowser blocks autoplay with sound. TipMute video for autoplay. <video autoplay muted></video>  

Read More
CSS

CSS Layouts Break on Small Screens

- 18.01.26 - ErcanOPAK comment on CSS Layouts Break on Small Screens

Desktop perfect, mobile chaos. WhyFixed widths instead of flexible units. TipUse max-width and % instead of px. .container { max-width: 1200px; width: 100%; }  

Read More
Windows

Windows 11 Clipboard History Saves You Hours

- 18.01.26 - ErcanOPAK comment on Windows 11 Clipboard History Saves You Hours

Most users ignore it. WhyClipboard history is disabled by default. TipEnable Win + V and work faster.

Read More
Windows

Windows 11 Apps Start Slowly

- 18.01.26 - ErcanOPAK comment on Windows 11 Apps Start Slowly

Click, wait, frustration. WhyToo many startup background tasks. TipDisable unnecessary startup apps.

Read More
AI

AI Prompt — Emergency Preparedness

- 18.01.26 - ErcanOPAK comment on AI Prompt — Emergency Preparedness

Prompt: Create a simple emergency preparedness checklist for an apartment. Focus on practical items, not extreme scenarios.  

Read More
AI

AI Prompt — Optimize Before Scaling

- 18.01.26 - ErcanOPAK comment on AI Prompt — Optimize Before Scaling

Prompt: Analyze this logic and suggest performance improvements BEFORE scaling. Explain trade-offs. Code or description: <PASTE>  

Read More
AI

AI Prompt — Code Review With Context

- 18.01.26 - ErcanOPAK comment on AI Prompt — Code Review With Context

Prompt: Review this code as if it will be maintained by a junior developer. Focus on readability, safety, and hidden risks. Code: <PASTE CODE>  

Read More
Docker

Docker Containers Work Locally but Fail in CI

- 18.01.26 - ErcanOPAK comment on Docker Containers Work Locally but Fail in CI

Same image, different result. WhyMissing environment variables. TipExplicitly define ENV values in Dockerfile.

Read More
Kubernetes

Kubernetes Pods Restart Without Errors

- 18.01.26 - ErcanOPAK comment on Kubernetes Pods Restart Without Errors

No crash logs, still restarting. WhyResource limits exceeded silently. TipCheck memory limits and OOMKills.

Read More
Wordpress

WordPress REST API Feels Slow

- 18.01.26 - ErcanOPAK comment on WordPress REST API Feels Slow

API works but response time hurts. WhyUncached database queries per request. TipCache REST responses using transients.

Read More
Wordpress

WordPress Pages Break After Theme Update

- 18.01.26 - ErcanOPAK comment on WordPress Pages Break After Theme Update

No plugin change, layout ruined. WhyTheme update overwrote custom CSS. TipAlways place custom CSS in child theme or Customizer.

Read More
Photoshop

Photoshop Files Become Uneditable Over Time

- 18.01.26 - ErcanOPAK comment on Photoshop Files Become Uneditable Over Time

Opening PSD is slow, editing painful. WhyToo many adjustment layers stacked. TipGroup and merge finalized adjustments.

Read More
Photoshop

Photoshop Layers Look Sharp but Export Is Blurry

- 18.01.26 - ErcanOPAK comment on Photoshop Layers Look Sharp but Export Is Blurry

Canvas looks perfect, export disappoints. WhyResampling method defaults to low-quality scaling. TipUse “Bicubic Sharper” when downsizing images.

Read More
Visual Studio

Visual Studio Debugging Hits Wrong Code Lines

- 18.01.26 - ErcanOPAK comment on Visual Studio Debugging Hits Wrong Code Lines

Breakpoints hit, but execution feels “off”. WhyOutdated PDB files are still being used. TipAlways clean and rebuild when stepping behaves strangely. Why it mattersYou debug old binaries, not current logic.

Read More
C#

C# String Operations Hurt Performance

- 16.01.26 - ErcanOPAK comment on C# String Operations Hurt Performance

Heavy string manipulation. WhyImmutable strings. TipUse StringBuilder in loops. var sb = new StringBuilder();  

Read More
C#

C# DateTime Bugs Appear Across Servers

- 16.01.26 - ErcanOPAK comment on C# DateTime Bugs Appear Across Servers

Same code, different results. WhyLocal time assumptions. TipAlways use UTC internally.

Read More
C#

C# LINQ Queries Allocate Too Much

- 16.01.26 - ErcanOPAK comment on C# LINQ Queries Allocate Too Much

Elegant but costly. WhyDeferred execution misunderstood. TipMaterialize once when reused. var data = query.ToList();  

Read More
SQL

SQL Deadlocks Appear Sporadically

- 16.01.26 - ErcanOPAK comment on SQL Deadlocks Appear Sporadically

Hard to reproduce. WhyInconsistent access order. TipStandardize table access order.

Read More
SQL

SQL Queries Break After Schema Changes

- 16.01.26 - ErcanOPAK comment on SQL Queries Break After Schema Changes

Query logic unchanged. WhyImplicit column order dependency. TipAlways specify column names.

Read More
Asp.Net Core

.NET Core Logs Impact Performance

- 16.01.26 - ErcanOPAK comment on .NET Core Logs Impact Performance

Logging enabled, speed drops. WhySynchronous log providers. TipUse async logging.

Read More
Asp.Net Core

ASP.NET Core Startup Becomes Slower

- 16.01.26 - ErcanOPAK comment on ASP.NET Core Startup Becomes Slower

App works, boot time grows. WhyHeavy work in ConfigureServices. TipDefer non-critical initialization.

Read More
Git

Git Branches Linger Forever

- 16.01.26 - ErcanOPAK comment on Git Branches Linger Forever

Dead branches pile up. WhyNo cleanup policy. TipAutomate stale branch deletion.

Read More
Git

Git History Becomes Hard to Read

- 16.01.26 - ErcanOPAK comment on Git History Becomes Hard to Read

Commits exist, meaning lost. WhyOverloaded commit messages. TipOne intent per commit.

Read More
Ajax / JavaScript

Ajax Requests Succeed but Data Is Stale

- 16.01.26 - ErcanOPAK comment on Ajax Requests Succeed but Data Is Stale

Correct response, old UI. WhyClient-side caching assumptions. TipExplicitly control cache headers.

Read More
JavaScript

JavaScript Apps Become Sluggish After Navigation

- 16.01.26 - ErcanOPAK comment on JavaScript Apps Become Sluggish After Navigation

SPA feels heavier over time. WhyEvent listeners not removed. TipAlways clean up listeners on teardown.

Read More
HTML

HTML Forms Submit Slower Than Expected

- 16.01.26 - ErcanOPAK comment on HTML Forms Submit Slower Than Expected

Simple forms, slow UX. WhyBlocking validation scripts. TipDefer non-critical scripts.

Read More
Page 35 of 69
« Previous 1 … 30 31 32 33 34 35 36 37 38 39 40 … 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