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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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, »
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 »
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 »
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 »
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 »
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 »
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 »
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, »
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 »
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, »
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 »
I have an HTML form with a couple of fields, one of which is an array, the other of which is not. I want to be »
Hmm, when I write out the title, the idea seems pretty gross. But it makes some boilerplate-type things really nice. Take, for example, a user profile »