---
author: "Umesh Malik"
canonical: "https://umesh-malik.com/blog/tag/sql"
description: "Explore articles tagged with SQL by Umesh Malik — AI Engineer, LLM & GenAI Developer. Learn SQL best practices, practical tips, and in-depth guides."
title: "Umesh Malik's Blog - SQL Articles | SQL Tutorials"
tokens: 160
generator: "scripts/generate-page-markdown.mjs"
---

[← Back to Blog](https://umesh-malik.com/blog)

# SQL

1 article

 [![Dashboard-style cover showing Postgres migration operations sorted by lock severity from instant metadata change to full ACCESS EXCLUSIVE table lock](https://umesh-malik.com/blog/postgres-migration-safety-table-locks-cover.png)

Web Engineering • Sep 27, 2026

### Is Your Postgres Migration Safe? Catch the Table Lock First

Is your Postgres migration safe? Not if it takes ACCESS EXCLUSIVE on a hot table. The lock table and 5-step check that catches it before you run it.

8 min read

Read more →](https://umesh-malik.com/blog/postgres-migration-safety-table-locks)