-
Continue reading →: SQL Server- Troubleshoot ‘String or binary data would be truncated’ error
In one of my Data Migration requirement, I had to join data from multiple tables and move to a single table. Requirement is complex as data is around 20 GB and table has around 300 columns. So, I built a Stored Procedure to join tables and move data to single table,…
-
Continue reading →: SQL Server- Drop If Exists (DIE) Objects
Other day, I generated my Database SQL Script including script to create Tables, Procedures, Types, Views etc., using Tasks -> Generate Scripts… option which I had to deploy on my test instance. ‘Generate Scripts’ generate the SQL script with ‘CREATE’ statement (i.e., It will have ‘CREATE Table’, ‘CREATE PROCEDURE’ etc…)…
-
Continue reading →: Web API Helper Code Compilation Error
I was creating a console application to connect to Dynamics 365 Web API, and downloaded “Microsoft.CrmSdk.WebApi.Samples.HelperCode” NuGet package. I got “AcquireToken method is no longer available” compilation error, when I build the project Reason & Fix: We have to use UserPasswordCredential class in ADAL v3. Below is the code snippet…
-
Continue reading →: [Fix] AADSTS65001: The user or administrator has not consented to use the application
I was getting below exception when I was trying to connect to D365 Web API from console. Reason: Issue was the Application registered on ‘Azure Active Directory’ was not granted the Permission Fix: Connect to the Azure Active Directory admin center, using O365 credentials. Select the ‘Application’ from the ‘Azure…
-
Continue reading →: [Code Snippet] Authenticate and Perform Operations using D365 Web API and C#
As a continuation to my last article Different ways to connect authenticate dynamics 365 , lets see how to Authenticate Dynamics Web API using C#. Note: Be mindful that this approach is different than connecting to Dynamics 365 using Microsoft.XRM.Tooling.Connector dll approach. This article explains how to connect to D365 using…
-
Continue reading →: D 365 Development – Different ways to connect/authenticate Dynamics 365
There was a question posted on my blog by a Dynamics 365 newbie developer on how to authenticate to Dynamics 365 online from his console application. In this article I am going to detail various ways to connect to Dynamics 365. Option 1 – Connect using Dynamics 365 SDK assemblies:…
-
Continue reading →: Troubleshoot and Fix – Unable to access FTP folder error
I was working on a POC/Prototype to read files from FTP location using console, for which I configured a FTP Site in my Windows 10 machine’s IIS. FTP site connectivity worked fine till I switched my internet connectivity from LAN cable to WIFI, I started getting unable to access the…
-
Continue reading →: Dynamics 365 Portal – October ’18 release – What’s new
With October 2018 release, Dynamics Portals coming up with below features: Embed Power BI visualizations: Administrators will be able to configure and enable Power BI for a portal. This will require an appropriate Power BI license. Customizer’s can use liquid code to embed Power BI dashboards and reports within pages.…
-
Continue reading →: [Step by Step] Restore a Database from Azure Blob to Azure SQL Server
In one of the requirements, we had to move a Database uploaded to ‘Azure Blob Storage’ to Azure SQL Server. If you got a question, why we need to move SQL Database file from Azure Blob to Azure SQL Server, like me, below is a sample scenario Customer IT team,…
-
Continue reading →: SqlError: The backup set holds a backup of a database other than the existing database
I got below error, when I was trying restore a database from Azure Blob Storage to my local SQL server using ‘SQL Server Management Studio (SSMS)’. System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘{DB_Name}’ database. (Microsoft.SqlServer.SmoExtended) Reason: I created a new Database (DB)…
Visitors
2,146,859 hits
![[Step by Step] Beginner : Create a PCF control and add it to a custom page](https://rajeevpentyala.com/wp-content/uploads/2024/12/image-49.png)
Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI 