by ·0 Comments

Working with Dynamics 365 Customer Engagement (D365 CE), at some point or other companies end up needing to connect other system to it. There are different ways to do this connection using OData API calls, using the DataVerse Power Platform Data Flows, and other techniques. Through this article a considerably basic scenario is constructed to … Continue reading Connecting to D365 CE instance using PowerShell module (Microsoft.Xrm.Data.PowerShell)

by ·0 Comments

One of the very reasons to work with JSON files is their ability to represent data as objects and arrays, in simple or complex combinations. When working with JSON files that represent data which was joined from different sources, there is a tendency of ending up with objects containing arrays of other objects. However, the … Continue reading Array concatenation from JSON file using Azure Data Factory

by ·0 Comments

Working with Azure SQL Server, is very similar to working with the traditional on-premise SQL Server. However when it comes to managing users some differences start to become apparent. The first noticeable difference is when trying to create a new login or user. The traditional and user friendly dialog will not appear but instead a … Continue reading 4 Steps to add an SQL managed user to Azure SQL Server

by ·0 Comments

When working with Azure Storages security of data is a common topic of discussion. With the latest changes in Azure, the security of the data at rest is now by default. It is also possible to set the transfer of files to use TLS 1.2 for further security. However a commonly missed security setting is … Continue reading Securing an Azure Storage File Share behind a Point to Site (P2S) VPN