Skip to main content

Recently Updated Pages

Ubuntu: How to Kill DotNet Runtime

.NET

Sometimes, a a dotnet runtime closes without releasing a listening port. This will prevent it fr...

Updated 6 months ago by glwhite

Purging Many Records

SQL Server

If you come across the need to purge many records from a datatable, and doing so will result in a...

Updated 6 months ago by glwhite

Cancelling a Long Running Operation

SQL Server

If you accidentally execute a long-running operation that you want to cancel, and the SSMS client...

Updated 6 months ago by glwhite

Logging from FTView VBA

FactoryTalk

If you need to add diagnostic logging to the VBA of a FTView control or window, you can leverage ...

Updated 6 months ago by glwhite

RunDeck Backups

System Administration

Adapted from here: https://docs.rundeck.com/docs/administration/maintenance/backup.html We will ...

Updated 6 months ago by glwhite

Missing AspNetCore Nuget Packages

.NET

There are several aspects of an ASP Net Core web API that cannot be placed in a class library wit...

Updated 6 months ago by glwhite

WSL Setup

System Administration

In case it’s necessary to use Windows Subsystem for Linux, here’s a good tutorial on how to get i...

Updated 6 months ago by glwhite

Convert SSL PFX for NGINX Usage

System Administration

NGINX doesn’t natively use a pfx key file (pfx is what Windows IIS needs). So, it must be convert...

Updated 6 months ago by glwhite

Converting PEM to crt and key

System Administration

If you receive pem formatted certificate and key files from a CA registrar, you will need to conv...

Updated 6 months ago by glwhite

Generate SSL Cert

System Administration

Here’s some steps on how to generate and setup an SSL certificate for a web site. First, ord...

Updated 6 months ago by glwhite

PostgreSQL Bulk Insert

PostgreSQL

Here’s a means to insert multiple records in a single insert call, which is about 40 times faster...

Updated 6 months ago by glwhite

PostgreSQL DotNet DataType Mapping

.NET

Here’s a list of .NET datatypes, and how best to store each one. .NET Datatype Post...

Updated 6 months ago by glwhite

Postgres Setup

PostgreSQL

Remote Access For accessing the postgres database from outside the host or from a docker contain...

Updated 6 months ago by glwhite

Validating AD Machine Account

System Administration Windows

Here's a couple ways to validate the machine account of a PC in an Active Directory domain: dsre...

Updated 7 months ago by glwhite

OpnSense Notes

System Administration

Here’s a collection of notes and details for the house router setup. Build Software: OpnSense 2...

Updated 7 months ago by glwhite

.NET iOS Runtime Limitations

.NET Xamarin

Here’s some notes on the limitations imposed by IOS for Xamarin and MAUI applications. These app...

Updated 7 months ago by glwhite

.NET Framework Unit Testing Issues

.NET

Since we have some libraries that still output to NET Framework targets, some workarounds are req...

Updated 7 months ago by glwhite

C# Unit Test Template Classes

.NET

If you are using MSTest as your testing framework, and want to leverage the test functionality fr...

Updated 7 months ago by glwhite

Unit Test Cheat Sheet

.NET

Here’s a list of elements for unit testing in Visual Studio using MSTest. Documentation for Visu...

Updated 7 months ago by glwhite

C# Unit Tests with Async Task Signature

.NET

When writing unit tests, it’s good to standardize as much as possible.This includes the method si...

Updated 7 months ago by glwhite