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 for Developers

AI

The AI Prompt That Generates a Complete .gitignore Tailored to Your Exact Project Stack

- 31.08.26 | 31.08.26 - ErcanOPAK comment on The AI Prompt That Generates a Complete .gitignore Tailored to Your Exact Project Stack

🤖 Stop Copy-Pasting a Generic .gitignore A generic .gitignore template misses project-specific files every time — a local settings folder your specific IDE creates, a cache directory your specific build tool uses — which is exactly how secrets and build artifacts end up committed by accident. A prompt that reasons about your ACTUAL stack does […]

Read More
AI

The AI Prompt That Turns a Slow SQL Query and Its Execution Plan Into a Prioritized Fix List

- 31.08.26 | 31.08.26 - ErcanOPAK comment on The AI Prompt That Turns a Slow SQL Query and Its Execution Plan Into a Prioritized Fix List

🤖 Paste the Query and the Plan — Get a Ranked Fix List A slow query’s execution plan contains the actual answer to why it’s slow, but reading one cold — scans vs seeks, cost percentages, missing index suggestions, warning icons — takes real expertise to interpret quickly. An AI prompt scoped to exactly that […]

Read More
AI

The AI Prompt That Turns a Vague Bug Report Into Reproduction Steps a Developer Can Actually Use

- 30.08.26 | 31.08.26 - ErcanOPAK comment on The AI Prompt That Turns a Vague Bug Report Into Reproduction Steps a Developer Can Actually Use

🤖 “It’s Broken” Isn’t a Bug Report — This Prompt Fixes That A bug report that says “the checkout page doesn’t work sometimes” costs a developer real time just to reproduce, before they can even start fixing anything. Turning a vague report into concrete, testable repro steps is exactly the kind of structured, exhaustive work […]

Read More
AI

The AI Prompt That Turns a Cryptic Regex Pattern Into a Readable, Documented Rewrite

- 30.08.26 | 31.08.26 - ErcanOPAK comment on The AI Prompt That Turns a Cryptic Regex Pattern Into a Readable, Documented Rewrite

🤖 Stop Guessing What Your Own Regex Does A regular expression you wrote six months ago (or copied from Stack Overflow) that now needs a fix is often faster to have an AI explain and rewrite than to decode character-by-character yourself — especially once lookaheads, backreferences, or nested groups are involved. 🎯 Why This Works […]

Read More
AI

The AI Prompt That Turns a Cryptic Stack Trace Into a Plain-English Root Cause in Seconds

- 30.08.26 | 31.08.26 - ErcanOPAK comment on The AI Prompt That Turns a Cryptic Stack Trace Into a Plain-English Root Cause in Seconds

🤖 One Prompt Reads the Stack Trace For You A raw stack trace is technically all the information you need to find a bug’s root cause — but reading twenty frames of framework internals to find the one line that’s actually yours takes real time. A well-scoped AI prompt does that triage instantly. 🎯 The […]

Read More
AI

The AI Prompt That Finds Race Conditions and Null-Reference Bugs Before They Reach Production

- 30.08.26 | 31.08.26 - ErcanOPAK comment on The AI Prompt That Finds Race Conditions and Null-Reference Bugs Before They Reach Production

🤖 One Prompt Catches What Code Review Misses Race conditions and null-reference bugs are two of the hardest bug classes for a human reviewer to spot by reading code top to bottom — they require mentally simulating timing and every call path at once. A structured AI prompt does that simulation for you before the […]

Read More
AI

The Code-Review Prompt That Catches Bugs Human Reviewers Miss

- 30.08.26 - ErcanOPAK comment on The Code-Review Prompt That Catches Bugs Human Reviewers Miss

🤖 5 Categories = Bulletproof Review Human code reviewers are great at architecture and readability, but tired eyes skim past off-by-one errors, missing null checks, and race conditions. This prompt turns an AI assistant into a systematic second reviewer that checks the specific categories humans skip when they’re rushing. 📌 The Prompt (Copy, Paste, Attach […]

Read More
AI

The One AI Prompt That Turns a Messy, Undocumented Codebase Into a Clear, Refactor-Ready Map

- 30.08.26 - ErcanOPAK comment on The One AI Prompt That Turns a Messy, Undocumented Codebase Into a Clear, Refactor-Ready Map

🤖 One Prompt = Instant Codebase Map Inheriting a legacy project with zero documentation is one of the most time-consuming situations in software development. Instead of manually reading thousands of lines file by file, use this single structured prompt to get an AI assistant to map the entire codebase for you in minutes. 📌 The […]

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