Tag: transaction log

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

Azure SQL Managed Instance Gets Faster Log Writes, But a USB SSD Still Wins
12 Oct 2026 · 6 min read

Azure SQL Managed Instance Gets Faster Log Writes, But a USB SSD Still Wins

Azure SQL MI Business Critical log throughput is up to 160-192 MB/s. Here is what changed, how it affects sizing, and why a portable USB SSD still writes faster.

Read article →
How to Attach Only a Database MDF
16 May 2018 · 6 min read

How to Attach Only a Database MDF

Learn how to attach a SQL Server database using only the MDF file, without the original LDF log file, using two supported methods with key caveats explained.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.