Author: Kailash Ramachandran

As a Software Consultant by trade, I excel in the intricate art of designing and developing software applications, skillfully navigating through complex technical puzzles. My professional life revolves around programming, but away from the computer, I'm an ardent sports aficionado. I actively participate in a variety of sports, savoring the exhilaration of competition and the joys of physical exertion. In moments of respite from the adrenaline of sports and the focus of coding, I retreat into the rich realms of literature. My love for reading is eclectic, spanning various genres, each quenching my endless curiosity and love for storytelling. More recently, I've embarked on a journey into writing, a venture where I channel my thoughts and imaginative flair into written expressions, exploring this new avenue of creativity with enthusiasm.

SSRS convert UTC datetime value to local datetime

For any Dynamics 365 developer, at one point in time they might encounter issues with the datetime fields in CRM. The challenge always comes when we working on backend, because there is always a confusion in the mind whether the date time value is UTC or local time. When working in reports, fetch-xml dataset have … Continue reading SSRS convert UTC datetime value to local datetime →

SSRS Fetch-XML query report with requirement to transform rows to columns

Creating custom SSRS report is inevitable when there is a requirement to manipulate data that you can't achieve it using report wizard or saved query. The custom report is very good old feature of the CRM that is will come to rescue. Custom report development in On-Premise version of CRM have added benefits and challenges. … Continue reading SSRS Fetch-XML query report with requirement to transform rows to columns →

Deploy Azure resource/resource group using template deployment

Azure is the buzzword for any developer whether you are working on-premise or online systems. In recent time any project you are involved, you can't avoid seeing project artefacts hosted in Azure in some form, whether it is a storage, repository, api, batch jobs, virtual machines, etc. Develop using Azure makes life easy compared to … Continue reading Deploy Azure resource/resource group using template deployment →

Accessing Azure Key vaults secret from Azure Function

Securing your confidential configurations while implementing cloud solution is vital, Key vaults service helps in securing those critical configurations that are used as part of the implementation. Key vaults secret are easy to consume from any compute service that you are used part of the implementation. In this article I am going to walk through … Continue reading Accessing Azure Key vaults secret from Azure Function →

Access XML file in Azure SQL database where the file is stored in Azure BLOB storage

Accessing files that are stored in BLOB storage during the run-time is a common scenario in most of the implementation. This can be easily achieved when the BLOB container is public faced. In the case of the private containers Shared Access Signature (SAS) facilitate the need of both authenticate and authorization of the file. This … Continue reading Access XML file in Azure SQL database where the file is stored in Azure BLOB storage →

Launch a New Entity Form within a Modal Popup with Data Prepopulated

In certain cases, there's a need to open a new form filled with prepopulated data, which could be derived from a parent record or set to specific default values. The NavigateTo method is designed to streamline this process, allowing for seamless navigation to a chosen table list, table record, HTML web resource, or custom page, … Continue reading Launch a New Entity Form within a Modal Popup with Data Prepopulated →