Bjoern Peters, SQL Server expert and MVP, shares insights on database administration, performance tuning, and Azure SQL, combining decades of experience with community contributions.
31 articles from this blog
Why a successful SQL Server restore doesn't guarantee service recovery, and what to validate beyond database ONLINE status.
Discusses SQL Server workload placement, emphasizing workload analysis over platform labels for cloud vs on-premises decisions.
A guide to SQL Server health checks, focusing on small operational gaps that can become costly issues over time.
Evaluates SQL Server 2025 native vector search for production, covering architecture, storage footprint, and testing needs.
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.
