When creating spacial geography point in sql server, the longitude comes first (lng, lat). I always thought it would be latitude then longitude.

Interestingly, some points that I've inserted passed the validation, but later I realized the values were swapped when I tried to query nearest neighbor and the points were no where near.