Search Results

Here’s a means to insert multiple records in a single insert call, which is about 40 times faster than performing an explicit insert for each row. We will leverage the BeginBinaryImport method on the database connection class of the NPGSQL library. To make t...

Access Postgres as SuperUser Use this terminal command to access the local PostgreSQL instance as the postgres user: sudo -u postgres psql Setting Postgres (Superuser) Password Normally, the postgres user (superuser) does NOT have a set password.This is be...

Adapted steps from here: https://www.c-sharpcorner.com/article/crud-operations-in-postgresql-with-ef-core-and-asp-net-core-web-api/ https://documentation.ubuntu.com/server/how-to/databases/install-postgresql/index.html Download PostgreSQL can be downloaded...

Here’s some steps on how to generate and setup an SSL certificate for a web site. First, order a certificate from a CA, like Sectigo, or Digicert. Once your order is active, they will require you to submit a CSR.This must be generated by you, and wil...

If you receive pem formatted certificate and key files from a CA registrar, you will need to convert them for use by a linux host. Bundles and Chains As well, it may be necessary to compose a certificate chain file, for the host, instead of a simple crt file...

NGINX doesn’t natively use a pfx key file (pfx is what Windows IIS needs). So, it must be converted to a private key, removing the public key from it. Create the folder for storing SSL certificates: cd /etc/nginx/ mkdir ssl cd ssl chmod 700 /etc/nginx/ssl...

Here are some useful commands when running a GPS-disciplined NTP server. NTPQ When running a query of an ntp server, you would use: ntpq -p.What you see is this:ntpq -pn Here’s an explanation: REMOTE = The servers and peers specified in the configuration...

In case it’s necessary to use Windows Subsystem for Linux, here’s a good tutorial on how to get it running: Install WSL Set up a WSL development environment Getting started with cross-platform development using .NET on Ubuntu on WSL | Ubuntu Debugging a .N...

If you’re trying to export all the RDL, data sources, gif, and other files of a set of reports, but the SSRS web portal is inaccessible, this method will pull them from the report engine database back-end. Taken from here: Export of SSRS reports datasources a...

There are several aspects of an ASP Net Core web API that cannot be placed in a class library without a little extra care. This is because Microsoft decided to remove “many of the core assemblies” from nuget packages for the ASPNetCore, when Net Core 3.0 was p...

Adapted from here: https://docs.rundeck.com/docs/administration/maintenance/backup.html We will use the rd tool to access the RunDeck API and export the project job list. We will be backing things up to this folder: /projects/rundeck_backups 1. Execute thi...

If you need to add diagnostic logging to the VBA of a FTView control or window, you can leverage this: Application.LogDiagnosticsMessage Here are examples: Private Sub Button6_Released() Application.LogDiagnosticsMessage "Informational Log Message", ft...

If you accidentally execute a long-running operation that you want to cancel, and the SSMS client doesn't seem to accept the cancellation, then the database engine is likely involved in a large rollback, to restore the original state. Run this to identify the...

If you come across the need to purge many records from a datatable, and doing so will result in a large rollback snapshot, you can split the deletion into chunks that will execute much faster and with less resources. Use something like this: SET NOCOUNT ON; ...

Sometimes, a a dotnet runtime closes without releasing a listening port. This will prevent it from restarting, because the port is already in use.   While running the dotnet run if you stop the server using ctr + z then it Ctrl+z sends the SIGTSTP (Signal T...

How to startup a net core application and specify the listening IP address and port: exename.exe run --urls "http://192.168.1.110:6000"

Here’s a short list of steps for setting up an SSH server in Ubuntu. Install SSH Server Installing the open ssh server is pretty straightforward on Debian. Run the following to install the service and libraries: sudo apt-get updatesudo apt-get install opens...

https://www.tomshardware.com/how-to/install-windows-11-without-microsoft-account  

Projects are saved here: \\192.168.1.211\Projects\Active\Christmas Lights Running: XLights64, v2020.55

Below are instructions on how to setup a binary as a linux service. For additional systemd commands, see this: SystemCtl Usage Service Creation Here are steps to run a binary as a linux service. Create a systemd unit file for the service by generating a fi...