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

Tag: AI Prompts

AI

The AI Prompt That Reads a Lease Agreement and Flags Every Clause Stricter Than What’s Actually Legal in Your State

- 13.11.26 - ErcanOPAK comment on The AI Prompt That Reads a Lease Agreement and Flags Every Clause Stricter Than What’s Actually Legal in Your State

๐Ÿค– The AI Prompt That Reads a Lease Agreement and Flags Every Clause Stricter Than What’s Actually Legal in Your State Landlords and property management companies frequently reuse a lease template written for a different state, or one that predates a local tenant-protection law, and most renters have no realistic way to compare dozens of […]

Read More
AI

The AI Prompt That Reviews a Pull Request Diff Specifically for Race Conditions a Normal Code Review Would Miss

- 13.11.26 - ErcanOPAK comment on The AI Prompt That Reviews a Pull Request Diff Specifically for Race Conditions a Normal Code Review Would Miss

๐Ÿค– The AI Prompt That Reviews a Pull Request Diff Specifically for Race Conditions a Normal Code Review Would Miss A race condition rarely looks wrong when you read the changed lines in isolation โ€” the bug is almost always in the interaction between this diff and code elsewhere that runs concurrently with it, which […]

Read More
AI

The AI Prompt That Converts a Legacy SQL Stored Procedure Into Testable Application Code Without Changing Its Behavior

- 13.11.26 - ErcanOPAK comment on The AI Prompt That Converts a Legacy SQL Stored Procedure Into Testable Application Code Without Changing Its Behavior

๐Ÿค– The AI Prompt That Converts a Legacy SQL Stored Procedure Into Testable Application Code Without Changing Its Behavior Stored procedures accumulate business logic that nobody wants to touch because nothing about them is unit-testable โ€” the logic lives entirely inside the database, branches on parameters in ways that aren’t always obvious, and often has […]

Read More
AI

The AI Prompt That Replays a Database Migration Script Against Last Month’s Schema Snapshot and Flags Every Statement That Would Fail on an Older Environment

- 12.11.26 - ErcanOPAK comment on The AI Prompt That Replays a Database Migration Script Against Last Month’s Schema Snapshot and Flags Every Statement That Would Fail on an Older Environment

๐Ÿค– The AI Prompt That Replays a Database Migration Script Against Last Month’s Schema Snapshot and Flags Every Statement That Would Fail on an Older Environment Migration scripts are usually written and tested against whatever the schema looks like right now, which quietly assumes every environment that will ever run them is already caught up […]

Read More
AI

The AI Prompt That Reads a Stack Trace Logged in Three Different Formats at Once and Lines Up the Same Request Across All Three Automatically

- 12.11.26 - ErcanOPAK comment on The AI Prompt That Reads a Stack Trace Logged in Three Different Formats at Once and Lines Up the Same Request Across All Three Automatically

๐Ÿค– The AI Prompt That Reads a Stack Trace Logged in Three Different Formats at Once and Lines Up the Same Request Across All Three Automatically A single failing request in a system that’s grown organically often leaves its trail across logs that were never designed to be read together: an application log with its […]

Read More
AI

The AI Prompt That Reads Your Car’s Tire Sidewall and Tells You Exactly Which Replacement Sizes Are Actually Safe, Not Just the One Printed on the Tire

- 12.11.26 - ErcanOPAK comment on The AI Prompt That Reads Your Car’s Tire Sidewall and Tells You Exactly Which Replacement Sizes Are Actually Safe, Not Just the One Printed on the Tire

๐Ÿค– The AI Prompt That Reads Your Car’s Tire Sidewall and Tells You Exactly Which Replacement Sizes Are Actually Safe, Not Just the One Printed on the Tire A tire’s sidewall carries a dense code โ€” something like 225/45R17 91V โ€” that packs the tire’s width, aspect ratio, wheel diameter, load index, and speed rating […]

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
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
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
AI

The AI Prompt That Checks Your Feature Flags for a Stale One Still Gating Code a Previous Rollout Already Made Permanent

- 06.11.26 - ErcanOPAK comment on The AI Prompt That Checks Your Feature Flags for a Stale One Still Gating Code a Previous Rollout Already Made Permanent

๐Ÿค– The AI Prompt That Checks Your Feature Flags for a Stale One Still Gating Code a Previous Rollout Already Made Permanent A feature flag is meant to be temporary scaffolding โ€” ramp a change out, confirm it’s healthy, then delete the flag and the old code path it used to gate. In practice the […]

Read More
AI

The AI Prompt That Reads a Year of Utility Bills and Flags Which Months Had an Unexplained Usage Spike Worth Calling the Provider About

- 06.11.26 - ErcanOPAK comment on The AI Prompt That Reads a Year of Utility Bills and Flags Which Months Had an Unexplained Usage Spike Worth Calling the Provider About

๐Ÿค– The AI Prompt That Reads a Year of Utility Bills and Flags Which Months Had an Unexplained Usage Spike Worth Calling the Provider About A single high utility bill is easy to dismiss as “a hot month” or “we had guests,” but a genuine problem โ€” a leaking pipe, a failing appliance drawing constant […]

Read More
AI

The AI Prompt That Reviews Your Retry Logic for a Missing Idempotency Key So a Network Timeout Doesn’t Turn Into a Duplicate Charge

- 06.11.26 - ErcanOPAK comment on The AI Prompt That Reviews Your Retry Logic for a Missing Idempotency Key So a Network Timeout Doesn’t Turn Into a Duplicate Charge

๐Ÿค– The AI Prompt That Reviews Your Retry Logic for a Missing Idempotency Key So a Network Timeout Doesn’t Turn Into a Duplicate Charge A retry on a network timeout is only safe when the server can tell “this is the same request arriving again” apart from “this is a brand-new request” โ€” and it […]

Read More
AI

The AI Prompt That Turns a Neighborhood HOA’s Dense Bylaws Document Into a Plain-English FAQ Anyone Can Skim

- 05.11.26 - ErcanOPAK comment on The AI Prompt That Turns a Neighborhood HOA’s Dense Bylaws Document Into a Plain-English FAQ Anyone Can Skim

๐Ÿค– The AI Prompt That Turns a Neighborhood HOA’s Dense Bylaws Document Into a Plain-English FAQ Anyone Can Skim A homeowners’ association’s bylaws and covenants document can run forty to eighty dense pages of legal cross-references, and the actual answer to a specific question — can I put up a shed, do I need approval […]

Read More
AI

The AI Prompt That Checks Your Database Migration for a Column Drop With No Backward-Compatible Rollback Step

- 05.11.26 - ErcanOPAK comment on The AI Prompt That Checks Your Database Migration for a Column Drop With No Backward-Compatible Rollback Step

๐Ÿค– The AI Prompt That Checks Your Database Migration for a Column Drop With No Backward-Compatible Rollback Step A migration that drops a column is one of the few migration types you genuinely can’t undo by just running it in reverse — the moment ALTER TABLE … DROP COLUMN finishes, that column’s data is gone, […]

Read More
AI

The AI Prompt That Checks Your Soft-Delete Queries for a Forgotten WHERE Clause That Lets Deleted Rows Leak Back Into a Report

- 05.11.26 - ErcanOPAK comment on The AI Prompt That Checks Your Soft-Delete Queries for a Forgotten WHERE Clause That Lets Deleted Rows Leak Back Into a Report

๐Ÿค– The AI Prompt That Checks Your Soft-Delete Queries for a Forgotten WHERE Clause That Lets Deleted Rows Leak Back Into a Report A soft-delete pattern (a deleted_at timestamp or an is_deleted flag instead of an actual row removal) only works if every single read path across the codebase remembers to filter it out, and […]

Read More
AI

The AI Prompt That Finds Every Place Your API Silently Changes Behavior Based on Header Casing Because the Framework’s Header Lookup Isn’t Case-Insensitive Everywhere

- 04.11.26 - ErcanOPAK comment on The AI Prompt That Finds Every Place Your API Silently Changes Behavior Based on Header Casing Because the Framework’s Header Lookup Isn’t Case-Insensitive Everywhere

๐Ÿค– The AI Prompt That Finds Every Place Your API Silently Changes Behavior Based on Header Casing Because the Framework’s Header Lookup Isn’t Case-Insensitive Everywhere HTTP header names are defined by the spec to be case-insensitive โ€” Content-Type, content-type, and CONTENT-TYPE are supposed to mean exactly the same thing โ€” and most web frameworks’ built-in […]

Read More
AI

The AI Prompt That Turns a Pile of Kids’ Sports and Activity Schedules Into One Color-Coded Weekly Family Calendar

- 04.11.26 - ErcanOPAK comment on The AI Prompt That Turns a Pile of Kids’ Sports and Activity Schedules Into One Color-Coded Weekly Family Calendar

๐Ÿค– The AI Prompt That Turns a Pile of Kids’ Sports and Activity Schedules Into One Color-Coded Weekly Family Calendar Youth sports and activity schedules tend to arrive as a pile of unrelated PDFs, team app screenshots, and group-chat messages โ€” one per kid, per season, per activity โ€” and reconciling them by hand into […]

Read More
AI

The AI Prompt That Finds Every Discarded Task in Your Codebase Whose Exception Would Otherwise Vanish Into the Void

- 04.11.26 - ErcanOPAK comment on The AI Prompt That Finds Every Discarded Task in Your Codebase Whose Exception Would Otherwise Vanish Into the Void

๐Ÿค– The AI Prompt That Finds Every Discarded Task in Your Codebase Whose Exception Would Otherwise Vanish Into the Void Calling an async method and never awaiting, storing, or otherwise observing the Task it returns โ€” a bare Task.Run(…) with no assignment, a fire-and-forget call at the end of a method, a _ = SomeAsync() […]

Read More
AI

The AI Prompt That Audits Your Outbox Pattern Implementation for Messages Published Before the Transaction That Wrote Them Actually Commits

- 02.11.26 - ErcanOPAK comment on The AI Prompt That Audits Your Outbox Pattern Implementation for Messages Published Before the Transaction That Wrote Them Actually Commits

๐Ÿค– The AI Prompt That Audits Your Outbox Pattern Implementation for Messages Published Before the Transaction That Wrote Them Actually Commits A transactional outbox writes an event row into an outbox table in the exact same database transaction as the business change it represents, then a separate relay process reads unpublished rows and sends them […]

Read More
AI

The AI Prompt That Turns a Homeowner’s Stack of Contractor Renovation Quotes Into One Apples-to-Apples Comparison Table

- 02.11.26 - ErcanOPAK comment on The AI Prompt That Turns a Homeowner’s Stack of Contractor Renovation Quotes Into One Apples-to-Apples Comparison Table

๐Ÿค– The AI Prompt That Turns a Homeowner’s Stack of Contractor Renovation Quotes Into One Apples-to-Apples Comparison Table Renovation quotes from different contractors almost never itemize the same way โ€” one bundles materials and labor into a single line, another breaks out permits and disposal separately, a third quotes an allowance for fixtures that isn’t […]

Read More
AI

The AI Prompt That Reviews Your Pagination Cursor Design for Cases Where a Deleted Row Shifts Every Later Page

- 02.11.26 - ErcanOPAK comment on The AI Prompt That Reviews Your Pagination Cursor Design for Cases Where a Deleted Row Shifts Every Later Page

๐Ÿค– The AI Prompt That Reviews Your Pagination Cursor Design for Cases Where a Deleted Row Shifts Every Later Page Offset-based pagination recalculates each page as a fresh slice of whatever rows currently exist, so a row deleted (or inserted) between two page requests shifts every row after it by one position โ€” a client […]

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
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
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
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
AI

The AI Prompt That Reviews a Pagination Implementation for Pages That Skip or Repeat Rows When New Rows Are Inserted Mid-Scroll

- 01.11.26 - ErcanOPAK comment on The AI Prompt That Reviews a Pagination Implementation for Pages That Skip or Repeat Rows When New Rows Are Inserted Mid-Scroll

๐Ÿค– The AI Prompt That Reviews a Pagination Implementation for Pages That Skip or Repeat Rows When New Rows Are Inserted Mid-Scroll Offset-based pagination assumes the underlying result set stays still between one page request and the next, and that assumption quietly breaks the moment new rows get inserted, or old ones deleted, while a […]

Read More
AI

The AI Prompt That Audits a Webhook Handler for Payloads It Silently Drops When Two Events Arrive in the Same Millisecond

- 01.11.26 - ErcanOPAK comment on The AI Prompt That Audits a Webhook Handler for Payloads It Silently Drops When Two Events Arrive in the Same Millisecond

๐Ÿค– The AI Prompt That Audits a Webhook Handler for Payloads It Silently Drops When Two Events Arrive in the Same Millisecond Webhook handlers are usually tested one event at a time, which hides a whole class of bugs that only show up when two notifications for the same entity land close enough together that […]

Read More
AI

The AI Prompt That Reviews a Rate Limiter for Buckets That Never Reset Because Replicas Don’t Share the Same Clock Source

- 01.11.26 - ErcanOPAK comment on The AI Prompt That Reviews a Rate Limiter for Buckets That Never Reset Because Replicas Don’t Share the Same Clock Source

๐Ÿค– The AI Prompt That Reviews a Rate Limiter for Buckets That Never Reset Because Replicas Don’t Share the Same Clock Source A token-bucket or fixed-window rate limiter’s correctness depends on every replica agreeing on roughly the same notion of “now,” and that assumption quietly breaks in more ways than clock drift between servers: a […]

Read More
AI

The AI Prompt That Audits a Caching Layer for Keys That Never Get Invalidated When the Underlying Row Changes

- 01.11.26 - ErcanOPAK comment on The AI Prompt That Audits a Caching Layer for Keys That Never Get Invalidated When the Underlying Row Changes

๐Ÿค– The AI Prompt That Audits a Caching Layer for Keys That Never Get Invalidated When the Underlying Row Changes Cache invalidation bugs are notorious precisely because the cache itself never complains โ€” it just keeps confidently serving a value that used to be correct, and the only symptom is a user or a downstream […]

Read More
AI

The AI Prompt That Turns a Family Reunion’s RSVP Spreadsheet and Dietary Notes Into a Headcount-Accurate Catering Order

- 01.11.26 - ErcanOPAK comment on The AI Prompt That Turns a Family Reunion’s RSVP Spreadsheet and Dietary Notes Into a Headcount-Accurate Catering Order

๐Ÿค– The AI Prompt That Turns a Family Reunion’s RSVP Spreadsheet and Dietary Notes Into a Headcount-Accurate Catering Order A family reunion’s RSVP list usually ends up as a messy spreadsheet or a thread of replies collected over weeks, where “bringing the kids” means a different headcount for every family, dietary notes get mentioned once […]

Read More
Page 1 of 4
1 2 3 4 Next ยป

Posts pagination

1 2 3 4 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 (981)
  • 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 (858)
  • 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 (547)
  • 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 (981)
  • 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 (858)
  • 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