Introduces Polecat, a .NET library that turns SQL Server 2025 into a document database, leveraging its native JSON support for improved developer productivity.
Analysis of SQL Server security issues, vulnerability disclosure challenges, and Microsoft's documentation gaps.
T-SQL Tuesday #199 explores moving data platforms back to on-premises, highlighting lost troubleshooting skills and infrastructure challenges.
SQL Server diagnostic queries for performance and configuration analysis, covering versions from 2005 to 2025 and Azure.
How AI assists SQL Server consulting without replacing expert judgment, focusing on analysis and communication.
![[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.
