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.
2026-11-02
1,918 reads
Articles
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.
2026-11-02
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.
2026-10-30
1,363 reads
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
2026-10-30 (first published: 2026-09-28)
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.
2026-10-30
MiniMax m3 and SQL Server
Learn how you can download and run a local model to help with your SQL Server work.
2026-10-26
3,003 reads
Strip double quotes from an import file in Integration Services SSIS
When loading data using SQL Server Integration Services (SSIS) to import data from a CSV file, every single one of the columns in the CSV file has double quotes around the data. When using the Data Flow Task to import the data I have double quotes around all of the imported data. How can I import the data and remove the double quotes?
2026-10-26
PostgreSQL in action with Opensearch
Learn about using Opensearch with PostgreSQL to improve performance and quickly return results to your users.
2026-10-23
1,542 reads
How to run PostgreSQL in Docker
Get PostgreSQL running in Docker in minutes with this step-by-step setup guide. Learn to pull the image and run a container
2026-10-23
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Learn how to use CHOOSE() and IIF() to validate priorities and return easy to read messages to the user.
2026-10-21
2,481 reads
Blogs
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
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