Utilising SQL Server Stored Procedures with Power BI

Those who have experience working with an RDMS system like SQL Server will become accustomed towards a certain way of going about things. These can often involve a mixture of "lazy" query writing (e.g. using SELECT *... as opposed to SELECT Column1, Column2...), the manner in which you write your query (ALL CAPS or lower [...]

Automatically Publish Duplicate Detection Rules (Dynamics CRM/Dynamics 365 for Enterprise)

For those who are well versed in rolling out solution updates within Dynamics CRM/365 for Enterprise (CRM/D365E), the process will always have a certain familiarity to it, with a few surprises rolled in now and again. Often, the update will proceed as anticipated; sometimes, you may encounter bizarre issues. I can remember a particularly strange incident [...]

Bulk Creating Dynamics CRM/365 for Enterprise Records in C#: Create Request vs. ExecuteMultipleRequest

It is often the case, as part of any application or database system, that certain record types will be well-suited towards duplication. Whilst this is generally a big no-no for individual customer records or invoice details, for example, there are other situations where the ability to duplicate and slightly modify an existing record becomes incredibly [...]