Blog

The Latest from Ardalyst

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…

Read
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…

Read
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…

Read
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!….

Read
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…

Read
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,…

Read
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…

Read
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…

Read
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…

Read
More