How to Calculate Distance Between Coordinates in SQL Server
Learn a quick way to calculate distances without resorting to spatial calculations.
2026-05-08
1,234 reads
Articles
Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL?
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
404 reads
2026-05-06 (first published: 2025-04-16)
1,658 reads
SQL Server Table-Valued Parameter Join Issues in Stored Procedures
Learn how table valued parameter joins in SQL Server stored procedures can negatively impact query performance.
2026-05-06
SSC Spam
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
59 reads
What is New in SQL Server 2025
Learn about the latest version of SQL Server and get help installing it on your system.
2026-05-04
5,919 reads
How to pass Microsoft certification exams: tips and guidance
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
Understanding Deadlock Victim Selection in SQL Server
A short introduction to how deadlocks work and how you can affect their behavior inside your system.
2026-05-01
2,335 reads
Net Present Value and Internal Rate of Return in SQL Server
Many organizations store cash-flow data inside SQL Server and decision-makers often need metrics like Net Present Value (NPV) and Internal Rate of Return (IRR) to evaluate those cash flows. Is it possible to calculate NPV and IIR values in SQL Server without the use of external tools?
2026-05-01
Blogs
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers