Be careful, this one caused me problems the other day. The WKT (Well-Known Text) format does not match with the geography static function parameter positioning. Reference: Point (geography Data Type) – SQL Server | Microsoft Docs
select geography::Point(10 /*Lat*/, 91 /*Long*/, 4626).ToString() POINT (91 10)
Note that the static function accepts Lat, Long and the WKT format is reversed, accepting Long, Lat.