Bjoern Peters, SQL Server expert and MVP, shares insights on database administration, performance tuning, and Azure SQL, combining decades of experience with community contributions.
10 articles from this blog
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.
