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 1, 2026

SQL

SQL Server: Fix a Query Returning Different Row Counts on Reruns Because It Reads a Table Variable Populated Inside the Same Transaction as a Concurrent Writer

- 01.11.26 - ErcanOPAK comment on SQL Server: Fix a Query Returning Different Row Counts on Reruns Because It Reads a Table Variable Populated Inside the Same Transaction as a Concurrent Writer

πŸ—„οΈ Fix a Query Returning Different Row Counts on Reruns Because It Reads a Table Variable Populated Inside the Same Transaction as a Concurrent Writer A table variable is populated once, explicitly, by whatever INSERT or SELECT INTO statement fills it, and from that point on it behaves like a private, disconnected snapshot – nothing […]

Read More
Docker

Docker: Fix Files Written Inside a Bind-Mounted Volume Becoming Unreadable on the Host Because the Container Process Runs as a UID With No Matching User on the Host

- 01.11.26 - ErcanOPAK comment on Docker: Fix Files Written Inside a Bind-Mounted Volume Becoming Unreadable on the Host Because the Container Process Runs as a UID With No Matching User on the Host

🐳 Fix Files Written Inside a Bind-Mounted Volume Becoming Unreadable on the Host Because the Container Process Runs as a UID With No Matching User on the Host A bind mount shares a host directory directly with a container by exposing the same underlying inode, so file ownership is stored and enforced as a raw […]

Read More
Windows

Windows 11: Fix Windows Search Silently Skipping OneDrive Files Set to Free Up Space Because the Indexer Can’t Read Content From an Online-Only Placeholder

- 01.11.26 - ErcanOPAK comment on Windows 11: Fix Windows Search Silently Skipping OneDrive Files Set to Free Up Space Because the Indexer Can’t Read Content From an Online-Only Placeholder

πŸͺŸ Fix Windows Search Silently Skipping OneDrive Files Set to Free Up Space Because the Indexer Can’t Read Content From an Online-Only Placeholder Files On-Demand keeps a OneDrive file’s placeholder visible in File Explorer even after its content has been evicted from local disk to free up space, but that placeholder is only metadata – […]

Read More
Wordpress

WordPress: Fix a Multisite Subsite’s Uploads Pointing to the Wrong Domain Because the Site URL Was Changed After Content Already Existed

- 01.11.26 - ErcanOPAK comment on WordPress: Fix a Multisite Subsite’s Uploads Pointing to the Wrong Domain Because the Site URL Was Changed After Content Already Existed

πŸ“ Fix a Multisite Subsite’s Uploads Pointing to the Wrong Domain Because the Site URL Was Changed After Content Already Existed Every attachment URL inserted into a WordPress multisite subsite’s post content is written out as a full absolute URL at the moment it’s inserted, built from that subsite’s site URL as it existed at […]

Read More
Kubernetes

Kubernetes: Fix a ConfigMap Mounted With a subPath Never Picking Up Updates Because subPath Mounts Skip the Kubelet’s Live Sync

- 01.11.26 - ErcanOPAK comment on Kubernetes: Fix a ConfigMap Mounted With a subPath Never Picking Up Updates Because subPath Mounts Skip the Kubelet’s Live Sync

☸️ Fix a ConfigMap Mounted With a subPath Never Picking Up Updates Because subPath Mounts Skip the Kubelet’s Live Sync A ConfigMap mounted as a whole directory gets refreshed automatically by the kubelet, which periodically re-syncs the mounted files whenever the ConfigMap’s contents change, letting an application that watches its config directory for file changes […]

Read More
JavaScript

JavaScript: Fix Array.prototype.sort() Producing a Different Order in Two Browsers Because the Compare Function Returns NaN for Equal Elements

- 01.11.26 - ErcanOPAK comment on JavaScript: Fix Array.prototype.sort() Producing a Different Order in Two Browsers Because the Compare Function Returns NaN for Equal Elements

⚑ Fix Array.prototype.sort() Producing a Different Order in Two Browsers Because the Compare Function Returns NaN for Equal Elements Array.prototype.sort() expects its compare function to return a negative number, zero, or a positive number, and the specification leaves the sort’s exact behavior unspecified the moment the compare function returns anything else, including NaN, which commonly […]

Read More
C#

C#: Fix a ReferenceEquals-Based Cache Check Silently Matching Two Unrelated Strings Because the Compiler Interned Them to the Same Object

- 01.11.26 - ErcanOPAK comment on C#: Fix a ReferenceEquals-Based Cache Check Silently Matching Two Unrelated Strings Because the Compiler Interned Them to the Same Object

πŸ”§ Fix a ReferenceEquals-Based Cache Check Silently Matching Two Unrelated Strings Because the Compiler Interned Them to the Same Object The C# compiler interns every string literal that appears directly in source code, meaning two separate literals with identical text anywhere in the same assembly, or even across assemblies sharing the same intern pool at […]

Read More
Visual Studio

Visual Studio: Fix the Object Browser Showing a Type as Missing Members Because It’s Reading a Reference Assembly Instead of the Implementation Assembly

- 01.11.26 - ErcanOPAK comment on Visual Studio: Fix the Object Browser Showing a Type as Missing Members Because It’s Reading a Reference Assembly Instead of the Implementation Assembly

πŸ› οΈ Fix the Object Browser Showing a Type as Missing Members Because It’s Reading a Reference Assembly Instead of the Implementation Assembly The Object Browser, Go To Definition, and IntelliSense can each resolve a type from a different assembly depending on what’s fastest to load, and for a project that produces reference assemblies as part […]

Read More
AI

The AI Prompt That Reviews an Idempotency Key Implementation for Requests That Can Still Slip Through Without One

- 01.11.26 - ErcanOPAK comment on The AI Prompt That Reviews an Idempotency Key Implementation for Requests That Can Still Slip Through Without One

πŸ€– The AI Prompt That Reviews an Idempotency Key Implementation for Requests That Can Still Slip Through Without One Idempotency keys are supposed to guarantee that retrying the same request, whether because a client timed out and resent it or a mobile app’s double-tap fired the same action twice, never charges a card twice or […]

Read More
Asp.Net Core

ASP.NET Core: Fix a Typed HttpClient Reusing Stale DNS Results Because SocketsHttpHandler’s Connection Lifetime Was Never Set

- 01.11.26 - ErcanOPAK comment on ASP.NET Core: Fix a Typed HttpClient Reusing Stale DNS Results Because SocketsHttpHandler’s Connection Lifetime Was Never Set

βš™οΈ Fix a Typed HttpClient Reusing Stale DNS Results Because SocketsHttpHandler’s Connection Lifetime Was Never Set A typed HttpClient registered through AddHttpClient is built on SocketsHttpHandler, which pools and reuses underlying TCP connections aggressively for performance, keeping a connection open and reusing it for many requests rather than resolving DNS and reconnecting every time – […]

Read More
Git

Git: Fix git log Missing Commits You Know Exist Because a Shallow Clone’s –depth Cut the History Short Before Reaching Them

- 01.11.26 - ErcanOPAK comment on Git: Fix git log Missing Commits You Know Exist Because a Shallow Clone’s –depth Cut the History Short Before Reaching Them

πŸ”€ Fix git log Missing Commits You Know Exist Because a Shallow Clone’s –depth Cut the History Short Before Reaching Them A shallow clone made with –depth N intentionally keeps only the most recent N commits of history on the branch it fetches, which is exactly why CI pipelines use it to speed up checkouts, […]

Read More
C#

C#: Fix Code Holding a Reference to an Array Element Silently Pointing at the Old Array After Array.Resize Allocates a New One

- 01.11.26 - ErcanOPAK comment on C#: Fix Code Holding a Reference to an Array Element Silently Pointing at the Old Array After Array.Resize Allocates a New One

πŸ”§ Fix Code Holding a Reference to an Array Element Silently Pointing at the Old Array After Array.Resize Allocates a New One Array.Resize looks, from its name, like it grows or shrinks the array in place, but a C# array’s length is fixed at the moment it’s created and can never actually change – what […]

Read More
AI

The AI Prompt That Turns a Closet Full of Clothes Into a Capsule Wardrobe You’ll Actually Wear

- 01.11.26 - ErcanOPAK comment on The AI Prompt That Turns a Closet Full of Clothes Into a Capsule Wardrobe You’ll Actually Wear

πŸ€– The AI Prompt That Turns a Closet Full of Clothes Into a Capsule Wardrobe You’ll Actually Wear A closet that’s accumulated for years usually has far more clothes in it than anyone can actually remember owning, let alone combine into outfits on a busy morning, and the usual advice to “build a capsule wardrobe” […]

Read More
Wordpress

WordPress: Fix the Media Library Showing Broken Thumbnails After a Migration Because the Image Sizes Were Never Regenerated for the New Server

- 01.11.26 - ErcanOPAK comment on WordPress: Fix the Media Library Showing Broken Thumbnails After a Migration Because the Image Sizes Were Never Regenerated for the New Server

πŸ“ Fix the Media Library Showing Broken Thumbnails After a Migration Because the Image Sizes Were Never Regenerated for the New Server WordPress stores the pixel dimensions it’s configured to generate for thumbnail, medium, and any theme- or plugin-registered custom image size as metadata attached to each attachment at upload time, but it does not […]

Read More
C#

C#: Fix a CancellationTokenSource Leak Because CancelAfter Keeps Its Internal Timer Alive Even After the Operation Already Completed

- 01.11.26 - ErcanOPAK comment on C#: Fix a CancellationTokenSource Leak Because CancelAfter Keeps Its Internal Timer Alive Even After the Operation Already Completed

πŸ”§ Fix a CancellationTokenSource Leak Because CancelAfter Keeps Its Internal Timer Alive Even After the Operation Already Completed Calling CancelAfter on a CancellationTokenSource schedules an internal Timer that will fire and cancel the token once the specified delay elapses, and that timer keeps running in the background regardless of whether the operation it was meant […]

Read More
Windows

Windows 11: Fix Focus Assist Muting Notifications You Still Want Because Game Mode Auto-Detected a Non-Game App as Fullscreen

- 01.11.26 - ErcanOPAK comment on Windows 11: Fix Focus Assist Muting Notifications You Still Want Because Game Mode Auto-Detected a Non-Game App as Fullscreen

πŸͺŸ Fix Focus Assist Muting Notifications You Still Want Because Game Mode Auto-Detected a Non-Game App as Fullscreen Focus Assist’s automatic rule for suppressing notifications while playing a fullscreen game works by detecting when a fullscreen exclusive or borderline-fullscreen application takes over the display, not by checking whether that application is actually a game, and […]

Read More
Photoshop

Photoshop: Fix a Recorded Action Skipping Steps on Playback Because It Recorded a Modal Tool Dialog That Doesn’t Reopen Automatically

- 01.11.26 - ErcanOPAK comment on Photoshop: Fix a Recorded Action Skipping Steps on Playback Because It Recorded a Modal Tool Dialog That Doesn’t Reopen Automatically

πŸ–ŒοΈ Fix a Recorded Action Skipping Steps on Playback Because It Recorded a Modal Tool Dialog That Doesn’t Reopen Automatically The Actions panel records most tool operations as a direct command with its final settings baked in, but a handful of dialog-driven steps, like Image Size with a specific interpolation method chosen by hand, or […]

Read More
AI

The AI Prompt That Reviews a File Upload Endpoint for Ways a Client Can Bypass Its Declared Size Limit

- 01.11.26 - ErcanOPAK comment on The AI Prompt That Reviews a File Upload Endpoint for Ways a Client Can Bypass Its Declared Size Limit

πŸ€– The AI Prompt That Reviews a File Upload Endpoint for Ways a Client Can Bypass Its Declared Size Limit A file upload endpoint’s declared size limit is usually enforced in exactly one place, like a Content-Length header check or a framework setting capping the request body, and it’s easy to assume that single check […]

Read More
Asp.Net Core

ASP.NET Core: Fix a Background IHostedService Never Stopping Gracefully Because StopAsync Ignores the CancellationToken It’s Given

- 01.11.26 - ErcanOPAK comment on ASP.NET Core: Fix a Background IHostedService Never Stopping Gracefully Because StopAsync Ignores the CancellationToken It’s Given

βš™οΈ Fix a Background IHostedService Never Stopping Gracefully Because StopAsync Ignores the CancellationToken It’s Given The host calls StopAsync on every registered IHostedService during shutdown and passes it a CancellationToken that gets canceled once the configured shutdown timeout elapses, which exists specifically so a service that’s taking too long to stop can be told, in […]

Read More
HTML

HTML5: Fix a Date Input Field Silently Resetting to Empty Because the Browser’s Locale Formats Days Before Months

- 01.11.26 - ErcanOPAK comment on HTML5: Fix a Date Input Field Silently Resetting to Empty Because the Browser’s Locale Formats Days Before Months

🧩 Fix a Date Input Field Silently Resetting to Empty Because the Browser’s Locale Formats Days Before Months A native date input field always stores and submits its value in a fixed, locale-independent yyyy-mm-dd format internally, but it DISPLAYS that value to the user formatted according to the browser’s current locale, which can order the […]

Read More
SQL

SQL Server: Fix Change Data Capture Silently Stopping Because the Transaction Log Was Truncated Before the Capture Job Could Read It

- 01.11.26 - ErcanOPAK comment on SQL Server: Fix Change Data Capture Silently Stopping Because the Transaction Log Was Truncated Before the Capture Job Could Read It

πŸ—„οΈ Fix Change Data Capture Silently Stopping Because the Transaction Log Was Truncated Before the Capture Job Could Read It Change Data Capture relies on its capture job reading committed changes out of the transaction log asynchronously, after the fact, rather than capturing them synchronously at commit time, which is exactly what keeps CDC’s overhead […]

Read More
Git

Git: Fix a Tag Still Pointing at the Old Commit After a Rebase Because Tags Never Move With the Commits They Used to Mark

- 01.11.26 - ErcanOPAK comment on Git: Fix a Tag Still Pointing at the Old Commit After a Rebase Because Tags Never Move With the Commits They Used to Mark

πŸ”€ Fix a Tag Still Pointing at the Old Commit After a Rebase Because Tags Never Move With the Commits They Used to Mark A lightweight or annotated tag is a fixed pointer to one specific commit’s hash, created the moment the tag command runs, and it has no ongoing relationship to that commit beyond […]

Read More
Photoshop

Photoshop: Fix the Patch Tool Leaving a Faint Seam Because Sample All Layers Was Left Checked While Patching Across a Multi-Layer Composite

- 01.11.26 - ErcanOPAK comment on Photoshop: Fix the Patch Tool Leaving a Faint Seam Because Sample All Layers Was Left Checked While Patching Across a Multi-Layer Composite

πŸ–ŒοΈ Fix the Patch Tool Leaving a Faint Seam Because Sample All Layers Was Left Checked While Patching Across a Multi-Layer Composite With Sample All Layers turned on, the Patch Tool blends its source texture from the merged, flattened appearance of every visible layer beneath the patch area rather than from a single layer’s actual […]

Read More
Ajax

Ajax: Fix a fetch() Upload Silently Stalling at 99% Because the Request Body Is a Stream the Server Never Fully Drains

- 01.11.26 - ErcanOPAK comment on Ajax: Fix a fetch() Upload Silently Stalling at 99% Because the Request Body Is a Stream the Server Never Fully Drains

πŸ”„ Fix a fetch() Upload Silently Stalling at 99% Because the Request Body Is a Stream the Server Never Fully Drains Passing a ReadableStream directly as a fetch() request body lets a large upload be sent in chunks without buffering the whole file in memory first, which is exactly what makes it attractive for big […]

Read More
CSS

CSS: Fix Container Queries Never Triggering Because the Parent Element Was Never Given an Explicit container-type

- 01.11.26 - ErcanOPAK comment on CSS: Fix Container Queries Never Triggering Because the Parent Element Was Never Given an Explicit container-type

🎨 Fix Container Queries Never Triggering Because the Parent Element Was Never Given an Explicit container-type A container query lets a component adapt its own layout based on the size of its nearest ancestor rather than the viewport, which is exactly what makes it useful for a component that gets reused in a wide sidebar […]

Read More
Ajax

Ajax: Fix an AbortController Signal Silently Not Canceling a Fetch Request Already Served From the Browser’s Disk Cache

- 01.11.26 - ErcanOPAK comment on Ajax: Fix an AbortController Signal Silently Not Canceling a Fetch Request Already Served From the Browser’s Disk Cache

πŸ”„ Fix an AbortController Signal Silently Not Canceling a Fetch Request Already Served From the Browser’s Disk Cache Calling abort() on an AbortController is supposed to reject the matching fetch promise with an AbortError, and for a real network request that’s exactly what happens. A request whose response is still fresh in the browser’s HTTP […]

Read More
AI

The AI Prompt That Turns a Group Trip’s Scattered Expense Receipts Into a Fair Per-Person Settle-Up

- 01.11.26 - ErcanOPAK comment on The AI Prompt That Turns a Group Trip’s Scattered Expense Receipts Into a Fair Per-Person Settle-Up

πŸ€– The AI Prompt That Turns a Group Trip’s Scattered Expense Receipts Into a Fair Per-Person Settle-Up A group trip usually ends with a pile of receipts split across whoever happened to pay at the time – one person covered the rental car, another grabbed dinner twice, someone else fronted the group grocery run – […]

Read More
Visual Studio

Visual Studio: Fix the Call Hierarchy Window Showing Zero Callers for a Method Because It Only Indexes Projects Targeting the Active Solution Configuration

- 01.11.26 - ErcanOPAK comment on Visual Studio: Fix the Call Hierarchy Window Showing Zero Callers for a Method Because It Only Indexes Projects Targeting the Active Solution Configuration

πŸ› οΈ Fix the Call Hierarchy Window Showing Zero Callers for a Method Because It Only Indexes Projects Targeting the Active Solution Configuration The Call Hierarchy window and Find All References both answer from the same Roslyn workspace, and that workspace only ever contains the projects the current active solution configuration actually builds. A leaner configuration […]

Read More
C#

C#: Fix a Custom Logger’s Interpolated String Handler Silently Evaluating Every Argument Even When Its Log Level Is Disabled

- 01.11.26 - ErcanOPAK comment on C#: Fix a Custom Logger’s Interpolated String Handler Silently Evaluating Every Argument Even When Its Log Level Is Disabled

πŸ”§ Fix a Custom Logger’s Interpolated String Handler Silently Evaluating Every Argument Even When Its Log Level Is Disabled A C# interpolated string handler only gets to skip evaluating the expressions inside the string’s holes when its constructor exposes an out bool parameter the compiler can check before it decides whether to emit the code […]

Read More
SQL

SQL Server: Fix Columnstore Compression Silently Degrading Because Frequent Small Updates Keep Rows Stuck in the Delta Store

- 01.11.26 - ErcanOPAK comment on SQL Server: Fix Columnstore Compression Silently Degrading Because Frequent Small Updates Keep Rows Stuck in the Delta Store

πŸ—„οΈ Fix Columnstore Compression Silently Degrading Because Frequent Small Updates Keep Rows Stuck in the Delta Store A columnstore index keeps newly inserted or updated rows in a row-oriented delta store until enough of them accumulate, usually around a million rows, for the background tuple mover to compress them into the efficient columnar format the […]

Read More
Page 1 of 3
1 2 3 Next Β»

Posts pagination

1 2 3 Next »
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 @ (609)
  • 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