Featured
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…
Read More
The Latest from Ardalyst
"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…
More
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…
More
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…
More
Migrate Sage ACT! to Microsoft Dynamics CRM
Celedon Partners frequently receives requests from clients interested in migrating from an existing CRM solution to Microsoft Dynamics CRM. One of the more challenging source systems to work with is Sage ACT!….
More
SSRS Reporting in Dynamics CRM Online
We’ve probably all dealt with CRM reports in the past. You know, the built-in FetchXML ones? But how many of us have dealt with a SQL report for an online…
More
Know, analyze and improve your SSRS report’s performance
Part 1. Know your report’s performance SQL Server Reporting Services (SSRS) is a powerful report building and deployment tool that is frequently used by a large number of institutions. However,…
More
How to change the unique name of your Dynamics 365 Online instance
If you haven’t noticed already, Microsoft generates a random unique name for your Dynamics 365 Online instance when it’s provisioned. In my case, my online instance “CrmTestingInstance” was given “org9e92df90” as the…
More
Steps to have SSIS Package Call a WCF Voided Function
I was recently working on a WCF (Windows Communication Foundation) service to keep InsideView’s most recent data in a SQL database. This database served as a cache when updating accounts…
More
InsideView: Get bulk data in JSON Format
If you ran into this article, then like me you’re wondering why the heck the InsideView API doesn’t allow you to pull bulk data in JSON format. InsideView’s justification is…
More