Category: Software Development

PowerShell script module starter kit

Background PowerShell functions are an essential tool for extending the PowerShell ecosystem with your own custom code. Modules are great because they allow you to package a collection of functions into a container for easier distribution and usage. One of the hurdles for starting to write your own modules is finding a good file or … Continue reading PowerShell script module starter kit

Azure WebJobs: Scheduling and Scaling

Why Azure WebJobs? Azure WebJobs are a great resource included in Azure App Service plans. They provide a way for you to run binaries or scripts that perform scheduled or event-triggered job processing for work that isn't suited to be done during a normal web request. Have a monthly cleanup task for your website? Sending a big … Continue reading Azure WebJobs: Scheduling and Scaling

How to find users near a central coordinate (spatial nearest neighbor queries)

Scenario You have a database table of users who have a location specified. Given an input location point, coordinate, or city - find the top N (or all) of the nearest neighbors in range. So for example, if I am in Seattle, return 15 nearest users to my location within a 50 mile range. This is a classic … Continue reading How to find users near a central coordinate (spatial nearest neighbor queries)