Empty Space

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-procedures/sql-server-dynamic-sql/] statement

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 so came up with this to alter the structure it.  The following statement does

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

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 and synchronize git rev-list

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

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.html]

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-sql-server/] trigger [https://docs.microsoft.com/en-us/sql/

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

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 changed

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

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 [http://man7.org/linux/man-pages/

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/

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_

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.

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/