Empty Space

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]

code

Copy/Paste Windows Subsystem for Linux

Trying to copy some text out of the command line output from a Windows Subsystem for Linux [https://docs.microsoft.com/en-us/windows/wsl/install-win10] prompt.  I am using Pengwin [https://github.com/WhitewaterFoundry/Pengwin] Debian variant as my WSL as well as I have a X410 [https:

personal

In solidarity with the Zapatista Movement

Standing up for the right to be treated as a human being is a universal movement we should all embrace and strive for. > The world we want to transform has already been worked on by history and is largely hollow. We must nevertheless be inventive enough to change it

code

Command aliases in Windows: Use doskey

I wanted to add some aliases to the command prompt [https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/cmd] in Windows (not Powershell [https://docs.microsoft.com/en-us/powershell/]) * Create a doskey [https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/doskey] file, this

code

Global PowerPlant Database - Extraction

Wanted to get the latest list of all the electrical powerplants in the USA and thanks to the World Resources Institutes [http://datasets.wri.org] Global PowerPlant Database [http://datasets.wri.org/dataset/globalpowerplantdatabase] source.  They do a great service in collecting and collating the various datasets available into a

code

PowerShell - Stop Screen Locking

This script stops screen locking by pressing the Scroll Lock key every 30 seconds on/off with SendKeys [https://ss64.com/vb/sendkeys.html] Clear-Host Echo "...Lock screen avoider..." $WShell = New-Object -com "Wscript.Shell" $sleep = 30 while ($true) { $WShell.sendkeys("{SCROLLLOCK}") Start-

code

PowerShell - Random Text Generator

Wanted to try to generate a random text every so often to prevent screen locking which did not work and stumbled upon this [https://devblogs.microsoft.com/scripting/generate-random-letters-with-powershell/] and learned a couple of neat tricks from PowerShell.  The actual solution that seems to work for

code

Zip every subfolder in a folder

I needed to zip every subfolder within a folder to it's own separate zip file.  In Bash did a for loop to find each folder and then zip [https://www.howtoforge.com/linux-zip-command/] each folder. This is my oneliner to do it for i in */; do

code

Manipulating JSON with Gron

Poking around with curl trying to do things and found a nice supplemental tool Say you have curl https://api.weather.gov/points/32.7687,-97.3093 Gives you the big JSON response { "@context": [ "https://raw.githubusercontent.com/geojson/geojson-ld/master/contexts/geojson-base.jsonld"

code

Renaming a Git branch local+remote

Rename your local branch * When you have the target branch checked out locally git branch -m desired_name * When you do not have the target branch checked out locally git branch -m wrong_name desired_name Delete the wrong_named remote branch and push the desired_name local branch git

code

Read JSON with Powershell

Get-Content -Raw -Path <my_json_file>.json | ConvertFrom-Json Syntax: $my_file = Get-Content -Raw -Path .\<my_json_file>.json | ConvertFrom-Json or to separate for piping further ( Get-Content -Raw -Path .\<my_json_file>.json | ConvertFrom-Json ) Example: Input JSON file { "

code

Using Xargs to delete git history

Needed to delete the .git history out of a folder and subfolders and thought xargs [http://man7.org/linux/man-pages/man1/xargs.1.html] would do what I needed to do. First find [http://man7.org/linux/man-pages/man1/find.1.html] all the relevant files using find

code

Treatise on code review

* Code Review should default to approved, broken tests will stop the approval process * If new code has no tests you can ask for a test * Styling is optional. If styling is important to you don't make a comment, make a template or choose a language that forces a

personal

Fictional abstractions as social contracts: Part 2

Second fictional abstraction used by humans on a daily basis that are completely fabricated abstractions of any physical traits or requirements i.e. they were created by humans as a representations of implicit social contracts for cohesion and cooperation that then became explicit and codified. Abstraction 2: Religion Religion is

personal

Fictional abstractions as social contracts: Part 1

Thinking of two items that are used or experienced for most humans on a daily basis that are completely fabricated abstractions of any physical traits or requirements i.e. they were created by humans as a representations of implicit social contracts for cohesion and cooperation that then became explicit and

code

Reinstall Nuget packages without updating

This situation comes up often enough that I need to look it up and write it down. Run this command from the Package Manager Console [https://docs.microsoft.com/en-us/nuget/tools/package-manager-console] Update-Package -reinstall -Project <YOUR PROJECT NAME> Or use the default selected

code

Stop unresponsive processes

Windows - Taskkill [https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/taskkill] In this case you have a non responsive msbuild that you can't find and want to terminate I would use the following command taskkill /f /im msbuild.exe /t which translates to kill all

code

Reset Branch: Git+{Your shell}

Helpful reminder on how to reset a branch on all changes you have been doing PowerShell git reset --hard $(git rev-parse HEAD) Bash git reset --hard $(git rev-parse HEAD) Command Prompt (a lot more work) git rev-parse HEAD > last_sha.txt set /p last=<last_

code

Mature Sustainable Operations

From Toward a Maturity Model for Observability [https://www.honeycomb.io/blog/toward-a-maturity-model-for-observability/] * Quality Code * Predictable release * Managed debt * Operational Resiliency * User insight

code

SQL Server UTC Date Functions

Ran across some SQL statements that were using the expression SYSUTCDATETIME() [https://docs.microsoft.com/en-us/sql/t-sql/functions/sysutcdatetime-transact-sql?view=sql-server-2017] which is a statement I have not used and wanted to know the difference between this and my common go to statement

code

Every Nth item in a list

Today I was asked a straightforward question on how would you get every 4th element from an array of numbers starting at 1 - 11 I immediately thought oh I can do this in a functional fluent manner, but then I flubbed it up because I tried to do a Skip

code

Set X11 Forwarding for all Users

Setting the X Windows [https://token2shell.com/x410/] forwarding for your own personal user is usually set in the .profile file, but most of the time you really want to enable X Window [https://token2shell.com/x410/] forwarding for all users of the system.  I mean you already went through