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
Career & Community Join Me at Day of Data Orlando Next Month By Brent Ozar · September 18, 2026 · 3 comments Next month on Saturday, October 17, I’ll
![[Video] Office Hours: Open Q&A for Microsoft Databases](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-3be7dc5b26d0-full-058dfe3d.webp)
[Video] Office Hours: Open Q&A for Microsoft Databases By Brent Ozar · September 17, 2026 · no comments Today I’m back in the home office, finishing u
Career & Community Live Class Enrollment Opens Soon – For Just $995! By Brent Ozar · September 16, 2026 · no comments I teach Microsoft SQL Server per
Brent Ozar debunks the myth that NOLOCK is safe with index seeks, showing how it can still return incorrect data.
![[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.
