# Referential Integrity
Meilleurs épisodes de podcast
Actualisé:
referential integrity is a property of data stating that all its references are valid. In the context of relational databases, it requires that if a value of one attribute (column) of a relation (table) references a value of another attribute (either in the same or a different relation), then the referenced value must exist.
For referential integrity to hold in a relational database, any column in a base table that is declared a foreign key can only contain either null values or values from a parent table's primary key or a candidate key.
The Worshipful Master: Culture, Alignment, and Referential Integrity
This episode examines the relational function of the Worshipful Master, focusing on how leadership shapes culture by setting conditions rather than performing the work itself. The role is framed as maintaining alignment between intention, behavior, and reality so that people can work together effec…
Stop Losing Inventory: The Power Apps Barcode Fix
(00:00:00) The Importance of Barcode Scanning in Inventory Management
(00:01:17) The Pitfalls of Manual Inventory Management
(00:03:20) The Power of Structured Data Capture
(00:04:20) The Architecture of Inventory Management
(00:08:41) Power Automate: The Compliance Officer
(00:13:12) Power BI: The…
Block Bad Data Before the Write with Nike’s Ashok Singamaneni
In this episode of The Data Engineering Show, Benjamin and Eldad are joined by Ashok Singamaneni, a Principal Data Engineer at Nike. Ashok dives deep into his work on the open-source projects BrickFlow and Spark Expectations. He shares his journey from mechanical engineering to data engineering and…
Excel Is Not a Database: Power Apps Dataverse Migration Explained
(00:00:00) The Excel Dilemma
(00:00:29) The Hidden Dangers of Spreadsheets
(00:02:58) Excel vs. Databases: A Fundamental Difference
(00:04:07) The Three Fatal Failures of Excel
(00:07:49) Introducing Data Verse: A New Paradigm
(00:09:24) Data Verse Features and Benefits
(00:12:30) The Correct Migra…
Power Apps Excel Data: The Power Apps Lie That Breaks Your Excel Data
(00:00:00) The Excel Dilemma: When Spreadsheets Meet Data Platforms
(00:00:16) The Five Failure Patterns of Data Modeling
(00:00:36) The Primary Key Predicament: Unique Identifiers in Data Verse
(00:04:33) The Type Trap: Data Types in Data Verse vs. Excel
(00:08:54) The Lookup Labyrinth: Relationsh…
Model‑driven Power Apps vs Teams and SharePoint: when to skip Dataverse and use Fusion Teams instead
Model‑driven Power Apps vs Teams and SharePoint: in this episode of M365.fm, Mirko Peters dismantles the “enterprise‑grade” mystique of model‑driven apps and shows why most teams would be faster, cheaper, and happier building on Teams, SharePoint Lists, and Power Automate instead. He opens with the…
Dataverse vs SharePoint governance: when your Power Apps must move off lists to scale and stay compliant
Dataverse vs SharePoint governance: in this episode of M365.fm, Mirko Peters explains why starting every Power Apps project with SharePoint Lists feels “free” but quietly creates governance, data quality, and scaling problems that Dataverse was built to prevent. He starts with the convenience trap:…
Power Apps Generative Pages vs Canvas Apps: when to stop pixel‑building and let AI design your app
Canvas Apps vs. Generative Pages Power Apps: in this episode of M365.fm, Mirko Peters explains why clinging to classic Canvas Apps has become self‑inflicted pain—and how Generative Pages with the new App Agent fundamentally change how you should design Power Apps. He starts with the “Canvas lie”: t…
SharePoint is not a database: why your Power Apps will collapse at scale
(00:00:00) The SharePoint Database Myth
(00:00:58) The Illusion of SharePoint as a Database
(00:01:38) SharePoint's Limitations and Performance Issues
(00:04:02) The Scale Myth: When SharePoint Fails
(00:10:06) Relationships and Data Integrity: SharePoint's Achilles' Heel
(00:15:38) Security: A Fal…
Oracle GoldenGate 23ai: The Replicat Process
In this episode, Lois Houston and Nikita Abraham, along with Nick Wagner, Senior Director of Product Management, dive into the Replicat process in Oracle GoldenGate 23ai. They discuss how Replicat applies changes to the target database, highlighting the different types: Classic, Coordinated, and Pa…
MOTEUR DE RECHERCHE DE PODCASTS
Vous pouvez utiliser notre site Web pour rechercher des podcasts3,820,642et des épisodes195,240,327par personnes, lieux ou sujets.
Investir dans le savoir offre le meilleur rendement, c'est pourquoi j'écoute des podcasts.
‐ Benjamin "Llamacorn" Franklin
MODIFIER
Merci de nous avoir aidé à tenir la base de données de podcasts à jour.
