This is one of the most “me” episodes because my professional life’s goal is to create databases that protects the integrity of your data now and in the future. (My non-professional goal is to ride Expedition Everest at Disney’s Animal Kingdom 100 times in one day.)

It is something that seems really hard to get people to care about, but having worked at the same place 3 times for 25 years over 30 calendar years, I know very well that the messes you make are the messes that you (or someone else) will be stuck with. I hate to think that anyone is stuck with my messes for the next 100 years because I didn’t take the time to apply a bit of normalization and some constraints on a database just to save a few hours.

Or maybe it is the G-forces that have messed up my brain?

Finally, Louis Davidson gets there, just straight up Data Quality. He t explores the definition of data quality, emphasizing its importance in ensuring that data is fit for its intended use in operations, decision-making, and planning. The challenges of maintaining data quality, such as the need for proper data types, constraints, and normalization to prevent errors and ensure consistency, are all discussed. The video also touches on the complexities of concurrency in databases and the importance of designing systems that align with customer needs. Overall, he highlights the critical role of data quality in effective database management and application development.

Hope you enjoy, drop comments on this page, on the Youtube video, or just send me an email at louis@drsql.org. Thank you!

Apple Podcasts – Spotify – Youtube (Video)