Français
Presentations About Resources

Salesforce, Python, SQL, & other ways to put your data where you need it -- a bilingual blog in English & French

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.

Recompile dependent PL/SQL code after changes

27 Apr 2020 🔖 sql databases tips 💬 EN

Reminder: If you edit and recompile PL/SQL stored an Oracle database, you need to keep “dependencies” with other code in mind. You may need to ensure that other stored code relying upon your code is also recompiled.

Continue Reading

Writing & graphics for scheduled Facebook Live videos

21 Apr 2020 🔖 music 💬 EN

Want to take advantage of Facebook Live’s “scheduled” streams? Before you even log into Facebook or touch your tablet, pull out a pen and paper – you’ve got some creative marketing work to do.

Continue Reading

Livestreaming Music Diary - Facebook Live

20 Apr 2020 🔖 music 💬 EN

If you work in tech, you fix the printers for your family. During shelter-in-place, I’ve had a new duty for close friends and family: improving and running musical livestreams.

Continue Reading

Jitterbit Hosted API Tutorial: 302 Redirect with Cloud Studio

02 Apr 2020 🔖 jitterbit api integration tutorial 💬 EN

First, let’s build a Jitterbit API endpoint that performs a “302” HTTP redirect to https://example.com/ using “Cloud Studio” to flesh out the back-end behavior.

Continue Reading

Jitterbit Hosted APIs: Hello World tutorials

02 Apr 2020 🔖 jitterbit api integration tutorial 💬 EN

Jitterbit’s ETL (“Extract, Transform, Load”) platform allows you to “borrow” their web servers and use them to put URLs on the internet as small “API” endpoints where the back end of those “endpoints” is some sort of data-processing Jitterbit operation you’ve built.

Continue Reading

What is #FlattenTheCurve? Why is everything cancelled?

13 Mar 2020 🔖 health 💬 EN

If you work in technology, you can relate to the feeling of being invisible specifically because you go above and beyond the call of duty, right?

Continue Reading

Netlify CMS Jekyll Minimum Viable Build

21 Feb 2020 🔖 architecture tips git web development 💬 EN

I’m trying to figure out if a friend currently on Wordpress could ever enjoy using a static page builder accompanied by a CMS, or if they just really need the comfort of knowing they can use Wordpress Visual Composer / Squarespace / Wix to move things around their web pages at will. Netlify’s free tier (thank you!!) is going to be really helpful in letting me set up a prototype for them to test drive.

Continue Reading

Door Prize: Excel VBA code for turning your ex-PMI into principal payments

13 Feb 2020 🔖 excel 💬 EN

Excited to see, with Excel, when your mortgage would be free of PMI? Let’s add a little more code showing how much you’d save if you kept paying your old “PMI bill” as “extra principal” payments every month for the rest of your loan.

Continue Reading

Excel VBA code to compute when a mortgage will be free of PMI (Private Mortgage Insurance)

13 Feb 2020 🔖 excel 💬 EN

A friend is trying to come up with a clever way to use Excel to figure out in what month a given mortgage’s principal would have dropped below 80% of the purchase price of the home (at which point they would know longer pay a supplemental fee known as private morgtage insurance, a.k.a. PMI). I didn’t think Excel could do it, but it can.

Continue Reading

Python NumPy code to compute when a mortgage will be free of PMI (Private Mortgage Insurance)

12 Feb 2020 🔖 python 💬 EN

A friend is trying to come up with a clever way to use Excel CUMIPMT / CUMPRINC to figure out in what month a given mortgage’s principal would have dropped below 80% of the purchase price of the home (at which point they would know longer pay a supplemental fee known as private morgtage insurance, a.k.a. PMI).

Continue Reading