Explains SQL Server row vs page compression with animations, covering how each works and when to use them.
Explains how SQL Server Query Store helps investigate performance issues after they occur by analyzing historical query plans and runtime behavior.
Guide to tuning NVIDIA Triton Inference Server for throughput and latency using Perf Analyzer and Model Analyzer.
SQL Server diagnostic queries for July 2026, covering configuration, performance, and T-SQL scripts for various versions.
How AI assists SQL Server consulting without replacing expert judgment, focusing on analysis and communication.
![[Video] How to Tune Queries Fast](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-70e64f217f17-full-fc5a2926.webp)
Brent Ozar demonstrates using sp_BlitzCache and AI to quickly tune SQL Server queries by identifying bottlenecks and applying performance advice.
A guide on diagnosing SQL Server performance issues, emphasizing the importance of defining the problem precisely before analyzing data.
Brent Ozar details tactics for teaching his Dev-Prod Demon Hunters SQL performance session, including demos, checklists, and a new tool.
Explores why SQL Server performance tuning often fails, focusing on systemic issues beyond indexes and queries.
Identifies five common causes for sudden SQL Server slowdowns and explains how to diagnose them effectively.
March 2026 update for SQL Server First Responder Kit adds AI-powered index advice and automated code review fixes.
![[Video] Office Hours, Standing in the Ocean Edition](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-d4626251b58f-full-d0df0a7f.webp)
A Q&A video covering SQL Server topics like stats maintenance, XE, certifications, upgrades, and database management.
![[Video] Office Hours: Back in the Bahamas Edition](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-485d424b228f-full-9ec268b8.webp)
SQL Server expert Brent Ozar answers community questions on database administration, tuning, and AI tools in a video from a cruise ship.
Updated SQL Server diagnostic queries for March 2026, including versions for various SQL Server editions and Azure SQL.
Updates to the SQL Server First Responder Kit and Consultant Toolkit, including new AI-powered query tuning and long-term performance tracking features.
A SQL expert details the strategy for designing an interactive conference session on solving query performance differences between development and production databases.
Updated SQL Server diagnostic queries for February 2026, with fixes and improvements for various SQL Server and Azure versions.
A developer details optimizing a PHP script to process 11 million database rows in seconds, focusing on SQL query batching and moving logic to PHP.
Updated SQL Server diagnostic queries for January 2026, covering multiple versions and Azure services for performance and configuration analysis.
A developer reflects on the rarity of challenging frontend performance work in React projects and the industry's bias towards high-powered devices.
