Endjin - Home

SQL Server

Using Python inside SQL Server

by Ed Freeman

Do you have a bunch of data in SQL Server that you’re using ODBC/JDBC to pull data to work with in Python? Using SQL Server’s Python integration, you can connect to a SQL Server instance within your preferred IDE and perform the computations on the SQL Server Machine. No more clunky data transferring. Operationalizing a Python model/script is as easy as calling a stored procedure. Any application that can speak to SQL Server can invoke the Python code and retrieve the results. Easy! This blog will provide a few, simple examples which make use of this capability to carry out some simple Python commands, so you can get up and running as quickly as possible.

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 […]