About

Success is always inclusive – We feed each other in Heaven

One of my favorite stories- Allegory of the long spoons

About this Blog: 

This blog acts as a simple notebook for arranging my thoughts and daily experiences/challenges faced during Integration with Microsoft BizTalk Server.

About Me:

My name is Prashant Kumar Singh, I live in Bangalore-India.

I am working as in Integration Architect in one of the biggest MNC.

My area of expertise is integration using Microsoft Technologies specially BizTalk Server, Azure Integration Services – Logic Apps, API Management, Microservices – AKS etc.
I’m an active blogger, youtube creator and a participant on the MSDN BizTalk Server Forums.

I have worked with companies like Microsoft, HPE, Fidelity and Wipro Technologies.

This blog acts as a simple notebook for arranging my thoughts and daily experiences.

If it benefits you in any way, I will deem the motive of writing this blog is fulfilled.

Please do not hesitate to leave me a comment or directly email me in case you need any help or if you have any suggestion.

DISCLAIMER:
The views and opinions stated in this blog are mine and do not necessarily reflect those of my employer. Each posting on this blog is provided “AS IS” with no warranties, and confers no rights.

Contact Me:-

@Gmail, @Facebook, @LinkedIn, @Twitter, @MSDN Technet Profile, @My Personal Blog Site

• Mail
• YouTube
• Facebook
• Twitter
• LinkedIn
• Link
• WordPress

Check out my blog’s categories –

• Azure Data
• Azure Integration Services
• BizTalk
• BizTalk Automation
• BizTalk High Availability & Disaster Recovery
• BizTalk Migration
• Desired State Configuration(DSC)
• ESB Toolkit
• Logic Apps
• Powershell
• SQL

Logic Apps Secure SQL Connection String in Azure Key Vault

While using SQL Connector in Logic Apps we don’t get a straightforward way to fetch/store connection string in Key Vault or in config. By default, the connection string we provide goes and sits in the Configurations as shown in the pics below and is in plaintext format. The regular process to use SQL Connector -…

by Prashant Singh May 31, 2023

Save Full File in SQL table Column (varbinary) and read the contents back in t

What if you needed to save full file as-is to a SQL Server table column. I ran into a similar scenario and had to save CSV Files in a table. For this we created a table with a column of type “varbinary” CREATE TABLE [dbo].[TableWithCompleteFiles]([SNo] [int] IDENTITY(1,1) NOT NULL,[FileName] varchar NULL,[FileContent] varbinary NULL) ON [PRIMARY]…

by Prashant Singh May 20, 2023

Export SQL Table content as CSV File to a File Location

Recently, I got a request to save the contents of the table to a File. Wroking Command – Above commands will fail with below error – Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1 [Batch Start Line 43]SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’ because this component is turned off…

by Prashant Singh May 20, 2023

Advertisement