Archive

Wednesday, October 28, 2026
stories of the day

26stories
Azure SQL
Delete data in batches

Deleting 18 Million Rows in Azure SQL Without Downtime

Mitchel Sellers describes how he purged over 18 million historical rows from an S1-tier Azure SQL database by deleting small, committed batches instead of one large statement. The article covers batch sizing, clustered-key range selection, supporting indexes and production monitoring. It is a practical guide for any .NET developer planning a large data cleanup on a shared database.

PostgreSQL VS Code
Query your database in-editor
MDMicrosoft for Developers Blog Cynthia Zanoni Oct 26

PostgreSQL extension for VS Code: explore, query and troubleshoot

Microsoft's PostgreSQL extension brings connecting, browsing schemas, writing and running SQL, and asking GitHub Copilot about the connected database into VS Code. The post walks through four workflows, from exploring a first table to reviewing a performance recommendation. It is a practical guide for .NET developers who work against PostgreSQL and want to stay in their editor.

Feedback

Found a bug or have an idea? Your message lands straight in my inbox.

Type of message