Kyle Nunery

Running PostgreSQL in a Container for Local Development on Windows

You can install the full version of PostgreSQL, also known as Postgres, and be on your merry way. If you like the idea of not having to install Postgres and having the ability to start and stop Postgres trivially then this article is for you. Running PostgreSQL using Docker can

NServiceBus Tips

* Append "Policy" to the end of the names of your sagas. * Use commands for things you want to happen. * Use the imperative for naming your commands, e.g., SendWelcomeEmail. * Use classes for commands. * Use events for things that have happened. * Use interfaces for events. * Event names are often

Postgres in a Hurry

Here are some common queries I use in Postgres. View Current Query Activity SELECT query, state, * FROM pg_stat_activity Drop Existing Connections Except Yours (9.2+) SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'TARGET_DB' -- ← change

Guide to Naming Resources in Azure

Naming resource groups and resources in Azure in a consistent manner is challenging. The naming guidance by Microsoft [https://docs.microsoft.com/en-us/azure/architecture/best-practices/naming-conventions] is quite good and is a good starting point. Naming Resource Groups In most modern systems you will have resource groups for each

LastPass Autofill Rules

LastPass is a very convenient tool for managing and autofilling usernames and passwords on internet sites. How does LastPass determine which inputs to autofill? My research and testing showed that LastPass as of 2/18/2019 uses the following rules. 1. There must be at least one <input type=

android

Android Licensing Files

When building my Android project I am getting this error message. > Checking the license for package Android SDK Build-Tools 25.0.3 in C:\Android\android-sdk\licenses Warning: License for package Android SDK Build-Tools 25.0.3 not accepted. Checking the license for package Android SDK Platform 25 in

Query Store Added to SQL Server 2016

In order to understand a system's performance you need to have baseline data. The Query Store is a tool provided by SQL Server to capture baseline data. The Query Store is new SQL Server 2016 and is available in all editions. There are some Query Store related bugs

The 8 Fallacies of Distributed Programming

In order to build a successful micro service architecture we must keenly aware of the issues that can cause distributed systems to fail. In the 90's a smart set of researchers at Sun Microsystems summarized the most common pitfalls people run into when building distributed systems. These pitfalls

.net

Preferred .NET Open Source Packages - Q2 2018

Database Migration RoundhousE [https://github.com/chucknorris/roundhouse] DbUp [https://dbup.readthedocs.io] Inversion of Control Container Autofac [https://autofac.org/] Logging Serilog [https://serilog.net/] NLog [http://nlog-project.org/] Mapping AutoMapper [https://automapper.org/] Mediator/Command Handler/Pipeline MediatR [https://github.com/jbogard/MediatR] Testing XUnit [https://xunit.github.

ASP .NET Core Logging with Serilog

The de facto loggers in the .NET space have historically been log4net and NLog. Along comes Serilog and it has a more metadata"y" approach that they describe as structured events. Serilog fits in extremely well with modern aggregated logging services like Elastisearch, Loggly, etc... Logging Goals: * Upon

Planning Azure Resource Groups

When building a Continuous Integration/Continuous Deployment pipeline in Azure it's important to plan out your resource groups ahead of time. The unit of containment in Azure for a resource, e.g. database, VM(virtual machine), or blob storage, is a RG(resource group). Resource Group Facts 1.

monitoring

Bare Minimum Business Website Monitoring

Let's look at the bare minimum amount of monitoring every business critical website needs. This is the absolutely least amount of monitoring you should have in place. You need to make sure the site is up and available so you need at least some sort of "ping&

vsts

VSTS Extension: Tags Manager

When using VSTS it's recommended to use tags liberally to help with identifying and categorizing work items. Over time people will tag work items with different tags for the same purpose. For example, one developer may tag a card as v1.0 and another developer as v1 to

c#

F# vs C#

Every year I dabble with F# for several weeks. I did this again during the 2016 holiday break. Before I forget what I learned this break I thought it would be good to recap the major benefits of F# over C#. Better Default Equality Let's start by defining

Documenting APIs in ASP .NET Core

Thanks to Swagger and the ecosystem surrounding Swagger it's straight forward to develop great documentation for your ASP .NET Core Web APIs. There is a .NET/C# project called Swashbuckle that will generate Swagger compatible documentation and output html documentation. The Swashbuckle project for ASP .NET Core is

Recommended NPM Packages Q2 2016

I want to be as fast and efficient as possible when writing Node.js code. I have found the key to this is discovering and using the "right" NPM packages. When walking into new territory I have found that determining the "right" NPM package can be

Slack in 10 Minutes or Less

Slack [https://slack.com/] is the new hotness in team IM (instant messaging) tools. It is a great business communication tool that can greatly improve communication within your organization. Slack features the ability to add and remove people from an organization much like Github. You really only need one account.

ASP .NET MVC CSRF Breakdown

Cross-Site Request Forgery(CSRF) is in the Open Web Application Security Project(OWASP) top 10 2013 edition. OWASP is a non profit organization that produces a list of the top security vulnerabilities in order to help improve web software security. In the top 10 edition for 2013 the CSRF security

bash

Bash for Everyone

I have been using the bash shell increasingly on my macbook pro to get stuff done. I haven't used the power of the bash shell extensively since college. Here is a fun Bash kata. For Fun (mac only) > say -v zarvox 'All your base belong to

game dev

2014 Big Giant List of Free Game Dev Resources

Here is the 2014 Big Giant List of free (or low cost) game development resources. Fonts An often under looked aspect of games is picking a font that fits the aesthetics of the game. Da Font [http://www.dafont.com/] A mega library of mostly free fonts! Be careful to

Is C# Missing Traits?

Does C# need "traits"? It's always interesting to look at other programming languages for features that aren't available in your main programming language. First, what the heck is a trait? Traits are a language construct that is unique to Scala. Let's check

Intro to Group Theory

I took several courses on Abstract Algebra as an undergrad and graduate student in college. One core aspect of Abstract Algebra that we studied was Group Theory. Group theory is an underpinning of Category theory which has shown up quite a bit in programming lately with linq and functional programming.

audio

Audio Tools for Game Development

Developing audio for video games can be quite an intricate and complex task. Great audio can make a game with simple graphics seem quite sophisticated. Many of the early 8-bit video games had memorable musical scores. The task of creating custom audio can be greatly simplified by using the audio

tips and tricks

Global Conditional Compilation with Unity3D

I am developing a Unity(4.3.4) game and need to toggle features on and off between the Lite and Standard version. The Lite version contains ads and is free, while the Standard version costs 99 cents. One technique for doing this in C# is to use preprocessor directives.

windows8

Pixel Hero - Windows 8 App Post Mortem

This blog post just didn't want to get out the door so it's being published almost half a year late:) I published a Windows 8 app, Pixel Hero [http://apps.microsoft.com/windows/en-us/app/pixel-hero/8742b5e0-0d30-4cb1-90fc-0a9010fb6023] late Saturday night (9/7/2013) into what is