SQL Server Performance: Why Diagnosis Starts with the Problem
A guide on diagnosing SQL Server performance issues, emphasizing the importance of defining the problem precisely before analyzing data.
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.
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.
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.
SQL Server expert Brent Ozar answers community questions on database administration, tuning, and AI tools in a video from a cruise ship.
A 20-year Mac user shares insights on switching from Windows, managing SQL Server, and using jump boxes for IT work.
Updated SQL Server diagnostic queries for March 2026, including versions for various SQL Server editions and Azure SQL.
Guide on connecting Microsoft SQL Server to Dremio Cloud for federated analytics, avoiding ETL and reducing license costs.
Brent Ozar answers top-voted SQL Server questions from the community in a video Q&A session recorded in the Bahamas.
Updates to the SQL Server First Responder Kit and Consultant Toolkit, including new AI-powered query tuning and long-term performance tracking features.