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.
50 articles from this blog
![[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.
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.
