Blog

Featured

There must be one and only one site map in the system

While working on adding an additional Dynamics CRM Web Server to an existing installation, I came across an interesting error that I spent a lot of time troubleshooting. I hope…

Provision Resources in Microsoft Azure Like a Champion

What do you do when you want to continuously test your code in environments that match your production environment in a way that is cost-effective? Or, what do you do…

Deploying Microsoft CRM USD

In my previous blog post, I outlined the Case for Microsoft Dynamics CRM Unified Service Desk (USD). The project in that post has entered its second phase with the third…

The Case for Microsoft CRM Unified Service Desk

The Case for Microsoft CRM Unified Service Desk For the last 20 years, I have seen technology go in a virtual circle. When I started my career, I worked at…

Sitecore and Dynamics CRM: Driving User Experience and Product Catalogs

So I have talked about linking Dynamics CRM and Sitecore here and here, but I just wanted to drive home a sample use case for linking these systems together. Lets say…

Disabling automatic database upgrades when upgrading Microsoft Dynamics or installing updates

When managing multi sever Dynamics implementations for our clients. It has always been beneficial to disable the automatic database upgrades which occur when you are either doing a full version…

How to connect Microsoft Azure SQL to Office Access

In my previous post here, we discussed how to assign Office 365 permissions to Azure SQL databases. In this post, I will explain how to setup a ODBC connection with…

"Invalid User Authorization – The user authentication passed to the platform is not valid" error after upgrading to Dynamics 365

Above is a fairly common but vague error which I tend to run into often when doing a in-place upgrade, or organization import,/restore into deployment manager. This error generally appears for Dynamics 365 on-prem…

How to setup Azure Active Directory/Office 365 Authentication with Azure SQL database (PaaS)

As more users are starting to move their SQL workloads to the cloud, one of the common questions is how to setup user authentication with their Office 365/Azure Active Directory…

Use CREATE OR ALTER For New SQL Object Scripts

When scripting out SQL Server objects in earlier versions of SQL Server, you’ve historically had the option to do so with “CREATE”, “DROP and CREATE”, or as “ALTER” scripts. Each…