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/

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

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

.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

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="X-UA-Compatible&

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 thought and

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

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

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] * upgrade: Some people reverse the order

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://token2shell.com/

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 is mine.  Please note that all the

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

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-Sleep -Milliseconds 100

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 preventing screen locking is

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 zip -r

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", { "wx&

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

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 { "fruit": "Apple", "

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 * find . -type

* 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

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 Project and leave off

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 msbuild.exe