In theory, SQL Server performance monitoring is pretty simple: 1. Review the server’s top wait types, 2. Find the queries causing those wait types, 3. Fix those queries, or improve the way the server reacts to them (indexes, settings, etc.). But in practice, step 2 is awful because:
2026-05-13
SQL Server 2025 shipped without SSRS. If you're managing paginated reports, your options just narrowed; but they're not what most people think. I evaluated all 10 realistic migration paths. Here's an honest comparison, including the one I built.
2026-05-11
15,452 reads
Explore the mechanics of the SOFTMAX function in SQL Server. Transform scores into probabilities with this essential tool.
2026-05-11
Learn a quick way to calculate distances without resorting to spatial calculations.
2026-05-08
2,073 reads
Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025.
2026-05-08
2026-05-06 (first published: 2025-04-16)
1,703 reads
Learn how table valued parameter joins in SQL Server stored procedures can negatively impact query performance.
2026-05-06
You may have spotted we currently have some issues with spambots affecting our chat forums. We're working through this at speed to get the issues resolved and the offending posts removed. Please bear with us while we fix this, and please don't log into any spam post and attempt to view or download attached files.
2026-05-05
76 reads
Learn about the latest version of SQL Server and get help installing it on your system.
2026-05-04
7,109 reads
In my previous article, I discussed how to prepare for Microsoft certification exams. In this article, I’m covering what you should do when actually taking the exams.
2026-05-04
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Comments posted to this topic are about the item Representing Money
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Which types of currency does the money data type represent?
See possible answers