THE VIDEO https://youtu.be/ChGwSmFxtps THE SYNOPSIS In this video, I answer a viewer question about what Azure ML provides for people who are already familiar with each step of the machine learning process. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems…
Database Normalization–Surrogate Keys in the Logical Data Model?
THE VIDEO https://youtu.be/45PSLlEhGSw THE SYNOPSIS This video serves as a coda, covering one topic I did not include in the main series: do surrogate keys belong in the logical data model? LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all…
Database Normalization–Abnormal Forms
THE VIDEO https://youtu.be/fKu-Dvwki4c THE SYNOPSIS This video covers a variety of topics, effectively wrapping up the series on normalization. We look at data warehousing, including why the Kimball-style star schema is a really bad design in theory but a perfectly reasonably design in practice. We cover the chimera of "overnormalization" and I throw out a…
Use Visual Studio Code Extensions in Azure Data Studio
This topic came up on Shop Talk Monday night and I figured I would write a quick blog post because it caught people there by surprise. Visual Studio Code has a great marketplace with lots of third party extensions. Azure Data Studio, meanwhile, does not have as good a third-party marketplace. Most of the extensions…
Video: Database Normalization–6th Normal Form
THE VIDEO https://youtu.be/Bjf_KGYH2Fc THE SYNOPSIS In this video, explain what Sixth Normal Form (6NF) is and why it slots in as the third most-important normal form. We look at two separate use cases in which 6NF can make sense and I provide some guidance on when 5NF is good enough versus when 6NF is better.…