Friday, 24 April 2015

Microsoft Support Lifecycle

https://support.microsoft.com/en-us/lifecycle/search/default.aspx?sort=PN&alpha=sql%20server&Filter=FilterNO

Posted by at No comments:

Tuesday, 17 March 2015

Microsoft Dynamics CRM Date and Time displayMicrosoft Dynamics CRM Date and Time can be very confusing and challenging to work with, especially in scheduling applications. We have solved several challenges with DateTimes and time zones in both CRM Forms and custom portals.
A few CRM Date and Time truths that we have learned along the way:
  • CRM DateTime always comes with time component. There is a setting in creating a DateTime field that defines date only, but all that does is default the time to midnight local time
  • DateTime is saved in database as UTC time
  • DateTime in CRM UI is always shown based on user’s local time zone. This is true even if UI is only showing the date component. This leads to following effect:
    • If user in CST enters  contact’s birthdate as 2/2/1980, this is saved as 2/2/1980 05:00 in DB
    • If user in PST views the contact record, he/she will see the birthdate as 2/1/1980 (because local time for the user will be 2/1/1980 22:00)
  • DateTime retrieved through CRM Web Services is always UTC time
  • DateTime set through CRM Web Services is user’s local time zone by default
    • Note that extra care must be taken to understand whether the call is done with the calling user or a service user
  • DateTime set through CRM Web Services can be defined to be UTC instead
  • DateTime queried directly from SQL table or base view returns UTC
  • DateTime queried from filtered view returns users local time
https://www.powerobjects.com/blog/2012/06/07/crm-2011-truths-about-datetime/
Posted by at No comments:

Friday, 28 November 2014

get Current GCC include path 

echo | cpp -Wp,-v
Posted by at No comments:

Monday, 2 June 2014

Sync Server 2008 R2 with NTP

# Sync Server 2008 R2 with NTP
# ----------------------------
net stop w32time
w32tm /config /syncfromflags:manual /manualpeerlist:"ip-address"
w32tm /config /reliable:yes
net start w32time

Posted by at No comments:

Wednesday, 9 April 2014

Maximum Size of Solution to Import

Maximum Size of Solution to Import

For Microsoft Dynamics CRM Online the maximum size for a solution is 29.296 MB.
For on-premises Microsoft Dynamics CRM 2011, the default maximum size for a solution is 6 MB but this can be increased as needed.
Change the maximum allowed size by editing the <httpRuntime> element in the web.config file for the application. Edit the executionTimeout and maxRequestLengthattributes to allow for the necessary size. After you finish installing the solution you can set it to the size you want.
Posted by at No comments:

SSRS - customer URL Click thru

iif(
 (
  (iif(Fields!customeridEntityName.Value is nothing, 0, 1) +
    iif(Parameters!CRM_URL.Value is nothing, 0, iif(Parameters!CRM_URL.Value = "",0,1))) <> 2),
   System.DBNull.Value,
   iif(Fields!customeridEntityName.Value = "account",
     Parameters!CRM_URL.Value & "?OTC=1&ID={"& Fields!customerid.Value.ToString() &"}",
     iif(Fields!customeridEntityName.Value = "contact",
       Parameters!CRM_URL.Value & "?OTC=2&ID={"& Fields!customerid.Value.ToString() &"}",
       System.DBNull.Value)
   )
)

Posted by at No comments:

Thursday, 27 March 2014

CRM 2011/2013 - SSRS Report Drill Through

iif(
 (
  (iif(Fields!customeridEntityName.Value is nothing, 0, 1) +
    iif(Parameters!CRM_URL.Value is nothing, 0, iif(Parameters!CRM_URL.Value = "",0,1))) <> 2),
   System.DBNull.Value,
   iif(Fields!customeridEntityName.Value = "account",
     Parameters!CRM_URL.Value & "?OTC=1&ID={"& Fields!customerid.Value.ToString() &"}",
   iif(Fields!customeridEntityName.Value = "contact",
      Parameters!CRM_URL.Value & "?OTC=2&ID={"& Fields!customerid.Value.ToString() &"}",
      System.DBNull.Value)
   )
)
Posted by at No comments:
Subscribe to: Posts (Atom)