Bjoern Peters, SQL Server expert and MVP, shares insights on database administration, performance tuning, and Azure SQL, combining decades of experience with community contributions.
27 articles from this blog
Explains how SQL Server Query Store helps investigate performance issues after they occur by analyzing historical query plans and runtime behavior.
Explains why SQL Server backup strategies must focus on recovery readiness, not just successful backups.
Explains SQL Server blocking chains, head blockers, and why transaction duration matters more than the session itself for diagnosing performance issues.
Explains why high SQL Server CPU usage is a symptom, not a root cause, and how to diagnose the real issue before adding hardware.
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.
Analysis of AWS Summit Japan 2026 focusing on Agentic AI, data platforms, and the operational infrastructure needed for reliable AI in production.
Explains why SQL Server monitoring alone isn't diagnosis and how context is crucial for interpreting performance signals.
Explains why SQL Server monitoring alerts alone are insufficient for stability, emphasizing interpretation and context.
How AI assists SQL Server consulting without replacing expert judgment, focusing on analysis and communication.
Guide to SQL Server bottleneck triage, distinguishing performance signals from actual root causes for effective troubleshooting.
A guide on diagnosing SQL Server performance issues, emphasizing the importance of defining the problem precisely before analyzing data.
Explores why SQL Server performance tuning often fails, focusing on systemic issues beyond indexes and queries.
Guidance on handling SQL Server 2016 end of support, emphasizing clarity over quick decisions on upgrade, migration, or Azure.
Article discusses SQL Server 2016 end of support on July 14, 2026, and what companies should review for security, compliance, and upgrade planning.
Guide to diagnosing and fixing SQL Server performance issues, covering common causes like poor queries, missing indexes, and blocking.
Identifies five common causes for sudden SQL Server slowdowns and explains how to diagnose them effectively.
A software architect's humorous account of a client derailing a professional Power BI dashboard project with a chaotic, self-built data model.
Part 3 of a series on SQL Server security, covering auditing, encryption, and secure development practices for DBAs.
A guide to troubleshooting and improving performance in slow SQL Server applications using structured techniques.
