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.
64 articles from this blog
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.
Monthly job board for database professionals, August 2026 edition. Companies post data-related openings; readers can find roles and apply.
![[Video] Office Hours: Desert Database Q&A](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-0e79af01551b-full-097fc68a.webp)
Brent Ozar answers SQL Server questions on query plans, monitoring tools, AI, and more in a desert-themed Office Hours Q&A.
Brent Ozar shares lessons learned from using AI for backend automation, including adversarial development and cost-effective LLM strategies.
A reference check for IT professional Richie Rump, highlighting his skills in data architecture, problem-solving, and reliability.
A fun SQL Server quiz called 'Well, Actually…' to test database knowledge, built as a free WordPress plugin.
![[Video] Office Hours: Long Answers Edition](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-a9f3e37652de-full-5d20e9da.webp)
Brent Ozar answers database questions on HADR_SYNC_COMMIT waits, indexing strategies, RCSI, and SQL Server comparisons.
Explains database page splits with animations, their impact on writes and disk order, and historical context with hard drives.
T-SQL Tuesday roundup on warning signs of bad SQL queries, including WHILE loops, cursors, functions, and DISTINCT.
![[Video] What AI is Good For Right Now](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-f1167948fd71-full-d88fb130.webp)
Brent Ozar discusses what AI is good for, including black-and-white answers and inspiration, with Teachable's Managing Director.
An animated explanation of how SQL Server index seeks work, covering B-tree root pages, intermediate pages, and leaf pages.
![[Video] Office Hours: Ask Me Anything At Home](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-0d800ed8f7a8-full-4f385053.webp)
Brent Ozar answers top-voted SQL Server and database questions in an AMA video, covering AI opposition, rollback policies, certifications, and more.
A database expert reviews his 2018 predictions about SQL Server, cloud databases, and tech trends, assessing their accuracy.
A blog post listing database job opportunities for June 2026, with rules for employers to post positions and links to related hiring posts.
![[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.
Quarterly SQL Server adoption report showing version usage trends, server sizes, and data growth insights for Spring 2026.
Brent Ozar discovers a bug in SQL Server's sys.dm_exec_query_plan_stats where CPU and elapsed time values are swapped.
