Knowledgebase

Welcome

Welcome to my knowledgebase, which contains snippets of information that I find (mostly about Microsoft Dynamics 365/CRM) and then forget.

You are most welcome to browse and if any of the information helps you in your work with Microsoft Dynamics CRM then that is great.

Use the search box or the tag links to search for articles.

I’m an experienced Microsoft Dynamics 365/CRM Consultant and Microsoft Certified Trainer available for hire on an ad-hoc basis. Please contact me to see how I can help with your Microsoft Dynamics project. Find out more about me.

Recently updated articles

Document Management Entities


20 Jul 2017

Record types involved in Document Management

Entity Purpose
SharePoint Site A SharePoint site
Dcoument Location

Point to a SharePoint document library or folder.

These can be created automatically by Dynamics 365/CRM

SharePoint Site

SharePoint site records can use an absolute URL or a relative URL.

Entities related to Goals


14 Jul 2017

The following entities are used in Goals:

Files and how they are stored in Dynamics 365/CRM


13 Jul 2017

Files can stored in Dynamics 365/CRM in emails or against notes. The following entities are used to store the file.

Entity containing file Entity where file is stored  
Note annotation

Details of note and the file (if there is one)

Information about Dynamics 365 July 2017 update - Version 9.0


03 Jul 2017

Pre-release docmentation from Microsoft on the July 2017 update:

SQL Joins


03 Jul 2017

Note: The word Outer is optional

Join Type Description Example Code
Inner Join

Rows that are in both tables (by id)

select * from tblA

inner join tblB

on tblA.id=tblB.id

Full [Outer] Join All rows from both tables even if there isn't a match

select * from tblA

Pages