Thursday, 25 August 2011

CRM Deletion Service in CRM 4.0 and CRM 2011. Asynchronize

http://www.7388.info/index.php/article/silverlight/2011-07-18/19565.html
http://blogs.msdn.com/b/emeadcrmsupport/archive/2011/06/28/crm-deletion-service-in-crm-4-0-and-crm-2011.aspx

All activities of the Deletion Service are based on table named ScaleGroupOrganizationMaintenanceJobs, which can be found in the MSCRM_CONFIG database.
You can use the following sample script to delete all records marked for deletion immediately. As direct database manipulation is not supported, this should be done only in test and not in productive environment.
--The time you set is UTC time so you need to minus 11 or 12 hours as NZ time is UTC + 12:00
USE MSCRM_CONFIG
UPDATE dbo.ScaleGroupOrganizationMaintenanceJobs
SET NextRunTime = getdate()
WHERE OperationType = 14

--To check the time for the next job to run
USE MSCRM_CONFIG
select NextRunTime
from dbo.ScaleGroupOrganizationMaintenanceJobs
where OperationType = 14

By default the SQL Server agent will trigger the job MSCRM_CONFIG.HardDelete every hour. This job will execute the stored procedure p_HardDelete, which will perform the deletion itself.

If the SQL Server Agent is not running, you have to wait on the Deletion Service itself. By default, the frequency of the Deletion Service job execution is set to once a day.

p_HardDelete is different from the Deletion Service. p_HardDelete seems to only delete internal Entities' record.

You can use the Scale Group Job Editor tool to change the execution frequency of the Deletion Service (Download here: http://code.msdn.microsoft.com/ScaleGroupJobEditor).

Possible values for the OperationType attribute can be found here:
http://msdn.microsoft.com/en-us/library/bb887932.aspx

Tuesday, 23 August 2011

Model View ViewModel in WPF

Binding is an important concept in WPF implementation of the Model View ViewModel.

Step 1: Bind the UI component with data model in XAML.

Step 2: Implement the INotifyPrepertyChanged interface in the ViewModel

Reference:
http://msdn.microsoft.com/en-us/library/system.windows.data.binding.mode.aspx
http://msdn.microsoft.com/en-us/library/ms743695.aspx

This is how the View associated with the ViewModel

This is how the ViewModel associated with the Model.
The Code is in the parent ViewModel.







Thursday, 18 August 2011

Microsoft Dynamics CRM 2011 User’s and Administrator’s Guides

Microsoft Dynamics CRM 2011 User’s and Administrator’s Guides

http://blogs.msdn.com/b/crm/archive/2011/08/16/microsoft-dynamics-crm-2011-user-s-and-administrator-s-guides.aspx

Tuesday, 16 August 2011

CRM 2011 Development Resources

Just found this wiki with a lot of helpful dev resources for CRM 2011, the Javascript Web Resource Manager looks pretty handy!

http://social.technet.microsoft.com/wiki/contents/articles/microsoft-dynamics-crm-2011-development-resources.aspx

Sunday, 14 August 2011

Increase crm time out/timeout

http://support.microsoft.com/kb/918609

If this is from CRM 2011 Online to On-Premise then make sure your SQL box has enough RAM and CPU to handle import or publish.

Three areas you can increase:
1. Web Config timeout values
2. Registry timeout values
3. SQL Timeout values

The SQL timeout update script below will increase the timeout from the default of 30.

USE MSCRM_CONFIG
GO
UPDATE DeploymentProperties
SET IntColumn=9000
WHERE ColumnName='SqlCommandTimeout'

Friday, 5 August 2011

Flight against slackness - Ways to nudge yourself to do what you should do.

Scenario:
You know you should study that all the jokes and news are so attractive out there. So here is a few ways nudge yourself to do what you should do.

* Time limits - e.g. Tell yourself I have 45 min to do sth. Plus SUMMARIZE WHAT YOU HAVE DONE AT THE END.
* Make it a habit - fix the time - e.g. study between 7 pm to 11pm every Sat.

Monday, 1 August 2011

Crm 4 Filtered Views empty - returns no record

That is because the windows and sql login account is not associate with a crm user with correct crm permissions