SQL Server Geography data type is unlike other types simply because you don’t use it often. It’s not like varchar, int, float, or DateTime present in every table, at least in one type.
Do we need the SQL Server Geography data type? To make sense of something new, we need to answer three fundamental questions:
• What problems does it solve? The answer lies in use cases.
• What are the things involved in studying it? You will learn a few basic definitions and acronyms. I collected only the important stuff, so it won’t bore you.
• Are there examples to further explain how it works and is it easy to implement? Our kind lives with code. We eat and sleep with it. So, we’re going to have sample codes in this post.