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,510 reads
Learn a quick way to calculate distances without resorting to spatial calculations.
2026-05-08
1,510 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
410 reads
2026-05-06 (first published: 2025-04-16)
1,663 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
61 reads
Learn about the latest version of SQL Server and get help installing it on your system.
2026-05-04
6,038 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
A short introduction to how deadlocks work and how you can affect their behavior inside your system.
2026-05-01
2,345 reads
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
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Tlp/WA.(+62 821°3111°179 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur,...
BCA KCP Buaran Raya Telp/WA.0851°8812°0691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
Tlp/WA.(+62 821°3111°179 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers