December 15, 2015

Dynamics CRM 2013 SQL – System Jobs Monitoring

Last one for today.. Another instance of me using SSRS to send me emails every day, just so I can keep track of system wide errors. […]
December 15, 2015

SilverPop (CoreMotives) – Dynamics CRM 2013 SQL -Triggered Emails Count

Another one… Use this for daily SSRS subscriptions because I’m too lazy to log into the server to check. Plus there’s no aggregation available on the […]
December 15, 2015

SilverPop (CoreMotives) – Dynamics CRM 2013 SQL – Submitted Data Extract Query

Ran into a limit using the CoreMotives web form result export button from our on-prem CRM (2013) deployment so I wrote a little SQL script to […]
March 3, 2015

CRM Email Router strikes again

Spent a day and a half trying to figure out why our CRM Email Router hasn’t been playing with others. Managed to find out why today. […]
March 3, 2015

iTrent / People Manager – Site not Responding.

Rare for me to blog something not Dynamics/SQL-y based, but this one is more of a note to self. Had an issue where 2 departments were […]
March 2, 2015

Dynamics CRM 2013 – Anonymous SMTP

Run this on SQL: Update DeploymentProperties set BitColumn = 1 where columnname = 'AllowCredentialsEntryViaInsecureChannels' Update DeploymentProperties set BitColumn = 1 where columnname = 'ECAllowNonSSLEmail' Do this […]
March 2, 2015

If it doesn’t restart without wanting to install updates…

CTRL+R -> CMD -> shutdown /r /t 0 God bless command prompt. God not-bless windows updates downloading without permission. God bless me not having to manage […]
December 11, 2014

CRM 2013 / SSRS – The SELECT permission was denied on the object ”, database ”, schema ‘dbo’.

Ran into this issue yesterday whilst doing something I consider a cardinal sin (Writing CRM reports in SQL). No errors appeared whilst running the report in […]
December 2, 2014

500 internal server error – Interesting one

Have been deploying an upgrade to an application, had a few issues with SQL report performance (Which our DBA kindly fixed) – Not the overall issue. […]
November 28, 2014

CRM 2013 – The attribute “” cannot be found for entity “”. Specify a valid query, and try again.

Working in a multi-tenant environment with CRM 2013 and have come across this error when trying to build reports. This issue was probably never an issue […]