Data, Beer and Devil Horns: CDS AND SharePoint AND SQL

Microsoft's Chris Huntingford and MVP Paul Culmsee bonded over beer, metal music and a desire to "end the great data war" by improving community understanding of Power Platform governance and data management. Paul is an Office/SharePoint guy and Chris is a Dynamics/XRM guy so we learn from eachother and you can learn along with us. Want to work out which is the best data store for your project? Want to understand when it makes sense to premium features?

Rather than compare on features, we instead decided to tackle these complex issues by real-world use-cases. In this third video, Paul Culmsee and Chris Huntingford discuss an approach to an upcoming presentation comparing and contrasting SharePoint, CDS and SQL.

Topics discussed include:
0:20 The "crap threshold" of MS Teams transcriptions
2:35 The upcoming CDS Saturday event and a change of approach to Chris's talk based on what he has learnt over the last few months
5:55 Chris talks about his sliding scale model of personal productivity and innovation to enterprise solutions and how value is perceived and derived.
7:30 Paul talks about a recent experience with a SQL person who viewed CDS through a narrow lens
9:10 Chris elaborates on some of the factors that contribute to CDS cost and what a hybrid solution might look like.
10:25 Paul gives an example of a hybrid canvas/model scenario that builds on Chris's points and reflects on the unified model vs canvas paradigms
12:40 Chris talks the advantages of a "use-case first" approach
14:20 Chris and Paul talk about when to use an embedded canvas app versus a PCF control
18:16 Paul and Chris review some Microsoft slides on CDS vs SharePoint
21:19 Paul and Chris examine SharePoint in relation to collaboration scenario and its sharing capability
23:35 Why collaboration should not be compared to relational records
24:40 An alternate perspective: typical model-driven use cases vs canvas use-cases
32:08 "100 user" rule of thumb for SharePoint scalability? It might be more nuanced!
36:10 Paul's shopping trolley example of usage patterns
40:30 Paul's advice for SharePoint people on understanding CDS
41:38 Chris and Paul discuss the meaning of "semi structured" data between CDS and SharePoint people (and why Chris would never use CDS for a document storage tool)
45:50 Paul and Chris yearn for the day canvas apps support traversing more than 1 entity relationship in CDS
47:20 Chris and Paul go over the CDS "What's in the box" diagram to illustrate just how much is there compared to SQL databases
53:30 Hidden gems still hiding in the (very ugly) old Dynamics admin UI

______________________

CONTACT PAUL
LinkedIn ➝ https://www.linkedin.com/in/Paul-Culm...
Twitter ➝ https://www.twitter.com/PaulCulmsee

CONTACT CHRIS
LinkedIn ➝ https://www.linkedin.com/in/chrishunt...
Twitter ➝ https://twitter.com/TATTOOEDCRMGUY
______________________

COME TO THE PERTH POWERAPPS AND FLOW USER GROUP!
https://www.powerplatformug.com/perth

SEVEN SIGMA BUSINESS SOLUTIONS
https://sevensigma.com.au/

HERETIC'S GUIDE BOOKS
http://hereticsguidebooks.com/