Inverted Polygons? How to Troubleshoot SQL Server’s Left Hand Rule
Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.
Sometimes your source...
2018-01-23
437 reads
Bert Wagner
Inverted Polygons? How to Troubleshoot SQL Server's Left Hand Rule
Last week we looked at how easy it is to import GeoJSON data into SQL Server's geography datatype.
Sometimes your source data won't be perfectly formatted for SQL Server's spatial...
2018-01-23
7 reads
Importing GeoJSON Earthquake Data Into SQL Server
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it's not likely to erupt any time soon, the park is constantly monitored for geological...
2018-01-16
4 reads
Importing GeoJSON Earthquake Data Into SQL Server
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it’s not likely to erupt any...
2018-01-16
1,116 reads
A Better Way To Script Database Objects
Photo by Andy Beales on Unsplash
Happy New Year! My New Year’s resolution for 2018 is to help you become a...
2018-01-09 (first published: 2018-01-02)
3,585 reads
I Have A SQL Login – Why Can’t I Connect?
This post is a response to this month’s T-SQL Tuesday prompt created by Arun Sirpal. Adam Machanic created T-SQL Tuesday...
2018-01-09
386 reads
I Have A SQL Login - Why Can't I Connect?
This post is a response to this month's T-SQL Tuesday prompt created by Arun Sirpal. Adam Machanic created T-SQL Tuesday as a way for SQL users to share ideas...
2018-01-09
4 reads
A Better Way To Script Database Objects
Happy New Year! My New Year's resolution for 2018 is to help you become a better SQL developer.
I want to start off with that today by showing you a...
2018-01-02
5 reads
SQL and NOT SQL: Best of 2017
Photo by Rick Meyers on UnsplashWith only a few days left in 2017, I thought it would be fun to do a year...
2017-12-26
418 reads
SQL and NOT SQL: Best of 2017
With only a few days left in 2017, I thought it would be fun to do a year in review post. Below you'll find some of my top 5...
2017-12-26
Blogs
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
Forums
Which Object Definitions Are Available?
Comments posted to this topic are about the item Which Object Definitions Are Available?
What's Your Theme Music?
Comments posted to this topic are about the item What's Your Theme Music?
T-SQL in SQL Server 2025: The PRODUCT Function
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Which Object Definitions Are Available?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers