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: Database Migrations

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 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 Whether a Database Index Migration Will Lock a Production Table Long Enough to Cause an Outage

- 30.10.26 - ErcanOPAK comment on The AI Prompt That Checks Whether a Database Index Migration Will Lock a Production Table Long Enough to Cause an Outage

🤖 The AI Prompt That Checks Whether a Database Index Migration Will Lock a Production Table Long Enough to Cause an Outage Index migrations get reviewed for correctness far more often than for how long they’ll hold a lock on a live table, because the DDL usually looks completely routine. This prompt forces an AI […]

Read More
AI

The AI Prompt That Reviews a Database Migration Script for Risky, Irreversible Changes

- 05.09.26 - ErcanOPAK comment on The AI Prompt That Reviews a Database Migration Script for Risky, Irreversible Changes

🤖 Have AI Flag the Irreversible Part of Your Migration Before You Run It A database migration script mixes safe, additive changes (a new nullable column) with genuinely risky, hard-to-undo ones (dropping a column, renaming a table, a data-destroying transformation) in the same file – and it’s easy to review the whole thing with the […]

Read More
Asp.Net Core

Step-by-Step: Create ASP.NET Core 8 Web API with Docker and PostgreSQL

- 19.08.26 | 19.08.26 - ErcanOPAK comment on Step-by-Step: Create ASP.NET Core 8 Web API with Docker and PostgreSQL

Complete guide to building a production-ready Web API with ASP.NET Core 8, Entity Framework Core, PostgreSQL, and Docker. Step 1: Create the Project # Create new Web API project dotnet new webapi -n ProductAPI –no-https cd ProductAPI # Add required packages dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL dotnet add package Microsoft.EntityFrameworkCore.Design dotnet add package Microsoft.EntityFrameworkCore.Tools dotnet add […]

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