Salesforce, Python, SQL, & other ways to put your data where you need it

Need event music? 🎸

Live and recorded jazz, pop, and meditative music for your virtual conference / Zoom wedding / yoga class / private party with quality sound and a smooth technical experience

Bienvenue! Welcome!

My goal is to help you work faster.

I must speak and teach until I hear 10 people say, "That thing you taught me? I used it! And it saved me time!"

(Ahem ... although maybe blogging slower than I'd hoped. Ugh, coders' repetitive stress injury.)

So check out the tutorials. Play with code. Tell me about your triumphs.

Code Review: My first Powershell function

13 Dec 2023 🔖 powershell tips 💬 EN

I’m lucky to have enthusiastic, experienced PowerShell programmers at work. When I showed off my first attempt at writing a “hello world” function, they gave me an hour of their time to review and correct it.

Continue Reading

Trunk-based Git branching

13 Dec 2023 🔖 git 💬 EN

A “trunk-based” strategy for creating and deleting “branches” of a Git repository can drastically reduce conflicts when teams collaborate on editing a shared file.

Continue Reading

What is Azure DevOps?

12 Dec 2023 🔖 devops git azure 💬 EN

Azure DevOps is a suite of software products. Let’s take a look at them.

Continue Reading

How many Entra App Registrations do I need?

25 Oct 2023 🔖 security devops integration git azure 💬 EN

Creating an App Registration (and its corresponding Service Principal) in Microsoft Entra ID (formerly known as “Azure Active Directory,” “Azure AD,” or “AAD”) lets a code-deployment-automation “CI/CD pipeline” (such as an Azure DevOps Pipeline or a GitHub Action) access the Azure cloud resources onto which you’d like to deploy your code.

But just how many of them do you need per project / application / workload?

Continue Reading

Variables and secrets for CI/CD pipelines

03 Aug 2023 🔖 devops integration git azure 💬 EN

Azure DevOps Pipelines and GitHub Actions both let you store variables and secrets in their services, for use with your CI/CD automations, but they’ve arranged them in pretty different parts of their settings options.

Continue Reading

Git best practices with Azure Data Factory

31 May 2023 🔖 devops integration git azure 💬 EN

Are you intimidated by all of the options when trying to add Git tracking to Azure Data Factory (“ADF”)? Check out my top tips!

Benefits include:

  • Easier collaboration when many people need to work on the same factory at the same time.
  • Easier auto-synchronization of content between closely related factories.
Continue Reading

Reuse your Flows with Subflow

12 May 2023 🔖 professional development salesforce 💬 EN

Thanks for coming to watch “Reuse your Flows with Subflow.”

Video, slides, and a session recap can be found below.

Continue Reading

Quick -- I need a blank scratch org

11 May 2023 🔖 salesforce 💬 EN

Whew! As I prepare to talk about subflows (sign up now!), I’m working my way through old usernames and passwords to Salesforce dev orgs and realizing they’ve mostly expired, now that I no longer work the old job to which all the reminder emails were being sent.

Continue Reading

Azure DevOps vs. GitHub repositories and pipelines

09 May 2023 🔖 devops git azure 💬 EN

If you work at a Microsoft-oriented corporation that leverages Azure’s public cloud heavily, you might be using Azure DevOps for version-controlling source code repositories with Git and for automating build / test / deploy processes against those codebases.

Do you wonder if you’re missing out by using Azure DevOps instead of GitHub?

Below are some strengths of each tool. I’d love to hear your additions in the comments.

Continue Reading

Deploying a built webapp onto Azure App Service with ADO Release Pipelines

18 Mar 2023 🔖 web development minimum viable build beginner devops git azure 💬 EN

In this series, we’ve:

  1. Coded a tiny webserver.
  2. Added unit tests.
  3. Git-tracked our codebase in Azure DevOps (“ADO”) Repos and set up proper editing hygiene rules.
  4. Taught ADO Pipelines to “build” our codebase into a ready-to-run webserver runtime codebase every time Git detects we’ve edited the codebase.
  5. Told ADO Pipelines not to bother doing so if our unit tests fail.

All that’s left is to let the world see our amazing website! Let’s do that today.

See the sample codebase on GitHub.

Continue Reading