Skip to main content

Recently Updated Pages

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 1 month 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 1 month 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 1 month ago by glwhite

RunDeck Backups

System Administration

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

Updated 1 month 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 1 month ago by glwhite

SSRS: Export Reports Without WebPortal

System Administration

If you’re trying to export all the RDL, data sources, gif, and other files of a set of reports, b...

Updated 1 month 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 1 month ago by glwhite

NTP Server

System Administration

Here are some useful commands when running a GPS-disciplined NTP server. NTPQ When running a qu...

Updated 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month ago by glwhite

Postgres Setup

PostgreSQL

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

Updated 1 month 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 1 month ago by glwhite

Ubuntu v24 Host Setup

System Administration

Setting the Host Name Get the current hostname with this:  hostnamectl To set it, use this: ...

Updated 2 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 2 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 2 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 2 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 2 months ago by glwhite