Author Archives: Eric Weberg

Cosmological Horizon

Posted on July 30, 2023 by Eric Weberg

I love the correlation between Hawking radiation and, a term new to me, Unruh radiation. That math is beyond me, but I can certainly appreciate it’s revelations. I am inspired that humanity has learned enough to determine that the universe … Continue reading →

Posted in Musings, Science | Leave a comment

IAW. WTF.

Posted on October 24, 2022 by Eric Weberg

I’m not sure why I occasionally see the acronym “IAW” scattered through some docs. My guess is that it’s an industry-standard phrase, but MAN does it ever come off as stilted. My business documentation hackles are rising. “Personnel shall be … Continue reading →

Posted in Business, Musings | Leave a comment

Simple SQL to count related records

Posted on August 18, 2021 by Eric Weberg

Here is a basic example of how to use a subquery to return a total count of records. This is particularly useful to show an aspect related to some info that you are working with. This example would count the … Continue reading →

Posted in Programming, SQL Server | Leave a comment

PowerBI YearMonthDay in formatted new column

Posted on May 6, 2021 by Eric Weberg

This formula will create a zero-padded Year/Month/Day Weekday in PowerBI. For example: 2021/06/15 T Create a new column, and update the formula to use your table name and column name. (‘history'[date] in the formula below.) DateYMD = Year(‘db_datareader uvw_aca_wipinfo'[end_time]) & … Continue reading →

Posted in PowerBI | Leave a comment

Python datetime

Posted on March 27, 2021 by Eric Weberg

WTF?!All I want is to display the program runtime, and start time and end time. I need to import 3 libraries (time, datetime, and maybe timedelta) and STILL need to extract individual values for Year Month Day Hour Minute Second … Continue reading →

Posted in Musings, Python | Leave a comment

What not to do when working a support issue

Posted on September 4, 2020 by Eric Weberg

Don’t make your customer work to get your assistance. They’re already suffering a problem. It’s your job to (try to) help them overcome whatever they’re facing, whatever that may be. Could be that your job is to help them understand … Continue reading →

Posted in Business, Musings, System/DB Administration | Leave a comment

Dynamic Titles in PowerBI

Posted on August 31, 2020 by Eric Weberg

TL;DR: Copy this code into your DAX formatter. Selected Program = VAR _program = IF ( ISFILTERED ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ), IF ( HASONEFILTER ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ), IF ( ISBLANK ( SELECTEDVALUE ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ) ), “Unspecified programs”, … Continue reading →

Posted in Business Intelligence, PowerBI | Leave a comment

Responding with regard

Posted on August 21, 2020 by Eric Weberg

Thought-provoking, https://www.industryweek.com/leadership/article/21139049/a-leadership-skill-thats-rarely-taught-but-sorely-needed Particularly intriguing: It affects your body more than you cialis order know. If order prescription viagra you consume alcohol, then it can disturb your sex life, so you can avoid drinking alcohol. In few cases men do viagra … Continue reading →

Posted in Business, Musings | Leave a comment

Testing in Low Code environments

Posted on July 29, 2020 by Eric Weberg

I’ve seen a fair amount of discussion recently about migrating business systems to self-tagged “low code” solutions. This shifts the burden of testing from code (unit / static) and integration tests into more of a business-process test – nearly integration … Continue reading →

Posted in Business, Project Management, System/DB Administration | Leave a comment

Automated functional tests of User Interfaces

Posted on April 29, 2020 by Eric Weberg

This was a dialogue of the concepts behind the automation of indirect functional and integration testing via the events and controls of a User Interface (UI). “NamePlateValidation has a good example of an automated UI functional test. It sends keystrokes … Continue reading →

Posted in Uncategorized | Leave a comment