Menu

Close
  • Home
Subscribe
Menu

Kyle Valade

25 posts
Page 1 of 2 Older Posts →

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 »

Kyle Valade 06 December 2019

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 »

Kyle Valade 25 October 2019

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 »

Kyle Valade 16 October 2019

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 »

Kyle Valade 01 August 2019

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 »

Kyle Valade 07 June 2019

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 »

Kyle Valade 05 June 2019

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 »

Kyle Valade 25 February 2019

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, »

Kyle Valade 18 January 2019

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 »

Kyle Valade 17 July 2018

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 »

Kyle Valade 11 May 2018

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 »

Kyle Valade 09 March 2018

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 »

Kyle Valade 07 March 2018

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 »

Kyle Valade 21 February 2018

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 »

Kyle Valade 09 February 2018

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, »

Kyle Valade 01 February 2018

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 »

Kyle Valade 08 January 2018

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, »

Kyle Valade on java, play-framework 14 September 2017

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 »

Kyle Valade 17 August 2017

Play framework - testing forms with array fields

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 »

Kyle Valade on java, play-framework 16 June 2017

Play Framework - throw an exception to return an HTTP response

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 »

Kyle Valade 16 June 2017
Page 1 of 2 Older Posts →
Nightly Closures © 2019
Proudly published with Ghost