Is there a lack of Dynamics Consultants

I read this article today on the revamped dynamics world website, which is a lot greener but some of the pictures don’t seem to load is my first thoughts.

They had an article with the title of Lack of dynamic consultants

There has been a lack of Dynamics Consultants and Developers for some time. Microsoft in the UK has attempted to make small steps to combat the issue with little success.

Today, basic development isn’t the issue. Huge teams outside of the EU can complete implementations quicker and cheaper than UK and other Northern European based companies. This is largely due to excellent, cost effective training programmes, which are often run by large resellers. The aim of these facilities is to train new staff, often just managing to break even, not to make a profit. Something I thing the European market could learn from.

Consequently, face to face Consultants are in high demand across Europe and the US, which inevitably drives up rates. Partners spend millions of pounds on implementations and upgrades and need the work completed properly. They are feeling squeezed between lack of affordable resources and the need to have the work completed to the standards they require. A complaint that has been put to Microsoft.


The article isn’t really focused on the number of CRM consultants in a company basis but more a global problem.  I was thinking about the number of CRM consultants and if Microsoft’s sales figures are to be believed (and I have no reason to think otherwise) then there has been a great deal more CRM work done over the last year and there will be in the future as well.

You should also take into account the CRM cloud offerings might not need much consultancy or development work because I guess a lot of these will be standard deployments without much customization.

Looking towards the future I think there will be more Microsoft CRM work in the future as Microsoft gains more market share from it’s rivals, I also think the customers which took the standard CRM offerings in the cloud will start to push CRM more and once they are used to CRM they will start to extend it.

I suppose in the short term this will push up prices for CRM work whilst the industry increases the number of CRM specialists

CRM 2011 – Tool – Ribbon Browser for Microsoft Dynamics CRM 2011

The excellent CRM tools creator Tanguy has woken from his slumber and created another interesting tool to make our lives easier in CRM 2011.

He has created a tool to browse the Ribbon in CRM 2011.  I have to admit the Ribbon is a bit of a tricky beast to get used to, so any help with working with it is very welcome indeed.

you can find the tool at his blog (where you can also donate some money if you are feeling generous) here

or you can go to codeplex and download it

Project Description
This tool helps developer to browse ribbons in Microsoft Dynamics CRM.

It makes easier to identify ribbon controls properties.

Application Prerequisites
This application requires the following components installed:

  • Framework .Net 4
  • Windows Identity Framework

Application Screenshot

Ribbon Browser

CRM 2011 – How to increase the records per page to more than 250 rows

I had an unusual problem today, I wanted to delete 3000 accounts which I had imported into a test organisation (to import them again without the missing data)

I thought I would do this using the advanced find but I could only delete 250 at a time.  So I decided to increase the row limit.  Unfortunatly there is no way to do this using the system so you have to adjust the setting on the SQL database table directly.  This is obviously unsupported so I would definetly think carefully about doing this on a customer site, also if you extended this value you will be retreiving more rows of data when using CRM and this will put more strain on the SQL server.

What I am saying is if you were to change this value for some end users CRM might start to work slower because you will be retrieving more records when you are viewing accounts, contacts, orders etc in CRM.

you need to open SQL Server Management Studio and then create a new query for the organisation database


here is the sql you need to run

SELECT SystemUserId, FullName FROM SystemUser WHERE FullName = 'your name'
SELECT SystemUserId, FullName FROM SystemUser WHERE FullName = 'Ben Hosking'

then you use the guid value you have just retrieved and run the sql below
UPDATE UserSettings SET PagingLimit = WHERE SystemUserId = ''

UPDATE UserSettings SET PagingLimit=1000 WHERE SystemUserId = '2A01D976-322E-E011-9645-00155D106B02'

You can set back the rows returned by using CRM and going into


and then on the General tab you can set the Records per page