Automating tedium with the ServiceNow API
I should have named this blog Enterprise . But big companies are going to use ServiceNow whether or not HR likes handling onboarding tickets in the side-project »
Eternities of Gitlab CI pipeline trial + error...only run with changes
I've spent many mind-numbing hours trying to get this Gitlab CI pipeline to work the way I want it to work. I'm not sure if I'm »
Jest - mock a single function in a module
Though the requireActual route looked promising, it only worked when I called the mocked function directly in my test, and not when used like in real »
MLOps, CI, and development flows using Databricks
I wrote this about a year or two ago while I was still working a lot with Databricks. It was right around the time where "MLOps" »
In Soviet Russia, ad finds you
This is a post I wrote for work to explain the basics and foundations of ad tracking. It was meant for a fairly nontechnical audience, so »
ODBC and DB2 - problem saving a large chunk of text - CWBNL0107
I'm using PyODBC to connect to DB2 and was seeing some problems saving certain rows of data. The column the error message mentioned was a CLOB »
Connect to DB2 from python with SQLAlchemy
This is kind of a sister post to my Databricks-specific post from the other day. It's amazing how much time you can spend searching through docs, »
Access DB2 From Databricks
This took me a good few hours to figure out. So hopefully it will help you and my future self. install com.ibm.db2.jcc:db2jcc: »
7x performance improvement for my dead slow SQL Server + Django pyodbc queries
In one of my Django projects, I'm connecting to a SQL server database, and I'm doing this with django-pyodbc-azure. I noticed that my query performance was »
Django in Azure Web Apps - too many redirects
I've been testing out Azure Web App services lately so I can avoid all of the reverse proxy/server management mumbo jumbo. When I was deploying »
Working with SQL Server in Django pt. II
This is a follow-up and brutal takedown of a post I wrote about two years ago. Go here for part I. I'm starting to use Django »
Calculate grouped YTD totals for previous years in Pandas
I want to calculate the YTD total for the last couple years for every customer + product combination that has been sold. I'm new to Pandas and »
Import a directory into Databricks using the Workspace API in Python
Another fairly easy thing that I couldn't find in the docs. I wanted to be able to upload a directory into my Databricks Workspace from my »
Read from SQL Server with Python/Pyspark in Databricks
This is actually really easy, but not something spelled out explicitly in the Databricks docs, though it is mentioned in the Spark docs. Alas, SQL server »
Parse XML with PySpark in Databricks
It's kind of a trick title, but here's the answer: don't. Just don't do it. Python is no good here - you might as well drop »
Logging with Sentry on Databricks
I couldn't find anything that laid this out really plainly, so I'm going to do so here. I'll update as I learn more and dig deeper, »
Application is not supported over the /common or /consumers endpoints. Please use the /organizations or tenant-specific endpoint.
I was getting this error message when trying to sign into Azure Active Directory in a .Net Core 2.x app. It was written by someone »
The Trials and Tribulations of a Database Context in .NET Core (pt. 1)
When I started using .NET Core this time around, I was pleasantly surprised. But over the past couple of days, I have been unpleasantly surprised. There »
Dependency injection in .NET Core 2.0
Say I have a controller and I want it to pull something from Amazon. Say that I also have unit tests and I don't want to »
Config and secrets in .NET Core 2.0
There are a few ways to manage environment-specific configuration in the new version of .NET Core, and those ways are much better documented than I remember »