Kyle Nunery

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

Naming resource groups and resources in Azure in a consistent manner is challenging. The naming guidance by Microsoft is quite good and is a good starting point. Naming Resource Groups In most modern systems you will have resource groups for each of your environments.

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. There must be at

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

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

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)

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

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 "

Slack 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

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

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

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