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 »
Notes for creating a UWP Surface App using .NET Core
These notes are more for personal use, so sorry for any incoherence :P. But maybe someone will find them helpful, even if UWP apps have been »
Writing a React Native iOS module in Swift
The odds were against me: The documentation is a little slim. I haven't been paying attention to the javascript universe for 6 months. But I have »
Creating a custom visual in Power BI
I'm making a visual to display a single KPI with some data, similar to Card with States - no graphs or anything fancy. To get started, »
Working with SQL Server in Django (+ schemas!)
Update as of 2019-10-16: This is pretty outdated and all of the issues are not difficult to solve. I recommend reading my new posts here for »
Testing requests in Play Framework
It's easy to test forms and controllers in Play Framework, except for when you add real-life things like CSRF protection and authentication. Other frameworks, like Django, »
Sane logging for postgres
Getting situated I’m using CentOS 7, and my logs are at /var/lib/pgsql/data/pg_log by default. Or if not by default, then »