Bjoern Peters, SQL Server expert and MVP, shares insights on database administration, performance tuning, and Azure SQL, combining decades of experience with community contributions.
16 articles from this blog
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.
A guide to optimizing SQL Server indexes for tables with high rates of data insertion, updates, and deletions to combat fragmentation.
Common issues with SQL date functions and practical solutions for developers and DBAs to avoid errors and improve query performance.
SQL Server 2019 has ended mainstream support, leaving users with only security patches. This article outlines the implications and next steps.
Microsoft updates SQLPackage with preview support for Parquet files in Azure Blob Storage, enhancing data management and provisioning capabilities.
Discusses a bug where DatabaseMailUserRole prevents SQL Server from starting after patching, based on MVP and customer reports.
A presentation recap on operating Azure SQL Managed Instance on-premises using Azure Arc-enabled Data Services, from the Cloud Summit 2021.
A speaker's experience and session details from presenting on Azure Arc Data Services at Data Saturday #14 in Oslo.
