Sep 5
BizTalk Maintenance Tasks: BizTalk MessageBox database size does not decrease after a shrink
While maintaining and fine-tuning a BizTalk environment this week, I found out, alongside other non-compliances, that the BizTalk MessageBox database size was
May 29
Fixing “Target Principal Name is Incorrect” SQL connection error while trying to vali...
I'm going to start quoting Sandro: "Sometimes the life of a developer is a nightmare, hehe" But it is also fun once you find the solution So, on one of
Apr 24
There was a failure executing the send pipeline: Microsoft.BizTalk.DefaultPipelines.XMLTransmit, ...
I wrote this issue many years ago in this blog post, and I'm revisiting it to add more information about it because today I got the same error while trying to
Apr 18
BizTalk Server WCF-SQL: The certificate chain was issued by an authority that is not trusted.
Today, while trying to generate a new WCF-SQL Schema from Visual Studio, we got the following error: Connecting to the LOB system has failed A
Apr 9
BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...
Following yesterday's blog post, on the same note, when we tried to generate a WCF-SQL stored procedure schema for a new BizTalk Server solution, we got the
Apr 8
BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...
Today while importing/generating a WCF-SQL schema for a new BizTalk Server solution, we got the following error inside Visual Studio: Error while
Mar 15
PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption
A few days ago, Luis Rigueira created a Kusto query to identify all Logic Apps Consumptions that use SQL V1 actions and triggers that will soon be deprecated
Mar 14
Logic Apps Consumption SQL Connector version 1 Actions/Triggers will be deprecated!
Microsoft has announced that Version 1 Actions/Triggers of the SQL Connector for Logic Apps will be deprecated by the end of March 2024 In response, we have
Sep 21
SQL Script to monitor BizTalk Server SQL Jobs
For those who've been following my work, you might recall that I shared a set of PowerShell scripts a while back for monitoring BizTalk Server One of these
Jun 23
A fish out of water: How to check what SSIS packages are running and stop them?
You may already know that I usually use the series A fish out of water when I want to write something that goes a little bit off-topic on my main blog
