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
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.
