![[Video] Office Hours: Ask Me Anything At Home](https://allblogs.blob.core.windows.net/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.
Explains why Skip/Take pagination in EF Core fails on large, concurrent tables and introduces keyset pagination as a better alternative.
![[Video] How to Tune Queries Fast](https://allblogs.blob.core.windows.net/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.
EF Core 11.0 now allows mapping temporal period columns to CLR properties, improving SQL Server Temporal Tables support.
EF Core 11.0 introduces JsonPathExists and JsonContains for querying JSON columns without raw SQL.
A guide on diagnosing SQL Server performance issues, emphasizing the importance of defining the problem precisely before analyzing data.
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.
Author discusses attending and presenting at SQLBits 2026, focusing on Columnstore Indexes and a cloud panel.
Explores why SQL Server performance tuning often fails, focusing on systemic issues beyond indexes and queries.
Daily tech links covering .NET 11 Preview 3, AI agents, WPF migration, Visual Studio updates, and web development best practices.
Identifies five common causes for sudden SQL Server slowdowns and explains how to diagnose them effectively.
![[Video] Office Hours in North Bay, Ontario](https://allblogs.blob.core.windows.net/alldevblogs/thumbs/article-22a9801d2908-full-422eb208.webp)
Brent Ozar answers top-voted SQL Server DBA questions in a video Q&A session, covering storage, tools, careers, and AI.
March 2026 update for SQL Server First Responder Kit adds AI-powered index advice and automated code review fixes.
PasteThePlan.com now offers free AI-powered SQL query optimization advice using ChatGPT 5.3 to analyze execution plans.
Announcing a beginner-friendly webinar series on SQL Server indexing concepts, starting with clustered indexes.
![[Video] Office Hours, Standing in the Ocean Edition](https://allblogs.blob.core.windows.net/alldevblogs/thumbs/article-d4626251b58f-full-d0df0a7f.webp)
A Q&A video covering SQL Server topics like stats maintenance, XE, certifications, upgrades, and database management.
A guide on using Claude Code AI tool to automate SQL Server and Azure SQL DB tasks, including code changes and Github integration.
Explains why logical reads are not repeatable when using columnstore indexes in SQL Server, challenging a common tuning assumption.
