Troubleshooting Slow Queries That Already Have an Index
This article looks at some common query patterns that cause performance issues and provides some guidance on how to fix them.
What I learned after a weekend of AI troubleshooting gone wrong (8 key lessons)
Grant Fritchey walks through a real troubleshooting saga – using Wine, a shim DLL, a misconfigured registry entry, and a lot of trial and error – to get a BridgeCom Maverick radio’s Windows CPS running on Linux Mint.
PostgreSQL 19 Is Late
Steve notes that PostgreSQL 19 is late, but the reasons and implications extend to other platforms, and really, all other software.
Calculating Weighted Average in Power BI
Learn how you can add a weighted average to your Power BI Calculations, a function that is not built into DAX.
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
Why your schema shouldn’t mirror your database (and what to do instead)
In this guide, learn all about GraphQL: what it is, how it works, the problems it solves, and how to design the perfect schema – one that holds up as systems keep changing.
AI Is Improving Security
AI LLMs can help find bugs, especially security vulnerabilities, in code. That appears to be happening with SQL Server.
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Business Intelligence Architect, Data Analyst, CPA, and author Bill Pearson continues a subseries surrounding the DAX Text Functions, and breaks out the next operational group within Text functions, the “Combine and Aggregate Functions” group, including the CONCATENATE(), CONCATENATEX, and COMBINEVALUES() functions as the focus of this Level. He identifies and examines each functional member of this “Combine and Aggregate” group, discussing for each its respective syntax, uses, and operation, while providing hands-on exposure to it in Power BI.
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers