Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding which queries consume the most DTU…
Browsing: SQL
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…
It’s time for T-SQL Tuesday #198! T-SQL Tuesday is a monthly community blogging event started by Adam Machanic in 2009.…
This is Week 1 of PowerShell Strikes Back – a four-week May series for SQL Server DBAs who have dabbled…
This happened to me recently after being busy with non-data modeling tasks for a few weeks. I went to add…
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion architecture declaratively, but once you have…