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

ADFS Supported Configurations


09 Mar 2015

CRM 2011 and 2013 uses Active Directory Federation Services for Internet-facing deployments.

The folowing table describes the supported configurations for combinations of ADFS an CRM versions.

    CRM 2011 CRM 2013 CRM 2015 Notes

ADFS 2.0

For Windows Server 2008 and 2008 R2

Must be downloaded and installed

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

Chart Reference


21 Mar 2014

Chart XML

The chart XML defines the following:

fetchcollection Data to be charted, the query expressed using FetchXML
categorycollection Contains a <measurecollection> for each series 
presentationdescription Defines the chart types to use, chart legend, axes, axis properties

 

Series

 

Sandbox instances in Microsoft Dynamics CRM Online


06 Oct 2017

The Feb 2014 (6.0.2.43) build of Microsoft Dynamics CRM Online changed the way test instances are managed. They are now named sandbox instances and are marked as so in the user interface with a SANDBOX watermark.

Future releases will add new capabilities to sandbox instances including:

  • Reset an instance
  • Copy a production or sandbox instance into a sandbox

This blog article on MSDN provides the details.

Security groups required by Microsoft Dynamics CRM 2013


07 Mar 2014

Microsoft Dynamics CRM uses several security groups in Active Directory.

Pages