Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

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

Day: November 8, 2026

Windows

Windows 11: Fix File Explorer’s Search Finding a File’s Name but Never Its Contents on a Second Drive Because Indexing Options Only Covers That Drive’s Properties by Default

- 08.11.26 - ErcanOPAK comment on Windows 11: Fix File Explorer’s Search Finding a File’s Name but Never Its Contents on a Second Drive Because Indexing Options Only Covers That Drive’s Properties by Default

πŸͺŸ Windows 11: Fix File Explorer’s Search Finding a File’s Name but Never Its Contents on a Second Drive Because Indexing Options Only Covers That Drive’s Properties by Default Windows Search indexes whichever locations have been added to its catalog, but a non-system drive added later is typically indexed for file and folder PROPERTIES β€” […]

Read More
SQL

SQL Server: Fix a CTE Referenced Twice in the Same Query Computing Its Result Set Twice Because SQL Server Doesn’t Materialize a Non-Recursive CTE by Default

- 08.11.26 - ErcanOPAK comment on SQL Server: Fix a CTE Referenced Twice in the Same Query Computing Its Result Set Twice Because SQL Server Doesn’t Materialize a Non-Recursive CTE by Default

πŸ—„οΈ SQL Server: Fix a CTE Referenced Twice in the Same Query Computing Its Result Set Twice Because SQL Server Doesn’t Materialize a Non-Recursive CTE by Default A Common Table Expression is effectively a named, inline view for the duration of a single query β€” SQL Server doesn’t automatically compute it once and cache the […]

Read More
AI

The AI Prompt That Reads a Confusing Compiler Error Message and Explains Which Line Actually Caused It, Not Just Where It Surfaced

- 08.11.26 - ErcanOPAK comment on The AI Prompt That Reads a Confusing Compiler Error Message and Explains Which Line Actually Caused It, Not Just Where It Surfaced

πŸ€– The AI Prompt That Reads a Confusing Compiler Error Message and Explains Which Line Actually Caused It, Not Just Where It Surfaced A compiler error gets reported at the line where the type checker finally gave up, which is often several lines β€” sometimes a different file entirely β€” away from the actual mistake: […]

Read More
Docker

Docker: Fix a Multi-Stage Build Reinstalling Every Dependency on Every Code Change Because COPY . . Runs Before the Package Install Step

- 08.11.26 - ErcanOPAK comment on Docker: Fix a Multi-Stage Build Reinstalling Every Dependency on Every Code Change Because COPY . . Runs Before the Package Install Step

🐳 Docker: Fix a Multi-Stage Build Reinstalling Every Dependency on Every Code Change Because COPY . . Runs Before the Package Install Step Docker’s build cache invalidates a layer, and every layer that follows it, the instant any file an earlier COPY instruction reads from changes. Copying the entire project directory with COPY . . […]

Read More
JavaScript

JavaScript: Fix value instanceof Array Returning false for an Array Passed Across an iframe Boundary Because Each Window Has Its Own Array Constructor

- 08.11.26 - ErcanOPAK comment on JavaScript: Fix value instanceof Array Returning false for an Array Passed Across an iframe Boundary Because Each Window Has Its Own Array Constructor

⚑ JavaScript: Fix value instanceof Array Returning false for an Array Passed Across an iframe Boundary Because Each Window Has Its Own Array Constructor Every JavaScript realm β€” the main page, and separately each iframe, popup window, or worker β€” has its own global object and therefore its own distinct set of built-in constructors, Array […]

Read More
Photoshop

Photoshop: Fix Text Set in a Non-Latin Font Rendering as Empty Boxes in a Shared PSD Because That Font Is Only Installed on the Machine That Created the Document

- 08.11.26 - ErcanOPAK comment on Photoshop: Fix Text Set in a Non-Latin Font Rendering as Empty Boxes in a Shared PSD Because That Font Is Only Installed on the Machine That Created the Document

πŸ–ŒοΈ Photoshop: Fix Text Set in a Non-Latin Font Rendering as Empty Boxes in a Shared PSD Because That Font Is Only Installed on the Machine That Created the Document A .psd file stores a reference to the font FAMILY NAME a type layer used, not the font’s actual outline data, so opening that document […]

Read More
HTML

HTML5: Fix a Multiple-Select Element’s Value Always Returning Only the First Selected Option Because the Code Reads .value Instead of Iterating .selectedOptions

- 08.11.26 - ErcanOPAK comment on HTML5: Fix a Multiple-Select Element’s Value Always Returning Only the First Selected Option Because the Code Reads .value Instead of Iterating .selectedOptions

🧩 HTML5: Fix a Multiple-Select Element’s Value Always Returning Only the First Selected Option Because the Code Reads .value Instead of Iterating .selectedOptions A <select multiple> element genuinely lets a user pick several options at once, but its .value property behaves exactly like a single-select’s β€” it only ever returns the value of the FIRST […]

Read More
Git

Git: Fix a Tag Pushed to the Remote Not Showing Up in a Teammate’s Clone Because git fetch Doesn’t Fetch Tags Added After Their Last Fetch by Default

- 08.11.26 - ErcanOPAK comment on Git: Fix a Tag Pushed to the Remote Not Showing Up in a Teammate’s Clone Because git fetch Doesn’t Fetch Tags Added After Their Last Fetch by Default

πŸ”€ Git: Fix a Tag Pushed to the Remote Not Showing Up in a Teammate’s Clone Because git fetch Doesn’t Fetch Tags Added After Their Last Fetch by Default A plain git fetch only follows tags that point at commits already being pulled down as part of the normal branch-following refspec. A lightweight or annotated […]

Read More
SQL

SQL Server: Fix a Parameterized Query Using a Bad Cached Execution Plan for Every Caller Because the First Call’s Unusual Parameter Value Skewed the Optimizer’s Row Estimate

- 08.11.26 - ErcanOPAK comment on SQL Server: Fix a Parameterized Query Using a Bad Cached Execution Plan for Every Caller Because the First Call’s Unusual Parameter Value Skewed the Optimizer’s Row Estimate

πŸ—„οΈ SQL Server: Fix a Parameterized Query Using a Bad Cached Execution Plan for Every Caller Because the First Call’s Unusual Parameter Value Skewed the Optimizer’s Row Estimate SQL Server caches one execution plan per distinct query text, and for a parameterized query that plan gets built using the ACTUAL parameter value supplied on the […]

Read More
Wordpress

WordPress: Fix the Media Library Silently Re-Compressing Every Re-Uploaded PNG Because the Big Image Size Threshold Scales Anything Over 2560 Pixels on Upload

- 08.11.26 - ErcanOPAK comment on WordPress: Fix the Media Library Silently Re-Compressing Every Re-Uploaded PNG Because the Big Image Size Threshold Scales Anything Over 2560 Pixels on Upload

πŸ“ WordPress: Fix the Media Library Silently Re-Compressing Every Re-Uploaded PNG Because the Big Image Size Threshold Scales Anything Over 2560 Pixels on Upload Since WordPress 5.3, any image wider or taller than a configurable β€œbig image size threshold” β€” 2560 pixels by default β€” gets automatically scaled down on upload and inserted into posts […]

Read More
Kubernetes

Kubernetes: Fix a Horizontal Pod Autoscaler Refusing to Scale Down for Five Minutes After Load Drops Because the Default Stabilization Window Picks the Highest Recent Recommendation

- 08.11.26 - ErcanOPAK comment on Kubernetes: Fix a Horizontal Pod Autoscaler Refusing to Scale Down for Five Minutes After Load Drops Because the Default Stabilization Window Picks the Highest Recent Recommendation

☸️ Kubernetes: Fix a Horizontal Pod Autoscaler Refusing to Scale Down for Five Minutes After Load Drops Because the Default Stabilization Window Picks the Highest Recent Recommendation The autoscaling/v2 HorizontalPodAutoscaler computes a fresh scale recommendation on every sync, but its default scale-down behavior applies a 300-second stabilization window that deliberately uses the HIGHEST replica count […]

Read More
C#

C#: Fix an Extension Method Silently Never Getting Called Because an Instance Method Added Later With a Matching Signature Always Wins Overload Resolution

- 08.11.26 - ErcanOPAK comment on C#: Fix an Extension Method Silently Never Getting Called Because an Instance Method Added Later With a Matching Signature Always Wins Overload Resolution

πŸ”§ C#: Fix an Extension Method Silently Never Getting Called Because an Instance Method Added Later With a Matching Signature Always Wins Overload Resolution C#’s overload resolution rules give any applicable INSTANCE method β€” including an inherited one β€” strict priority over an extension method with a matching name and compatible signature, regardless of which […]

Read More
Photoshop

Photoshop: Fix a Custom Brush’s Pressure Sensitivity Doing Nothing Because the Tablet Driver’s Windows Ink Setting Overrides Photoshop’s Own Pressure Curve

- 08.11.26 - ErcanOPAK comment on Photoshop: Fix a Custom Brush’s Pressure Sensitivity Doing Nothing Because the Tablet Driver’s Windows Ink Setting Overrides Photoshop’s Own Pressure Curve

πŸ–ŒοΈ Photoshop: Fix a Custom Brush’s Pressure Sensitivity Doing Nothing Because the Tablet Driver’s Windows Ink Setting Overrides Photoshop’s Own Pressure Curve Most drawing tablets offer two separate ways of talking to Windows: their own native driver protocol (often called WinTab) and the generic Windows Ink pointer API that any Ink-aware app can read from. […]

Read More
AI

The AI Prompt That Turns a Production Incident’s Raw Log Timeline Into a Draft Postmortem’s Root-Cause Section

- 08.11.26 - ErcanOPAK comment on The AI Prompt That Turns a Production Incident’s Raw Log Timeline Into a Draft Postmortem’s Root-Cause Section

πŸ€– The AI Prompt That Turns a Production Incident’s Raw Log Timeline Into a Draft Postmortem’s Root-Cause Section Writing the root-cause section of a postmortem is usually the slowest part of the whole process, because it means re-reading a sprawling, timestamped wall of log lines from several services and reconstructing causality by hand. A focused […]

Read More
C#

C#: Fix a foreach Loop Over a List Throwing InvalidOperationException Because an Awaited Continuation Still Running After the Loop Started Modified the Same List

- 08.11.26 - ErcanOPAK comment on C#: Fix a foreach Loop Over a List Throwing InvalidOperationException Because an Awaited Continuation Still Running After the Loop Started Modified the Same List

πŸ”§ C#: Fix a foreach Loop Over a List Throwing InvalidOperationException Because an Awaited Continuation Still Running After the Loop Started Modified the Same List A foreach loop over a List<T> takes out an enumerator that detects structural modification to the underlying list during enumeration, throwing InvalidOperationException the moment it notices one. That’s usually understood […]

Read More
Asp.Net Core

ASP.NET Core: Fix a Minimal API Deserializing a Missing Property Into null Instead of Failing Because the Record’s Property Is Non-Nullable but Never Marked required

- 08.11.26 - ErcanOPAK comment on ASP.NET Core: Fix a Minimal API Deserializing a Missing Property Into null Instead of Failing Because the Record’s Property Is Non-Nullable but Never Marked required

βš™οΈ ASP.NET Core: Fix a Minimal API Deserializing a Missing Property Into null Instead of Failing Because the Record’s Property Is Non-Nullable but Never Marked required System.Text.Json’s awareness of nullable reference types is NOT part of ordinary deserialization β€” a record or class property declared as a plain non-nullable reference type, without the C# 11 […]

Read More
AI

The AI Prompt That Turns Your Car’s Owner’s Manual PDF Into a Quick-Reference Card for Every Dashboard Warning Light

- 08.11.26 - ErcanOPAK comment on The AI Prompt That Turns Your Car’s Owner’s Manual PDF Into a Quick-Reference Card for Every Dashboard Warning Light

πŸ€– The AI Prompt That Turns Your Car’s Owner’s Manual PDF Into a Quick-Reference Card for Every Dashboard Warning Light Almost nobody reads a 300-page owner’s manual cover to cover, and the one moment it actually matters β€” an unfamiliar icon lighting up on the dashboard while you’re already driving β€” is exactly when nobody […]

Read More
Ajax

Ajax: Fix a Request Retried After a Dropped Connection Creating a Duplicate Server-Side Record Because the Retry Never Sends an Idempotency Key

- 08.11.26 - ErcanOPAK comment on Ajax: Fix a Request Retried After a Dropped Connection Creating a Duplicate Server-Side Record Because the Retry Never Sends an Idempotency Key

πŸ”„ Ajax: Fix a Request Retried After a Dropped Connection Creating a Duplicate Server-Side Record Because the Retry Never Sends an Idempotency Key A common resilience pattern β€” automatically retrying an Ajax request after a network error or timeout β€” assumes the original request never actually reached the server. But a dropped connection can just […]

Read More
C#

C#: Fix a required Member Compiling Fine but Still Letting null Through Because required Only Enforces That the Setter Runs, Not What Value It Receives

- 08.11.26 - ErcanOPAK comment on C#: Fix a required Member Compiling Fine but Still Letting null Through Because required Only Enforces That the Setter Runs, Not What Value It Receives

πŸ”§ C#: Fix a required Member Compiling Fine but Still Letting null Through Because required Only Enforces That the Setter Runs, Not What Value It Receives The C# 11 required modifier guarantees, at compile time, that an object initializer actually ASSIGNS a value to that member β€” it adds no runtime or compile-time check on […]

Read More
Asp.Net Core

ASP.NET Core: Fix a Strongly-Typed Options Class Never Picking Up a Changed appsettings.json Value Because the Code Injected IOptions Instead of IOptionsSnapshot

- 08.11.26 - ErcanOPAK comment on ASP.NET Core: Fix a Strongly-Typed Options Class Never Picking Up a Changed appsettings.json Value Because the Code Injected IOptions Instead of IOptionsSnapshot

βš™οΈ ASP.NET Core: Fix a Strongly-Typed Options Class Never Picking Up a Changed appsettings.json Value Because the Code Injected IOptions Instead of IOptionsSnapshot ASP.NET Core’s options pattern offers several interfaces with genuinely different reload behavior: IOptions<T> is registered as a singleton and reads its configuration value exactly once, the first time it’s resolved, and never […]

Read More
Windows

Windows 11: Fix Bluetooth Audio Stuttering Only When a Second Device Is Also Connected Because Windows Shares One Radio Across Every Paired Bluetooth Connection

- 08.11.26 - ErcanOPAK comment on Windows 11: Fix Bluetooth Audio Stuttering Only When a Second Device Is Also Connected Because Windows Shares One Radio Across Every Paired Bluetooth Connection

πŸͺŸ Windows 11: Fix Bluetooth Audio Stuttering Only When a Second Device Is Also Connected Because Windows Shares One Radio Across Every Paired Bluetooth Connection A typical laptop has exactly one physical Bluetooth radio, no matter how many devices are paired and connected to it at once, and classic Bluetooth audio profiles share that radio’s […]

Read More
CSS

CSS: Fix an Absolutely Positioned Element With inset: 0 and margin: auto Not Actually Centering Because Its Parent’s Height Collapses to Zero

- 08.11.26 - ErcanOPAK comment on CSS: Fix an Absolutely Positioned Element With inset: 0 and margin: auto Not Actually Centering Because Its Parent’s Height Collapses to Zero

🎨 CSS: Fix an Absolutely Positioned Element With inset: 0 and margin: auto Not Actually Centering Because Its Parent’s Height Collapses to Zero The classic centering trick β€” inset: 0 plus a fixed width and height and margin: auto on an absolutely positioned child β€” relies on that element’s containing block having a definite size […]

Read More
Git

Git: Fix the Same Merge Conflict Reappearing on Every Future Merge From a Long-Lived Branch Because It Was Resolved by Blindly Taking –ours Instead of Merging Both Sides

- 08.11.26 - ErcanOPAK comment on Git: Fix the Same Merge Conflict Reappearing on Every Future Merge From a Long-Lived Branch Because It Was Resolved by Blindly Taking –ours Instead of Merging Both Sides

πŸ”€ Git: Fix the Same Merge Conflict Reappearing on Every Future Merge From a Long-Lived Branch Because It Was Resolved by Blindly Taking –ours Instead of Merging Both Sides Resolving a merge conflict with git checkout –ours <file> records that merge commit as though both sides’ changes to the file were incorporated, even though the […]

Read More
Visual Studio

Visual Studio: Fix Hot Reload Refusing to Apply a Code Change Inside a Record’s Primary Constructor Because Editing a Type’s Core Shape Always Forces a Full Rebuild

- 08.11.26 - ErcanOPAK comment on Visual Studio: Fix Hot Reload Refusing to Apply a Code Change Inside a Record’s Primary Constructor Because Editing a Type’s Core Shape Always Forces a Full Rebuild

πŸ› οΈ Visual Studio: Fix Hot Reload Refusing to Apply a Code Change Inside a Record’s Primary Constructor Because Editing a Type’s Core Shape Always Forces a Full Rebuild Hot Reload can swap a running method’s implementation while the debugger is still attached, but it only works for changes that don’t alter a type’s actual shape […]

Read More
Wordpress

WordPress: Fix the Block Editor’s ‘Attempt To Decode’ Validation Error on Save Because a Manually Edited Shortcode Inside a Classic Block Produced Mismatched HTML Comments

- 08.11.26 - ErcanOPAK comment on WordPress: Fix the Block Editor’s ‘Attempt To Decode’ Validation Error on Save Because a Manually Edited Shortcode Inside a Classic Block Produced Mismatched HTML Comments

πŸ“ WordPress: Fix the Block Editor’s ‘Attempt To Decode’ Validation Error on Save Because a Manually Edited Shortcode Inside a Classic Block Produced Mismatched HTML Comments Every block the Block Editor saves is wrapped in HTML comment delimiters β€” <!– wp:paragraph –> … <!– /wp:paragraph –> β€” and on load it validates that the saved […]

Read More
November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

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

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (857)
  • How to select distinct rows in a datatable in C# (854)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

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