![[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.
Guide to SQL Server bottleneck triage, distinguishing performance signals from actual root causes for effective troubleshooting.
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://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.
EF Core 11.0 now allows mapping temporal period columns to CLR properties, improving SQL Server Temporal Tables support.
Free webinar on SQL Server columnstore indexes basics, including demo scripts and table creation.
SQL Server diagnostic queries for May 2026, covering configuration, performance, and memory analysis for multiple SQL Server versions.
Explores a security bug in SQL Server 2025 where EXTERNAL MODEL permissions persist after dropping a user, risking unintended access.
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.
Analysis of ##MS_DatabaseManager## privilege escalation in SQL Server, focusing on ownership-based security model flaws.
Explains newly discovered SQL Server privilege escalation paths from DatabaseManager role to sysadmin, including attack details and mitigation.
SQL Server diagnostic queries for performance and configuration analysis, updated for April 2026.
Identifies five common causes for sudden SQL Server slowdowns and explains how to diagnose them effectively.
