The author describes troubleshooting an Azure DevOps YAML pipeline error related to a local-exec provisioner in terraform, which failed to grant necessary permissions due to a missing Azure Active Directory Readers permission. They detail the root causes, error findings, and ultimately the adjustments made to resolve the issue, focusing on least privilege principles.
[HOWTO] Calculate distance between two points (coordinates) on Microsoft SQL Server
Microsoft SQL Server offers the STDistance method to calculate the shortest distance between two geography points with high accuracy.
