As part of my wider work exploring Claude Code and AI-assisted database engineering, I have been looking at how AI…
Browsing: SQL
Train WreckThe last time I watched a high school band nearly fall apart mid-performance was when the relatively new, certainly…
Track SQL Server Configuration Changes Using the Error LogIf you work with SQL Server long enough, you or someone will…
This is Week 2 of PowerShell Strikes Back – a four-week May series for SQL Server DBAs who have dabbled…
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding which queries consume the most DTU…
PlanTrace Now Supports PostgreSQLThe same plan analysis you know from Redshift, now for PostgreSQL — including EXPLAIN ANALYZE, buffer stats,…
I’m doing a small series on indexing basics for SQL Server, and on May 14th I’ll be presenting the third…
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same frustrating issue. Applications and SSMS sessions…
Jan Laš joined HOPI as CIO with a pragmatic view of technology: it should solve real problems for real people, and the measure of success…
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing ThemIntroducing PlanTrace — a free, browser-based tool that turns raw execution plans…