Empty Space (Page 10)

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

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

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

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

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

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

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

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

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

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

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

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

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

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_sha.txt git