![[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.
Explains how SQL Server Query Store helps investigate performance issues after they occur by analyzing historical query plans and runtime behavior.
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.
Explains why SQL Server backup strategies must focus on recovery readiness, not just successful backups.
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 SQL Server blocking chains, head blockers, and why transaction duration matters more than the session itself for diagnosing performance issues.
Learn how to use the azqr sql-esu plugin to identify SQL Server end-of-life instances and estimate Extended Security Update costs.
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.
A technical post about removing the In-Memory OLTP (Hekaton) filegroup in SQL Server 2025, marking the end of the feature's journey.
An animated explanation of how SQL Server index seeks work, covering B-tree root pages, intermediate pages, and leaf pages.
Explains why high SQL Server CPU usage is a symptom, not a root cause, and how to diagnose the real issue before adding hardware.
Slides from a DataSaturday session on building a €100 data warehouse using Azure data platform.
A personal recap of Data Saturday Rheinland 2026, covering PostgreSQL, SQL Server, GenAI, and data literacy sessions.
Explains why SQL Server wait statistics indicate direction, not root cause, and warns against using them as a diagnosis.
SQL Server diagnostic queries for July 2026, covering configuration, performance, and T-SQL scripts for various versions.
