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 = 'TARGET_DB' -- ← change this to

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. A typical environment naming convention is

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 least one <input type="

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 in the

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

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 When you create

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 called Ahoy,

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 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. This works great

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

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 out how traits work in Scala.

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.