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

Photoshop

Photoshop — Smart Objects Can Explode File Size

- 31.12.25 - ErcanOPAK comment on Photoshop — Smart Objects Can Explode File Size

Nested smart objects silently increase PSD size. Fix Rasterize unused smart objects before export.

Read More
Photoshop

Photoshop — Blurry Images After Export? It’s the Color Profile

- 31.12.25 - ErcanOPAK comment on Photoshop — Blurry Images After Export? It’s the Color Profile

Images look sharp in PS, blurry on the web. Fix Convert to sRGB Disable “Embed Color Profile” for web

Read More
Visual Studio

Visual Studio — Debugging the Wrong Code? Check Shadow Copy

- 31.12.25 - ErcanOPAK comment on Visual Studio — Debugging the Wrong Code? Check Shadow Copy

Sometimes VS runs an old assembly. Root Cause Shadow copied DLLs remain locked. Fix Stop debugging Delete bin/ and obj/ Restart Visual Studio

Read More
Docker

Docker — latest Tag Breaks Reproducibility

- 30.12.25 - ErcanOPAK comment on Docker — latest Tag Breaks Reproducibility

latest changes silently. ❌ Risk Unexpected production behavior. ✅ Fix Pin exact image versions.

Read More
Kubernetes

Kubernetes — CPU Limits Cause Throttling Spikes

- 30.12.25 - ErcanOPAK comment on Kubernetes — CPU Limits Cause Throttling Spikes

Hard CPU limits throttle healthy pods. ✅ Tip Set requests carefully, limits cautiously.

Read More
Git

Git — git stash Can Lose Untracked Files

- 30.12.25 - ErcanOPAK comment on Git — git stash Can Lose Untracked Files

Default stash ignores untracked files. ✅ Fix git stash -u  

Read More
Photoshop

Photoshop — PNG Transparency Can Inflate File Size

- 30.12.25 - ErcanOPAK comment on Photoshop — PNG Transparency Can Inflate File Size

Unoptimized PNGs kill page speed. ✅ Fix Export with proper compression or use WebP.

Read More
AI

AI — Determinism Requires Fixed Seeds

- 30.12.25 - ErcanOPAK comment on AI — Determinism Requires Fixed Seeds

Without a seed, results vary. ✅ Fix Use fixed seeds when consistency matters.

Read More
AI

AI — Few-Shot Examples Beat Long Instructions

- 30.12.25 - ErcanOPAK comment on AI — Few-Shot Examples Beat Long Instructions

Examples outperform verbose explanations. ✅ Rule Show, don’t explain.

Read More
AI

Ambiguous Prompts Produce Confidently Wrong Answers

- 30.12.25 | 30.12.25 - ErcanOPAK comment on Ambiguous Prompts Produce Confidently Wrong Answers

Models guess when context is unclear. ✅ Tip Explicit constraints reduce hallucinations.

Read More
Visual Studio

Visual Studio — CPU Spikes Caused by Live Analysis

- 30.12.25 - ErcanOPAK comment on Visual Studio — CPU Spikes Caused by Live Analysis

Background analyzers consume CPU. ✅ Fix Disable unnecessary live analyzers.

Read More
Wordpress

WordPress — wp_options Autoload Kills TTFB

- 30.12.25 - ErcanOPAK comment on WordPress — wp_options Autoload Kills TTFB

Autoloaded options load on every request. ✅ Fix Set unused options to autoload = no.

Read More
Windows

Windows 11 — HDR Mode Breaks Color Accuracy

- 30.12.25 - ErcanOPAK comment on Windows 11 — HDR Mode Breaks Color Accuracy

HDR distorts colors for design & dev work. ✅ Tip Disable HDR on dev machines.

Read More
Windows

Windows 11 — Delivery Optimization Eats Bandwidth

- 30.12.25 - ErcanOPAK comment on Windows 11 — Delivery Optimization Eats Bandwidth

Windows shares updates peer-to-peer. ✅ Fix Disable Delivery Optimization.

Read More
Ajax / JavaScript

AJAX — Browser Caches GET Requests Silently

- 30.12.25 - ErcanOPAK comment on AJAX — Browser Caches GET Requests Silently

Repeated GET calls may not hit the server. ✅ Fix Add cache-busting or proper headers.

Read More
JavaScript

JavaScript — NaN !== NaN Breaks Comparisons

- 30.12.25 - ErcanOPAK comment on JavaScript — NaN !== NaN Breaks Comparisons

NaN is never equal to itself. ✅ Fix Use: Number.isNaN(value)  

Read More
HTML

HTML5 — Must Be First

- 30.12.25 - ErcanOPAK comment on HTML5 — Must Be First

Late charset causes encoding bugs. ✅ Correct Place it as the first meta tag.

Read More
CSS / Development

CSS — min-width: 0 Fixes Broken Flex Layouts

- 30.12.25 | 30.12.25 - ErcanOPAK comment on CSS — min-width: 0 Fixes Broken Flex Layouts

Flex items refuse to shrink by default. ✅ Fix min-width: 0;  

Read More
Asp.Net Core

.NET Core — UseHttpsRedirection Breaks Proxies

- 30.12.25 - ErcanOPAK comment on .NET Core — UseHttpsRedirection Breaks Proxies

Behind reverse proxies, HTTPS may loop. ✅ Fix Use forwarded headers middleware.

Read More
Asp.Net Core

.NET Core — AddSingleton + State = Data Corruption

- 30.12.25 - ErcanOPAK comment on .NET Core — AddSingleton + State = Data Corruption

Singletons live forever. ❌ Risk Cross-request data leakage. ✅ Rule Never store request-specific state in singletons.

Read More
SQL

SQL — TRUNCATE Resets Identity Values

- 30.12.25 - ErcanOPAK comment on SQL — TRUNCATE Resets Identity Values

Many devs forget this. ❌ Impact Primary key collisions in test environments. ✅ Rule Use DELETE if identity must persist.

Read More
SQL

SQL — BETWEEN Can Return Unexpected Rows

- 30.12.25 - ErcanOPAK comment on SQL — BETWEEN Can Return Unexpected Rows

BETWEEN is inclusive on both ends. ❌ Bug Date range queries include unwanted records. ✅ Fix Use >= and < explicitly.

Read More
C#

C# — Stopwatch Is More Accurate Than DateTime

- 30.12.25 - ErcanOPAK comment on C# — Stopwatch Is More Accurate Than DateTime

Measuring performance with DateTime lies. ✅ Fix Stopwatch sw = Stopwatch.StartNew();  

Read More
C#

C# — async Lambdas Capture Variables Unexpectedly

- 30.12.25 - ErcanOPAK comment on C# — async Lambdas Capture Variables Unexpectedly

Loop variables are captured by reference. ❌ Bug Perfectly compiled, logically broken code. ✅ Fix Create a local copy inside the loop.

Read More
C#

C# — string.Equals() Without ComparisonType Is a Bug

- 30.12.25 | 30.12.25 - ErcanOPAK comment on C# — string.Equals() Without ComparisonType Is a Bug

Default comparison is culture-sensitive. string.Equals(a, b) ❌ Risk Unexpected results in different locales. ✅ Fix string.Equals(a, b, StringComparison.Ordinal)  

Read More
Applications / C# / Software

Prayer Times App v1.1.1

- 30.12.25 | 05.04.26 - ErcanOPAK comment on Prayer Times App v1.1.1

🕌 Modern, User-Friendly Prayer Times Application Completely free, portable prayer times application for Windows — no installation required. Supports 203 countries and 4,120+ cities worldwide. ✨ Features 🌍 Global Support: 203 countries, 4,120+ cities worldwide 🇹🇷 🇬🇧 Bilingual: Turkish and English interface 📖 Islamic Library: 28 surahs, 36 prayers, 40 hadiths (favorites & smart search) […]

Read More
C# / Uygulamalar / Yazılım

Namaz Vakitleri Uygulaması v1.1.1

- 30.12.25 | 05.04.26 - ErcanOPAK comment on Namaz Vakitleri Uygulaması v1.1.1

🕌 Modern, Kullanıcı Dostu Namaz Vakitleri Uygulaması Windows için tamamen ücretsiz, kurulum gerektirmeyen (portable) namaz vakitleri uygulaması. Dünya genelinde 203 ülke ve 4,120+ şehri destekliyor. ✨ Özellikler 🌍 Küresel Destek: 203 ülke, 4,120+ şehir, Türkiye’nin tüm il ve ilçeleri 🇹🇷 🇬🇧 Çift Dil: Türkçe ve İngilizce arayüz 📖 İslami Kütüphane: 28 sure, 36 dua, 40 […]

Read More
Git

Git — git pull Can Rewrite History

- 29.12.25 - ErcanOPAK comment on Git — git pull Can Rewrite History

Pull = fetch + merge (or rebase). ❌ Risk Unexpected conflicts or history changes. ✅ Safer Use explicit: git fetch git merge  

Read More
Photoshop

Photoshop — Exporting in sRGB Prevents Color Shifts

- 29.12.25 - ErcanOPAK comment on Photoshop — Exporting in sRGB Prevents Color Shifts

Without sRGB, colors change on web. ✅ Fix Always export with Convert to sRGB enabled.

Read More
AI

AI — Token Cost Explodes with System Prompts

- 29.12.25 - ErcanOPAK comment on AI — Token Cost Explodes with System Prompts

System messages are sent every request. ✅ Tip Keep system prompts short and reusable.

Read More
Page 48 of 69
« Previous 1 … 43 44 45 46 47 48 49 50 51 52 53 … 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 (836)
  • 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 (448)

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 (836)
  • 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