Empty Space

code

Find size of files

Wanted to get the size of files in a folder, in this particular case all the csv [https://en.wikipedia.org/wiki/Comma-separated_values] files, and came up with this after reviewing what others had done. * First find all the csv files in a particular location: find  *.csv [http:

code

Git Tag Tips

Messing with tags and needing to find the latest Windows + PowerShell git tag --sort=-authordate:iso8601 | Select -First 1 * First part reference the git tag [https://git-scm.com/docs/git-tag] * Pass a sort parameter in this case the authordate in ISO8601 [https://en.wikipedia.org/wiki/ISO_8601]

code

Find column in all databases on server

Need to find a column across several databases on a particular server and there were a lot of databases so used this query to build a temp table that holds the found metadata for the particular SQL Server. Need to construct dynamic sql [https://www.sqlservertutorial.net/sql-server-stored-

code

Replace nullable column with non nullable in MS SQL Database

Needed to replace a nullable [https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-alter-column/] column in a database with a non nullable [https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-alter-column/] column that.  In this case a boolean field needed to transition

code

Code Complexity

Code complexity has categories Technical: The domain of knowledge or in this case business or scientific rules and baselines that are needed to satisfy the conditions of the problem. * Example 1: Tax laws being codified into software * Example 2: Gravity calculation and or light calculations when performing astronomical simulation and

code

Using Git tag to create

Tagging a release and I am documenting the steps and commands I use to do this git pull git describe --tags $(git rev-list --tags --max-count=1) git tag "next_tag" git push --tags git pull Pull down [https://git-scm.com/docs/git-pull] the latest

code

Bulk Insert with Dapper

The Dapper [https://github.com/StackExchange/Dapper] project is a database tool that makes working with SQL [https://en.wikipedia.org/wiki/SQL] in .NET [https://dotnet.microsoft.com/] projects in a clean and understandable manner when you know SQL [https://en.wikipedia.org/wiki/SQL]. As an open source

code

Quick Copy table structure with Dapper

While working through a complicated SQL [https://en.wikipedia.org/wiki/SQL] series of steps I had the need to make a copy of an existing table, specifically in this case a temporary table to use for bulk loading. The into [https://www.postgresql.org/docs/9.1/sql-selectinto.

code

Table Track Changes Audit - MS SQL

Tracking the changes from a DELETE [https://www.zentut.com/sql-tutorial/sql-delete/] or UPDATE [https://www.zentut.com/sql-tutorial/sql-update/] statement at the table level by creating a compatible [audit].[TableToTrack] and then attaching an after DELETE, UPDATE [https://www.tutorialgateway.org/after-update-triggers-in-

code

MS SQL Batch Scripts To Run

This batch [https://en.wikipedia.org/wiki/Batch_file] script is designed to run a series of sql [https://en.wikipedia.org/wiki/SQL] script files in default order of a directory.  In this case this batch file called for example: run_scripts.bat Is in the same folder as

code

Ghost 3.X Theme Override

Fighting with the css [https://developer.mozilla.org/en-US/docs/Web/CSS] for override the main menu header bar.  I want to display my custom google site search bar and this was working previously with my Ghost [https://github.com/TryGhost/Ghost] 2.X theme, but then 3.X

code

Insert or Update (Upsert) logic

Thinking through the case that if you know the key [https://en.wikipedia.org/wiki/Unique_key] beforehand through a deterministic [https://en.wikipedia.org/wiki/Deterministic_algorithm] process.  Then MS SQL Server has a very handy builtin constraint that you can turn off so that you no longer have

code

Search git commit history with grep

When you want to search the actual commit contents in git [https://git-scm.com/docs] from the command line for a regular expression i.e. text you need to find * git rev-list --all [https://git-scm.com/docs/git-rev-list]: Search the entire git commit history * xargs

code

Python 3 JSON Post

Uses the https://httpbin.org /anything JSON echo service to demonstrate how to POST JSON encoded data to a URI, using the great requests [https://pypi.org/project/requests/] library * Have python3 [https://www.python.org/downloads/] installed on your machine * Install directly with pip3 [https://pip.pypa.io/en/

code

NodeJS JSON Post

Uses the https://httpbin.org /anything JSON echo service to demonstrate how to POST [https://en.wikipedia.org/wiki/POST_(HTTP)] JSON [https://www.json.org] encoded data to a URI. * Have nodejs [https://nodejs.org/en/] installed on your machine * Run the file or text interactively nodejs <file_

code

Cleanup with git

Common options when trying to reset your repository. * git remote prune origin : Remove merged branches * git reset --hard : Reset your branch changes back to the remote repository * git clean -fd : Remove all local changes that are unstage including untracked files and directories.

code

Ghost fix SSL certificates manual

I am currently self hosting this ghost [https://ghost.org/] blog and that means from time to time I need to perform maintenance and utility updates. Most of the time this is a hands off approach as ghost [https://ghost.org/] has a command line [https://ghost.org/docs/api/

code

Run *.dacpac file command line

Dacpac is a binary produced by a source controlled MS SQL database that will allow you to script and source control your database schemas. Automates the Data Definition Language [https://en.wikipedia.org/wiki/Data_definition_language] script creation and deployment through the use of either.WARNING the dacpac utilities

code

Programming with times

Was reading through the Fortran 77 specification for Astronomy [http://www.iausofa.org/2019_0722_F/Timescales.html] and the time/date stuff when dealing with non earth centric times is crazy.  I already ask to always use UTC [https://en.wikipedia.org/wiki/Coordinated_Universal_Time] time now, but

code

.NET Core 3.0 and Single Binaries

.NET Core 3.0 allows for  single binary distribution on applications in cleaner and easier way than before * Check your .NET Version firstdotnet --version Results 3.0.100 * Create a directory for your project mkdir native; cd native * Create a new project from the templates dotnet new console * Build and

code

Custom .NET Headers

Adding a custom header to instruct browsers on rendering directives (in this case Internet Explorer) In Classic .NET Do this <?xml version="1.0" encoding="utf-8"?> <configuration> <system.webServer> <httpProtocol> <customHeaders> <add name="

code

C++ Type Helper

Use const auto and auto when in local methods to allow for implicit type checking of variables while preserving static typing [https://en.wikipedia.org/wiki/Type_system] like the var [https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/var] keyword in C#. It will save you

code

MS SQL Parameterized Database Creation

Security static code scanner was complaining that creation of a database with parameters was susceptible to SQL injection [https://www.owasp.org/index.php/SQL_Injection].  In theory this could be possible as the database creation script was a sql command run, the likelihood was low as the parameters were

code

Encryption + Decryption extension methods

Encryption/Decryption extension methods in C# for working with the abstract class of SymmetricAlgorithm

code

Debian keeping packages current

I use the following command to keep my packages up to date and clean sudo apt-get upgrade -y && sudo apt-get update -y && sudo apt-get autoremove -y && sudo apt-get autoclean -y apt-get [https://linux.die.net/man/8/apt-get]