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
03 Jul 2017
Note: The word Outer is optional
|Join Type||Description||Example Code|
Rows that are in both tables (by id)
select * from tblA
inner join tblB
|Full [Outer] Join||All rows from both tables even if there isn't a match||
select * from tblA
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|
|2015 (Online only)||7.1||Carina|
16 Jun 2017
With Record Creation and Update rules it is possible to automatically create records in CRM. This is often used to create cases for emails sent to a support queue.
The option Create records for email from unknown senders needs some explanation. If this option is selected then if the sender of an email does not match a record in CRM then the rule will apply and the record (as per the rule creation details) will be created as well as a contact record where the last name is set to the email address of the unknown sender.
11 May 2017
Starting with Dynamics CRM 20xx, the knowledge base article system that has been in the product for a long time is superceded by a new system called knowledge articles.
27 Mar 2017
Enterprise Apps and Plan 1
Individual Apps (Sales, Customer Service, Field Service, Project Service Automation) around £72 per app per user per month or £110 per app per device per month
Plan 1 (which includes Sales, Customer Service, Field Service, Project Service Automation) around £90 per user per month
There is no minimum number of users (previously there was a five user minimum)