I tried to execute this query on my SQL Server 2008 R2 instance:
UPDATE ITEMS SET GEOG=geography::STPointFromText('POINT(0 90)', 4326);
SQL Server returned the following error:
System.FormatException: 24201: Latitude values must be between -90 and 90 degrees
I also tried
POINT(0 89.99) and got the same error.
How do I set a point to be the North Pole?