planar/Euclidean/flat-earth and geography/ellipsoidal/round-earth are the two kinds of spatial data types

This has some notes on the them which I do not yet understand and this has an installer. This is T-SQL stuff.