Why? It is not a wow this is nice feature, but the ability to use new popular languages expands knowledge and helps define services clearer. The languages themselves are built of common constructs, but each has its own strengths and weaknesses Point 1 - JavaScript is used everywhere and in

Mindset of software as limits to end users and management. Use software expiration dates (use feature flags to force it if you want). I have asked for this many times before in other places and in summary the idea is the same as any physical product. Wood rots, iron rusts,

Want to generate UUID on Windows and it is painful compared to Linux where if you use Debian it's uuidgen  on mac OS you probably have it under dbus-uuidgen | pbcopy i.e. cat uuidgen or echo uuidgen | setclip if you have xclip configured Or you could do the slapdash easy

Doing a bucketing exercise on coderpad.io which supports 30+ languages, but in actuality a language is only as good as its tools and libraries and in that respect coderpad.io is sorely lacking on many of the languages it supports.  In truth coderpad.io is built for Python, Javascript,

Currently expanding my python knowledge by doing Advent of Code 2021.  This forces me to look up a lot of python libraries and syntax, but I feel like I am really getting a pythonic mindset now.  Learning a lot about pandas, numpy, and other libraries. I did the same last

In Linux/macOS you use the su command Windows does not have this and the closest thing it has is runas with /user option.  It will then prompt you for the password of this particular user.  Key point here is that most likely you will want to use the /netonly

PDFs are great for presenting information, but due to their structure and formatting getting structured data out of them is difficult and tedious and they could be considered unstructured data in my opinion. Say you have a PDF document like this, which is really a long table with a lot

Code review doesn't do what I hear people tell me it does in every organization I have worked for For exampleMakes code readableShares knowledgeStandardizes approachWhat it does do in my opinion (read earlier thoughts I had on this here code review) Encourages bullying of approach (especially present when lack of

Experimenting with python templating of jinja2 and finding it quite a bit nicer than the razor syntax in ASP.NET for one big reason to me that extracting the engine can be done outside of the application with ease as in the case below I am running the engine by

Needed to deploy a pretty cool dynamic proxy called traefik, which is built on golang and can be deployed as a single binary and along with some simply configs can take a lot of difficulties of say an nginx reverse proxy out of the way. Key pointsService is running on

Capturing a screenshot in Linux/macOS is documented and can be done in a single command as detailed here Doing this in Windows is a lot less clear and more painful, but you can do it like so I am not running with administrator rights so this may be slightly

Capturing a screenshot documentation SetupAdd google chrome package location: wget https://dl.google.com/linux/direct/google-chrome-stable_current_amd64.debInstall: sudo apt install ./google-chrome-stable_current_amd64.debCaptureCapture the url contents of siliconheaven.info google-chrome --headless --hide-scrollbars --window-size=1920,2000 --screenshot="siliconheaven.png" "https://siliconheaven.info"OutputCommand line robin@wasp:~$ google-chrome

Reading text from images using the Tesseract Codeimport cv2 import pytesseract if __name__ == '__main__': # setup the path for the tesseract tool pytesseract.pytesseract.tesseract_cmd = r"C:\Tesseract-OCR\tesseract.exe" #load the image img = cv2.imread("code.png") #convert to grayscale gray = cv2.cvtColor(img, cv2.COLOR_BGR2GRAY)

Scaled Agile Framework

- Pretend I'm not a tech person. Can you explain REST in simple terms? Everyone can be a tech person and I hope that my explanation covers the concept and intentions behind REST (REpresentational State Transfer). Executive Summary:REST is an informal software specification/guideline/principle to creating patterned stateless

Asynchronous Python is a pleasant experience to work with.  Nothing unexpected or weird about using the await/async keywords and how they work. Basic example of an asynchronous functionasync def this_takes_awhile(wait_time_seconds=1): await asyncio.sleep(wait_time_seconds)That's all it takes with the asyncio

Individual lookups against a rules system stored in a database can add up to a lot of computations and depending on the size of your ruleset cause delays.  There are ways around this with caching, in memory hashmaps.  However for this approach I used a Common Table Expression (CTE) to

Wanted to create a chain of method call backs with some simple JavaScript as in startMethod -> calls function on success and another function on failure and it had been awhile since I did this refreshed my memory on Promises and Object.assign First create a variable like so

Working on a task to create a relational ordered set of prompts from rules with dynamic model binding.  This is one way to do it with JSON and SQL.  In this case the prompts may change, but it is a rare event.  The goal is to make the SQL server

Again I am fighting with a MySql collations and character sets.  Why would this be a problem when I have set the default collation and changed all the tables to character set utf8mb4 and collation utf8mb4_0900_ai_ci.  Well it's because the columns within the MySql database are still

Putting this here to remember how to query out the metadata of a view, using the AdventureWorks2017 database view vAdditionalContactInfo for reference. use [AdventureWorks2017] SELECT [c].[column_id], [c].[name] AS [ColumnName] FROM [sys].[columns] [c] INNER JOIN [sys].[views] [v] ON [c].[object_id] = [v].[object_id] WHERE [v]

Needed to alter a particular stored procedure over a few thousand databases.  Here is an example script that uses a cursor and dynamic sql to do this.  Key point here is to have the USE statement switch the database prior to issuing the CREATE OR ALTER command so that each

Got some quirky unexpected behavior when loading data from text files and SQL statements when working with extended ASCII characters and Unicode. These files in particular are UTF8 encoded as is standard when doing text editing and contain strings with contents like so æ2Ç9£╖♫↕◄‼↨∟. File editing example Visual Studio CodeExampleText

In the commit early and often strategy means checking in and commit code all the time like saving a file and sometimes when you do this you accidentally check in something that you shouldn't have and even push it up to the remote server(s) Do this to fix itCheck

User defined functions suffer from inability to be query plan optimized, but this is a nice function I wrote to find ASCII control characters CREATE FUNCTION [dbo].[ContainsControlCharacters] ( @textToCheck NVARCHAR(MAX) ) RETURNS BIT AS BEGIN DECLARE @invalidCharCount INT; -- Sadness that it came to this -- Splits the input text