Brent Ozar is a SQL Server performance expert and consultant who helps teams fix critical database slowdowns, improve reliability, and master SQL Server through hands-on consulting and world-class training.
60 articles from this blog
![[Video] Office Hours on Mount Charleston](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-57a8cdae8587-full-4a59080f.webp)
[Video] Office Hours on Mount Charleston By Brent Ozar · September 10, 2026 · no comments For this episode, I’m up in the mountains just outside Vegas
Performance Tuning Database Animations: How SQL Server’s JSON Indexes Work By Brent Ozar · September 9, 2026 · no comments By popular demand, SQL Serv
Learn why setting application names in SQL Server connection strings is crucial for monitoring and debugging, with practical examples and tips.
![[Video] Office Hours: Stoicism in the Home Office](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-845952edc10b-full-77b55bfd.webp)
[Video] Office Hours: Stoicism in the Home Office By Brent Ozar · September 4, 2026 · no comments I’m back in the home office this week, covering your
Performance Tuning Database Animations: The Interview Question Everybody Gets Wrong By Brent Ozar · September 3, 2026 · no comments No no, I’m not jus
Who’s Hiring Database People? September 2026 Edition By Brent Ozar · September 2, 2026 · 1 comment Is your company hiring for a database position as o
News & Opinion Free Webcast: You Shouldn’t Use SQL Agent for Batch Processes. By Brent Ozar · September 1, 2026 · 1 comment SQL Server Agent is a soli
Explains residual predicates in SQL Server execution plans, why they cause extra key lookups, and how to fix them with included columns.
Learn how to download and restore the Stack Overflow database dump into PostgreSQL for practice with real-world data.
A retrospective on Microsoft SQL Server user requests from 10 years ago, checking which top-voted features were actually built.
![[Video] Office Hours in the Home Bar](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-c63d03f43319-full-0a35f5e5.webp)
Brent Ozar answers database and career questions from his home bar, covering SQL Server topics like MAXDOP, migration risks, AI tools, and more.
Learn to play multi-player Texas Hold'Em poker using T-SQL stored procedures in Azure SQL DB, with commands to join, bet, fold, and more.
Explains SQL Server row vs page compression with animations, covering how each works and when to use them.
A nostalgic review of the original SQL Server debugger hardware, its features, and why it was so beloved.
![[Video] Office Hours in Zhengzhou, China](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-e11585f81937-full-6e69cd24.webp)
Brent Ozar answers DBA questions on SQL Server, tempdb, AI, and career advice from Zhengzhou, China.
Testing AI with an Office Hours question: local models vs cloud for automated podcast answers, focusing on SQL Server DBCC CHECKDB performance.
Explains why higher MaxDOP in SQL Server increases TempDB spills due to memory grant division across parallel threads.
Brent Ozar explains when to use temp tables instead of CTEs in T-SQL, using a performance example with SQL Server 2025.
![[Video] Office Hours: Car in the House Edition](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-b6c22bc628b8-full-47d765bc.webp)
Brent Ozar answers SQL Server questions in a video office hours session, covering topics like plan cache bloat, in-memory OLTP, index tuning, and more.
Brent Ozar explains why wide columns in SQL Server tables may not increase logical reads, using database animations and sp_tableoption.
