January 12, 2016

SQL Server – Change table ownership

We’ve got a 3rd party application we’re having to upgrade which generates tables on the fly, the issue with this is that the database owner (Which […]
January 11, 2016

Dynamics CRM 2013 – Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.

Hit this error on our staging environment today, all of our testing has been going well till this appeared.. CRM -> Settings -> Data Management -> […]
December 16, 2015

SilverPop (CoreMotives) – Dynamics CRM 2013 SQL – Campaign Interactions

Had a request today to pull interactions for a certain campaign today. CoreMotives has a great interaction section which allows you to view information about clicks, […]
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 […]