Endjin - Home

Ed Freeman's Blog

Use-case Here’s the background to this blog: I’ve always found getting csv files into a SQL Server instance much more convoluted than seems necessary. The manual tools provided in SSMS have caused me hours of pain in the past, trying to match-up data types from source and sink. I never seemed to get it right. […]


I’m back! Hi everyone. It’s been a long while since my last blog. *Bows head in shame* Blogging is one of those things I know I should do more often, but I’m still not in the routine in which one needs to be in order to do it regularly. As a consequence, what usually happens […]


Recently, Jess and I were looking at a Power BI report we produced for one of our clients. On the ‘overview’ page, we have numerous high-level visuals: Total Sales, Previous Year Sales, % Change YoY etc. Something struck me as odd, though. As I’m sure many of you who have spent days on a report […]


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


Hello again, everyone. For those who read my blog a couple of months ago, you may well have been expecting to hear from me a little sooner. Well – I was hoping that would be the case, but it turns out my body had other ideas. I was off for 8 weeks after my appendix […]


My first month as an apprentice at endjin

by Ed Freeman

A little over 10 months ago I wrote a blog which reflected on my summer internship at endjin. Now, a little over 10 months later, I’m sitting in the same office one month into my Software Engineer Apprenticeship after having completed my Maths degree and choosing to come and join the team here, for good. […]


Guest Blogger – Ed describes his three month paid summer internship at endjin Ed is studying a Mathematics BSc at UCL. He made contact in January because he was looking to gain some real world software development experience during his summer break, before his final year at University. During his three month internship we tried to expose him to as many different […]