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

According to @_avichawla on Twitter, QueryWeaver is now available on GitHub as an open-source toolkit for optimizing graph-augmented retrieval and natural language queries over knowledge graphs, ...

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

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

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?

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