You have a query, maybe one you didn’t write. How do you test and validate that the joins are correct? Let’s walk through a simple example. I’m running MySQL with the employees sample database...
Beyond basic SQL – Join Validation
B
You have a query, maybe one you didn’t write. How do you test and validate that the joins are correct? Let’s walk through a simple example. I’m running MySQL with the employees sample database...
Per the README, “Tenacity is an Apache 2.0 licensed general-purpose retrying library, written in Python, to simplify the task of adding retry behavior to just about anything.” I find this...
YData Profiling YData Profiling is data profiler with a FOSS component and a paid upgrade. It is easy to use and powerful – It is a solid choice if you are working in the Spark ecosystem with...
This page describes a high level approach for naming database objects. It is a combination of the abbreviations that I have used used at many clients. It also includes some basic principles from...
Introduction You know your way around the select statement, you can join tables in various ways, use aggregate functions, can alter existing tables and create new objects, etc. But sometimes your SQL...
There are several books that I’ve read over the years that I believe are very educational for the IT professional. These books are not directly related to the craft of writing code (that’s another...
I know, picking on remote controls is low hanging fruit but seriously, a 0/1 power button and a Power Off button? Bonus question, what is the functional difference between what appears to be a select...
Evaluating technical skills comes up in every interview, during employee reviews, and while guiding associates on their career paths. We all focus on the ‘big’ skills are required for the position to...
There are lots of serious articles out there listing n traits that every consultant should have (“resilient”, “forward-thinking”, “good hair”). This is not one of those articles. GET THE JOB DONE...