Endjin - Home

SQL Server

Using Python inside SQL Server

by Ed Freeman

Hello everyone. Before Christmas I played around with SQL Server 2017’s inline Python integration capability. This capability was announced early last year, with the corresponding integration with R already being possible for a number of months. The main benefits from this are the abilities to: Eliminate data movement (having to transfer data samples from a database to […]


If you’ve been using TeamCity for a number of years, there will come a time where the server it’s running on will reach its end of life and your TeamCity instance will need to be moved to a fresh server. As part of this migration process, you may decide to change OS from Linux to […]


Calculating Distance using SQL Server Spatial CLR Types

by Howard van Rooijen

I created a quick sample to solve a problem today and thought I’d post the code as it took me a while to track down all the relevant bits of information. The problem I wanted to solve was that I needed to be able to geocode a user’s postcode and then calculate the distance between their […]