Category Archives: Software

Information related to software

Checkout Additional Git Repos in Azure Pipeline

October 26, 2020

The typical use case for my department is that when a build is triggered in Azure DevOps, we automatically load the single Git repository. Note that for these examples, the self repository is named ProductXYZ. the self repo is the one that triggered the build to occur because of an automatic trigger (someone committed changes to the repo)… Read More »

Git Cheat Sheet

March 17, 2021

I’ve dipped my toes in the Git waters for over 10 years. I must confess that I never really grokked it. It might be that I never worked in a multi-user repo environment with Git. Or it might be that working with it for one month every year wasn’t enough to make it stick. So I decided to… Read More »

WordPress by example: $wp_query

April 3, 2023

We should be familiar with the concept of the loop. As demonstrated below, the WordPress template logic will continue to get posts until there are no more. With each iteration of the loop, we get the post using a SQL query and save the retrieve information int the global variable $wp_query. Notice that we do not need to… Read More »

SQL Variable, Temporary and Global Tables

March 1, 2023

SQL procedures can create multiple types of table entities – it’s up to you do decide which one is best. The Simplest: Table Variable If you just want to capture some information to be used in the body of a stored procedure and the table creation and usage is in a single batch (no “GO” statement between creation… Read More »

SQL Scalar Variables

February 28, 2023

SQL scalar variables (otherwise known as local scalar variables) must be defined with type and set to a value before the variable can be used. This can be done in two steps or as a single step. Additional Links

Using the Select Automation with Python Code Snippets

February 28, 2023

Select allows you to supplement the “canned” conditions and activities for Automation with Python code. The object passed to the code (context) depends on how the automation task is coded. The context can come from at least five sources. Python Hooks in Automation Automation can host Python snippets in both the condition and activity areas. The way automation… Read More »