GitHub

alter-database-scoped-configuration-transact-sql.md

> Different `DATABASE SCOPED CONFIGURATION` options are supported in different versions and platforms of the SQL Database Engine. This article describes **all** `DATABASE SCOPED CONFIGURATION` options ...
Hacker

Detecting Plan Regression in SQL Server Using Query Store

SQL Server DBA specializing in performance tuning and disaster recovery. Bad code rarely begins the cascade of most SQL Server performance problems. Typically, it begins with something that is much ...
IEEE

Technical Implementation, Optimization, and Evaluation of Server Memory Faults Prediction

Abstract: Server operation is fundamentally memory-centric. Nevertheless, despite decades of iterative advancements and optimizations in memory technology, latent memory faults continue to pose ...
Microsoft

Microsoft Services: Pricing Consistency Update

To simplify and provide clarity, Microsoft is introducing a consistent Extended Security Update pricing model so that customers pay the same list price regardless of: Deployment location: Azure, ...
Microsoft

Advancing agentic AI with Microsoft databases across a unified data estate

This week, we are excited to kick off SQLCon 2026 alongside FabCon in Atlanta. Bringing these SQL and Fabric communities together creates a unique opportunity to learn, connect, and share what’s next ...
GitHub

SQL Server Transaction Log Health Checkup

After experiencing weekly CDC failures caused by transaction log issues and logs suddenly chewing up disk space, I found myself repeatedly investigating the same questions: Why is the log so large?
IEEE

Advancements in SQL Query Optimization: A Review of Join Order and Index Selection

Abstract: Efficient SQL Query Optimization (QO) is a fundamental aspect of database management systems, aimed at enhancing query performance and reducing resource consumption typically involves ...