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