4 min read
BizTalk Server WCF-SQL: Invalid object name while using temporary tables
Sandro Pereira
Apr 23, 2024
It is common to use temporary tables to implement internal logic in your SQL queries or scripts I have seen it used several times, for example, inside
2 min read
BizTalk Server WCF-SQL: The certificate chain was issued by an authority that is not trusted.
Sandro Pereira
Apr 18, 2024
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
2 min read
BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...
Sandro Pereira
Apr 9, 2024
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
3 min read
BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...
Sandro Pereira
Apr 8, 2024
Today, while importing/generating a WCF-SQL schema for a new BizTalk Server solution, we got the following error inside Visual Studio: Error while
4 min read
PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption
Sandro Pereira
Mar 15, 2024
A few days ago, Luis Rigueira created a Kusto query to identify Logic Apps Consumption workflows that use SQL V1 actions and triggers These actions will
4 min read
Logic Apps Consumption SQL Connector version 1 Actions/Triggers will be deprecated!
Luis Rigueira
Mar 14, 2024
Microsoft announced that it will deprecate Version 1 actions and triggers of the SQL connector for Logic Apps by the end of March 2024 As a result, existing
2 min read
Note to myself: How to easily count the number of Jobs in SQL Server Agent Jobs?
Sandro Pereira
Oct 17, 2023
This is another post for the sake of my mental sanity I keep looking up this information again and again Therefore, I decided to write it down once and for
2 min read
SQL Script to monitor BizTalk Server SQL Jobs
Sandro Pereira
Sep 21, 2023
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
3 min read
A fish out of water: How to check what SSIS packages are running and stop them?
Sandro Pereira
Jun 23, 2023
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
