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

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

Microsoft Dynamics 365/CRM Version Numbers and Code Names


29 Jun 2017
Product Name Version Code Name
Fall 2017 ? ?? Calcium
July 2017 ? 9.0 Potassium
365 Dec 2016 8.2 Centaurus
2016 SP1 and Spring 2016 8.1 Naos
2016 8.0 Ara
2015 (Online only) 7.1 Carina
2015 7.0

Pages